Cygwin and Git – Tired of typing your password? Cache it!

I'm a git and cygwin noob. Despite that I like using the command line. It's a bit of mental gymnastics and keeps the mundane from getting mundane. One thing that irritated me though was having to constantly retype my password when pushing or pulling from remote. Through dumb luck I stumbled across the secret config… Continue reading Cygwin and Git – Tired of typing your password? Cache it!

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… Continue reading Where is vsdbcmd.exe in Visual Studio 2012!?!

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… Continue reading SSDT Default Values For Smart Defaults

SQL Bracket Blaster Beta – FREE

BETA-BETA-BETA SQL Bracket Blaster Wish there was an easy way to get rid of all those square brackets that SQL Server Management Studio insists on adding whenever you script out code? What if you could remove them by highlighting some code and pressing a hot key? Well now you can with SQL Bracket Blaster!