Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: June 2009

SQLPSX Release 1.6

I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions, 2 cmdlets and 12 scripts for working with SMO, Agent, RMO, SSIS and SQL script files.
 
Here's an example of using SQL Authentication:
 
$server = Get-SqlServer 'Z002\SQL2K8' 'sa' 'mypassword'

Read more

0 comments, 656 reads

Posted in Chad Miller on 28 June 2009

Powershell + SMO Error Handling Tips

Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO coded in any other .NET language. SMO uses an error object's InnerException which can be several layers deep and you must traverse the nested InnerExceptions to get to the detailed…

Read more

0 comments, 605 reads

Posted in Chad Miller on 25 June 2009

Adventures in Powershell SSIS Administration Programming

In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with SQL Server Integration Services (SSIS). This post describes the functionality included in the script library including enumerating msdb package stores, getting packages from msdb and file stores as…

Read more

0 comments, 300 reads

Posted in Chad Miller on 19 June 2009

Creating Red Gate SQL Compare Snapshots with Powershell

Co-worker and fellow DBA,, John O'Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out John's blog post here.  

Read more

0 comments, 271 reads

Posted in Chad Miller on 17 June 2009

Give Me a Coconut and Six Months

Tim Benninghof tagged me with the question.
 
"So You’re On A Deserted Island With WiFi and you’re still on the clock at work. Okay, so not a very good situational exercise here, but let’s roll with it; we’ll call it a virtual deserted island. Perhaps what I should simply ask…

Read more

0 comments, 129 reads

Posted in Chad Miller on 13 June 2009

SQLServerCentral Article on Backup Monitoring and Reporting

The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of the solution:
 
  • Powershell is used to collect backup information from a list of SQL Servers which is loaded into a consolidated reporting database
  • A series of queries…

Read more

0 comments, 404 reads

Posted in Chad Miller on 3 June 2009