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.
I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and have started to think about how to improve it going forward.
The first feature of sorts is the ability to clear the connection used by the quick deployer without having to restart visual studio.
Secondly I am pretty convinced that the main thing people use it for is the quick deploy, the tSQLt test builder and I use the keyword formatters so I have moved everything else to underneath a menu item saying “deprecated” - if anyone really wants one of those features then let me know and I will keep it but I will likely remove them at some point.
I am planning on bringing SQLCover into it at some point and I haven’t really been using the mergeui part, I think the better thing is to use sp_generate_merge to generate a merge statement it is much more reliable. If you have a simple table then MergeUi might still be useful to you.
I will publish it to the market place so updates happen automatically, if you want a copy of it go to:
Before I published it I realised that when I wrote the code (a couple of years ago!) that I had taken a couple of shortcuts, one was to always use the 120 version of the parsers instead of whatever the project was set to so I decided to fix that first and then publish - looking over old code is never good ha ha.
It is now published so you should be able to install for vs 2017 and existing installs on 2015 will be upgraded (hope it doesn’t break for anyone, there are lots more users than when I last published it!)
May 10, 2017 - 02:51
Cannot get tSQLt commands to work in VS2015
When I attempt to create a tSQLt test class with the SSDT Dev Pack I receive the following error in the General Output:
Exception creating tSQLt schema, error: Could not load type ‘Microsoft.SqlServer.TransactSql.ScriptDom.TSql140Parser’ from assembly ‘Microsoft.SqlServer.TransactSql.ScriptDom, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91’.
May 31, 2017 - 12:10
hey shane - this should have
hey shane - this should have been included as a dependency, i’ll take a look at it but try installing the latest DacFx from:
this should install the 140 parser bits.
May 31, 2017 - 12:08
This is how I do it
When I want to quit vim I use this guide: https://howdoiquitv.im/how-do-i/quit-vim/ it is great as I can click the copy button and then follow it to get a better explanation.
If I want to find text in files on windows I use this: https://howdoiquitv.im/how-do-i/find-text-in-files/windows/
They are both great resources for beginners.