SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.

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:
PowerShell MVP and prolific presentor, Max Trindad will be presenting…

Read more

0 comments, 403 reads

Posted in Chad Miller on 27 July 2009

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 other programming languages. Fortunately there are several 3rd…

Read more

0 comments, 2,502 reads

Posted in Chad Miller on 25 July 2009

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. The editor is a very usable standalone…

Read more

0 comments, 954 reads

Posted in Chad Miller on 24 July 2009

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:
I'd like to thank Jack Corbett and Andy Warren for inviting me to speak…

Read more

0 comments, 556 reads

Posted in Chad Miller on 12 July 2009

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.). This makes working with…

Read more

2 comments, 2,736 reads

Posted in Chad Miller on 9 July 2009

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 and properties at times. For the most part…

Read more

0 comments, 1,907 reads

Posted in Chad Miller on 1 July 2009