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: December 2010

Windows Cluster Scripting with WMI and PowerShell

Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:

  • Only works on Windows 2008 R2 clusters
  • Requires the cluster service which in effect makes it difficult to run remotely except via PSRemoting
  • Implements specialized data types instead of using WMI

Although… Read more

0 comments, 2,385 reads

Posted in Chad Miller on 31 December 2010

PBM and PowerShell

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to automate many of the traditional daily (or more frequent) checklists*. Although PBM is useable out-of-box there are several key features missing:

  • Unable to capture results of policy evaluations…

Read more

4 comments, 2,172 reads

Posted in Chad Miller on 25 December 2010

SQLPSX 2.3.1 Release

We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an excerpt from the release notes:

Added PerfCounters Module

The PerfCounters module contributed by Laerte Junior (blog|twitter), is used for working with Windows Performance Counters, collecting and… Read more

2 comments, 722 reads

Posted in Chad Miller on 11 December 2010

What’s Going on with SQL Server Service Account Changes?

For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in SQL 2005 or higher to change the SQL Service account. Why you may ask well, because according to the documentation Configuration Manager does “magic” stuff to re-ACL things for the… Read more

15 comments, 2,177 reads

Posted in Chad Miller on 10 December 2010