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.

InvalidLogins.pl

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: )

239 reads

SQL Server 2005 Upgrade Analysis Report Stylesheet

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: )

177 reads

SQLPing.vbs

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: )

1,402 reads

Share Permissions

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 […]

2006-06-27 (first published: )

264 reads

Blogs

Daily Coping 22 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Altering a Computed Column in a Temporal Table in Azure SQL

By

System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

SQL Server 2016 SP1 to SP2

By Brian.Tran

We are currently on SQL server SP1.  Should we go ahead and apply SP2? ...

Cant cast VARCHAR(MAX) To XML Variable

By Weegee71

Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML...

SQL server 2019 reporting need help

By juliava

Hello sql server reporting 2019, i created temp for 180 days and not sure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers