Monthly Archives: August 2009

Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare

My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes using Red Gate SQL Backup and Red Gate SQL Compare snapshot files. The script providers a wrapper around Red Gate’s … Continue reading

Posted in PowerShell

Tampabay SQL Server User Group Presentation

I presented a one-hour session for Tampabay SQL Server User Group on Powershell and SQL Server. I’ve previously delivered this session for the Sarasota and Orlando SQL Server User Groups. The presentation and supporting materials are available here: http://cid-ea42395138308430.skydrive.live.com/embedrow.aspx/Public/powershellvtsql|_TBSSUG|_20090818.zip   My thanks to everyone who attended … Continue reading

Posted in PowerShell | 1 Comment

Installing SQL Server 2008 on Windows 7

When Installing SQL Server 2008 on Windows 7 RTM, I encountered a couple of issues. Supposedly you can install SQL Server 2008 RTM on Windows 7. You’ll receive various warnings about compatibility issues which can be ignored and are fixed … Continue reading

Posted in SQL Server

ThrowAway Scripts

Although I tend to write a lot of formal scripts, as part of the development process I’ll explore an object looking at its data and available properties/methods using get-member. I’ll then test individual pieces before glueing things together. However sometimes it … Continue reading

Posted in PowerShell

SQLSaturday #16 South Florida Downloads

I presented a 1 hr session at SQL Saturday #16 session PowerShell and SQL Server Administration: In this sesssion we will look at automating common DBA tasks through Powershell. An overview of the CodePlex project SQL Serer Powershell Extensions will … Continue reading

Posted in PowerShell

Building PowerShell GUIs with Primal Forms

Although PowerShell is best suited for console applications there are times when a GUI interface just makes sense, however hand cranking PowerShell code to display a GUI seems almost anti-productive when we are used to rich IDE’s with WYSIWIG development available in … Continue reading

Posted in PowerShell | 2 Comments