If you write code to SQL Server then you might be interested in this: at the end of 2017 I wrote a tSQLt tdd training course which has helped over 300 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club. The course is free if you are happy to wait 10 weeks to complete it, with 1 lesson being made available per week - if you are in more of a hurry or you would like to help support the project you can purchase the course which makes it instantly available to you.
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5…
Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person “Mr Bert Ernie” anyway I digress, whether you are working by yourself or in a team you sometimes want to change the case of all the keywords in some code.
If you are using SSDT you can use my new SSDT-DevPack tool to do it for you:
If you grab the devpac, any T-SQL keywords in the active document will be made UPPERCASE when you do “tools->SSDT Dev Pack–>Upper Case Keywords” and I will leave it up to your imagination as to what happens when you do “tools->SSDT Dev Pack–>Lower Case Keywords”.
As always, you can map these to keyboard shortcuts, I use Ctrl+K,L for lowercase and ctrl+k,u for UPPERCASE.
Any problems please shout, grab the installer from:
December 10, 2015 - 14:01
It works great.
It works great.
December 10, 2015 - 14:06