Get the NULL percentage of values in a specific table dynamically

  Nothing really fancy, but a small script I was now asked twice for. So I thought I publish it for the public and for the reference for others. It simply calculates the percentage of NULL values for a specific table in all columns. The last request was originated from the post here. Be aware…

4

ALM Visual Studio Database Projects Guidance is out in the wild !

  After many months of hard work, collaboration, short weekends and nights, the new ALM Rangers guidance document is out covering Visual Studio Database Projects. Details about the documents and the documents themselves can be found here: Visual Studio Database Guide on Codeplex  You will find a General guidance Specific scenarios HOLs for each topic Solution…

3

Expand :r referenced files for SQLCMD into one file (SQLCmdScriptExpander)

(Updated version available in this blog post) How can we expand files from a .sql file referenced with the :r operator ? Ok, lets make a step back in the past and see how we used to reference files in .sql files and calling them via OSQL or ISQL. The answer is, we couldn’t. We…

5

Script out jobs in SQL Server v2

  For those asking a couple of times if the JobScripter for SQL Server Agent jobs is also available in 2008… here it is ! The only difference is that the version v2 is now targeting to SMO Assemblies of SQL Server 2008 which is version 10.0. This sure means that you are able to…

4