Automatically Rewriting Non-Sargable ISNULLs

Ed Elliott has another update to SSDTDevPak:

How do I get it?

i have now pushed it to the visual studio gallery and will use this for all future updates so feel free to grab it from:

https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5b8a05dc7906.

Also check out T-SQL Clippy.

Related Posts

CI With SQL Server And Jenkins

Chris Adkin shows how to auto-deploy SQL Server Data Tools projects to a SQL Server instance using Jenkins: The aim of this blog post is twofold, it is to explain how: A “Self building pipeline” for the deployment of a SQL Server Data Tools project can be implemented using open source tools A build pipeline can be […]

Read More

Continuous Deployment In A Box

Ed Elliott has been working on a very interesting project: What does this do? Unblock-File *.ps1 – removes a flag that windows puts on files to stop them being run if they have been downloaded over the internet. .\ContinuousDeploymentFTW.ps1 – runs the install script which actually: Downloads chocolatey Installs git Installs Jenkins 2 Guides you […]

Read More

Categories

December 2015
MTWTFSS
« Nov Jan »
 123456
78910111213
14151617181920
21222324252627
28293031