Tag Archives: SQL server

Automatically deploying data dude projects with vsdbcmd.exe

Posted on January 12, 2012 by mdanielov

In a previous post, I talked about automatically building a database project outside of Visual Studio. Just for the sake of a feeling of completeness, I will also add a script for deploying the said project to a database of … Continue reading →

Posted in Uncategorized | Tagged , , | 5 Comments

building your database solutions outside of Visual Studio

Posted on January 3, 2012 by mdanielov

Visual Studio database solutions provide DBAs with a lot of functionality not the least of which is ability to spot errors before scripts are deployed. One thing to be aware, though that there are three levels of error catching – … Continue reading →

Posted in Uncategorized | Tagged , , | 4 Comments

SQL server powershell war chest – connection provider

Posted on December 22, 2011 by mdanielov

It is clear by now that MS SQL server and powershell are going to be good friends for a long time to come. So a prudent DBA should be building a war chest of script modules that can be reused … Continue reading →

Posted in Uncategorized | Tagged , | 1 Comment