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.

All authors

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

by Chad Miller

SQLServerCentral.com

PowerShell

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

2008-05-08 (first published: 2008-02-15)

2,535 reads

Discuss

InvalidLogins.pl

by Chad Miller

SQLServerCentral

Maintenance and Management

Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2007-02-12 (first published: 2006-08-08)

239 reads

Discuss

SQL Server 2005 Upgrade Analysis Report Stylesheet

by Chad Miller

SQLServerCentral

Miscellaneous

XSLT Stylesheet to produce developer/object oriented html report from SQL Server 2005 Upgrade Advisor xml report file. Name the script sqlupad.xsl and insert the following as the first line in the xml Upgrade Advisor report file. Place sqlupad.xsl file in same directory as the xml report. This stylesheet works against Database Server component reportonly, does […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2007-01-17 (first published: 2007-01-03)

177 reads

Discuss

SQLPing.vbs

by Chad Miller

SQLServerCentral

Lock and Connection Management

Troubleshooting intermitten connectivity issues can be difficult. One approach is to repeatedly test connecting to SQL Server outside of an existing application in order to verify if a server-wide intermitten issue is occurring. This script is used to test remote connectivity to a SQL Server. The script loops in one minute intervals (adjust as needed). […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2006-09-04 (first published: 2006-08-08)

1,402 reads

Discuss

Share Permissions

by Chad Miller

SQLServerCentral

Miscellaneous

Use this Perl script to produce an audit report of both share permissions and NTFS permissions of the shared folders. To report share permissions:Use shareperms.pl -p -SMyServer1 to report on a single server.Or use shareperms.pl -p -SMyServer1,MyServer2 for multiple servers.You can also use a text file as input: shareperms.pl -p -CServers.txtTo report NTFS permissions use […]