This is both a call to arms and a last notification of the awesome topic being covered at the Chicago Visual Studio ALM User Group tomorrow night.
In my day to day dealings with companies I often find that they are not managing their database in any way ::commence slow head shake:: And in my head I am screaming while I politely smile and calmly ask how they keep track of database changes, how they test updates to the schema, and what their rollback process is. Some companies do actually have some solid processes around those types of things, but many have nothing but a rosary and a case of Redbull. They just backup their servers nightly, and rolling back changes is a nuclear option. There is a better way people!
Ideally, you have you database schema, and any executable database code checked into SOME source control management system. By which I mean you have the SCRIPTS necessary to create those things in source code (see screenshot below). Without a good tool, establishing that can be tedious, daunting, and usually isn’t done, period. One of the things I love about Visual Studio is its slick handling of database asset management (which has been around since VS 2008). In no time at all you can reverse engineer a database schema and all dependent objects into a database project in Visual Studio and check it in. Yes, just like that. That’s of course just the beginning but I’ll keep this soapbox rant short and expand in future musings.
The tools get better and better with each new version and the SDET tools that plug-in to VS 2012 are the best yet. Here is a quick preview of what that experience looks like in Visual Studio 2012. I am running Ultimate but you would have the same look and feel in just plain old Professional as well.
Now if you are still a hard core SSMS user, fear not. You can still get some of the awesomeness of TFS working for you in SSMS, but finding out where to set that up can be tricky. Quick tip, if you already have TFS installed at your company, really you just need the TFS connector and to flip the switch.
And now for the info on the user group, there’s still a little time left to sign up. Do it, DO IT NOW!!
Do you have SQL Server database assets you should be managing? If you have a SQL Server database you certainly do! Do you use TFS to manage your other software assets like architectural diagrams, source code and build scripts? Are you using that same great toolset to manage your SQL scripts? If not, you SHOULD be.
Did you that know some of the same great ALM features that you love about TFS for your source code can be applied to SQL 2005/2008/2012 stored procedures, table definitions, functions and other schema objects? And that's not all, there are also tools for doing schema comparisons, static analysis, unit testing and deployment of your database assets. Jim will be giving an overview of the database tools available with VS and TFS 2012.
This is a meeting NOT to be missed.
Join Us Wednesday, April 24, 2013 from 6:30 PM to 8:30 PM
Location:Microsoft-Downers Grove 3025 Highland Pkwy, Ste 300, Downers Grove
Speaker Bio: Jim Szubryt is the TFS Product Manager for the Enterprise Workforce at Accenture in Chicago and is a Microsoft ALM MVP. His TFS Team supports 2,500 developers in the global development centers and works with teams on implementing ALM processes. His blog can be found here.
Agenda:6:30PM Dinner followed by a presentation and demo at 7pm