Monthly Archives: July 2009

SQLSaturday #16 South Florida

I’m giving a presentation at SQLSaturday in South Florida on August 8th 2009. If you haven’t been to a SQLSaturday, they’re free one-day events put on by local SQLPASS chapters. As an added bonus there will be two PowerShell sessions: … Continue reading

Posted in PowerShell

SQL Server Powershell Extensions PowerGUI PowerPack

If you’ve been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven’t PowerGUI is a free utility provided by Quest. It’s both a script editor with PowerShell syntax highlighting and GUI builder for PowerShell scripts. … Continue reading

Posted in PowerShell

Orlando PASS User Group Presentation

I presented a one-hour session for Orlando PASS User Group on Powershell and SQL Server. I had previously given this talk for the Sarasota SQL Server User Group. The presentation and supporting materials are available here: http://cid-ea42395138308430.skydrive.live.com/embedrow.aspx/Public/powershellvtsql|_opass|_20090714.zip   I’d like to thank … Continue reading

Posted in PowerShell | 3 Comments

Powershell Charting with MS Chart Controls

Richard MacDonald’s demonstrates using Microsoft Chart Controls with Powershell in his post, Charting with Powershell. The chart controls are free and work with standard Windows forms. Another nice thing is the ability data bind to any object that implements IEnumerable (arrays, hashes, data tables, etc.). … Continue reading

Posted in PowerShell | 3 Comments

Powershell SQL Server Backup/Restore

I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is adapted from SQL Server Powershell Extensions functions of the same name. SMO 9.0 (2005) and 10.0 (2008) have slightly different methods … Continue reading

Posted in PowerShell