Recently, while working on a personal project, I found myself needing a lightweight way to deploy database changes to multiple environments. In the past I have used a wide range of methods, ranging from applying the changes manually to applying changes via a diff tool (SQL Compare), to automatically applying manually created change scripts, to automatically applying diff scripts that were automatically generated, to working directly in production..er, pretend you didn't see that one.

An all new version of ChocolateyGUI is out.

Renaming files in a batch using powershell.

In a previous post I showed how to get remote disk information with PowerShell. The script works nice untill you execute it on a server with Mount Points. When executing the following script on a server with Mount Points: Get-WmiObject win32_logicald…

Every DBA managing multiple SQl Servers with multiple instances will know the issues with developpers, project managers and others that don't know the importance of the instancename when they request you to take some action. So you can start some e-mai…

A couple of weeks ago someone asked me why they should upgrade to MS SQL Server 2012. I named a bunch of reasons and only remembered afterwards that the possibility to use Windows Server Core could also be a surplus. Just 2 days later this Case for Core…

I'm preparing my demo's for a MS6235A SSIS training I will be teaching in a couple of days. In one of the demo's I just copy a SSIS package from the file system to SQL Server using the DTUtil from the command prompt with this command: DTUTIL /FILE <…

Using the posh-git code in my own scripts to make my git experience with Visual studio even better. Yep, that's what the title already said.

Where I try to found what the script: means when used when declaring a function. And find it unuseful.

I find the whole tabexpansion thing in powershell intriguing and I was especially interested in what posh-git did. Since I wanted to use that in my own scripts too.