…brew your own Business Intelligence

Posts Tagged ‘SSDT’

Generating a Database Clean Up Script

Below is a script I recently used on a project to dynamically generate and execute the statements needed to clear all the data out of a database.  It is heavily borrowed from a blog post by Nikola Ilijev.  I just added the parts pertaining to the dropping and re-creating of […]

Read more

Static Code Analysis and SARG-ability

This morning while coding a stored procedure for a SQL Server 2012 SSDT project in Visual Studio, I noticed an interesting little blue squiggly under one of the column references in the WHERE-clause of the statement I was working on.  Curiously, I hovered the mouse over it and was pleasantly […]

Read more