Archive | Uncategorized

Where is vsdbcmd.exe in Visual Studio 2012!?!

Looking for your old friend vsdbcmd.exe in visual studio 2012? There’s good news and bad news. The bad news is it’s gone and it’s not coming back. (see this MSDN thread if you don’t believe me). The good news is there’s a replacement: sqlpackage.exe The path for sqlpackage.exe is typically: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin […]

SSDT Default Values For Smart Defaults

There’s a handy feature in SSDT (SQL Server Development Tools) that will automatically insert a default value into a column when you change it from nullable to NOT NULL. I wasn’t able to track down documentation specifying what the default values for the “smart defaults” were so I hopped into the SQL DB Pros corporate […]

SSRS Sort Legend: It can be done!

While working with a stacked bar chart in SQL Server Reporting Services (SSRS), I needed to change the sort order for the legend without changing the sort order of the stacked bar. Despite the fact I personally think stacked bar charts are a poor way to visualize data people still want to use them. Didn’t […]