How to open SQL files in Visual Studio 2012

The default installation of Visual Studio 2012 cannot open SQL documents when you double click on them in Source Control Explorer.  To be able to do that you have to install the SQL Server Data Tools  for Visual Studio 2012 Open the ” December 2012″ update page at http://msdn.microsoft.com/en-us/jj650015 Download and install SSDTSetup.exe by clicking Download …

Save the list of folders in a text file

If you receive a portable drive and want to see the list of folders, you can output it to a text file. To save the list of folders in a text file execute the following command in the command window: dir P: /AD /B >> “C:\folderlist.txt” where P: is the drive letter of the portable …

Conditional compilation symbols in Microsoft Visual Studio

If you need to make breaking changes in your source code that will be deployed later to production, but first have to be tested in the development environment you can include conditional compilation symbols to specify which lines will be included in the application for certain environments. This way you can maintain environment specific versions …