-
- we're almost there. Soon we'll be able to read while driving: http://t.co/SFPHIWzR
- Are You Using the Right SQL Server Performance Metrics? http://t.co/Szr4svGn
- my #GoogleDrive just crashed for the very first time trying to synch less than 40 SQL scripts. Hmm...
Category Archives: Uncategorized
SQL server powershell war chest – advanced connection provider
in a previous post I covered a basic connection provider, which is nice, but has its limitations. biggest one being that you always have to supply credentials. If you’re like most DBAs, chances are that you usually work on several … Continue reading
Posted in Uncategorized
Leave a comment
Automatically deploying data dude projects with vsdbcmd.exe
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
building your database solutions outside of Visual Studio
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
SQL server powershell war chest – connection provider
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
Working with suppress warnings in Visual Studio Database Solutions
MS Database Projects have come a long way from their humble beginnings especially with GDR and now full integration into VS2010, but plenty of issues remain. One of the more persistent problems is tracking references. Sometimes we just have to … Continue reading
