Within MySql Workbench, there’s a feature called “Clean Up SQL” which automatically tidies up your SQL and the indentation automatically.
This is a very useful feature, as your messy SQL then becomes nice and neat. Unfortunately with Microsoft SQL Server Management Studio (SSMS), this feature is not standard.
Luckily I came across the following open source T-SQL formatter library, complete with an add-in for SSMS which adds this functionality – Poor Mans T-SQL Formatter. This plugin automatically formats your SQL, adding tabs and linebreaks etc in order to make it easy to read.
After installing the product, the following folder needs renaming in order to work with the 2014 version of SSMS:
%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\11.0
%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0
This is due to the installer. The installer puts the files in the incorrect place for the 2014 version of SQL Management Studio. Once you have renamed the folder and restarted SSMS, it will automatically add the options to the Tools menu.
Not only does this plugin work for SQL Management Studio, there are also versions for:
Microsoft’s recent announcement regarding the .NET Framework is quite an interesting one, especially for those who are interested in the open source community.
The idea of making the CLR cross platform across Linux and Mac (on top of Windows of course) will make it easier for developers and users alike and remove the need for projects such as WINE.
Within the announcement there was a new version of Visual Studio 2013 called “Community”, aimed at those who are not producing enterprise grade software. Looking at the feature set, it’s comparable to the “Express” versions of earlier releases.
Additionally preview editions of Visual Studio 2015 was released. The new feature of being able to develop for Windows, Android and IOS from one development environment looks quite interesting.