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.

Conducting a SQL Server Operational Audit

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.

5 (2)

2005-10-24

13,329 reads

Use SQL-DMO and Excel to Quickly Create Reports for Auditors

Auditing SQL Server, or any system, is not an easy task and with new regulations like Sarbanes-Oxley, it is becoming a full time job in some environments. Chad Miller brings us a way that he developed with Excel and some scripting to automate some of the security information for a large installation of SQL Servers.

5 (1)

2005-10-04

11,230 reads

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.

4.89 (9)

2005-08-19 (first published: )

67,763 reads

Blogs

Goal Progress for April 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Daily Coping 7 May 2021

By

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

A notebook, a guideline, and a workshop

By

I've come to the conclusion that most of us need to hear this: You...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Count Group By and CASE

By usererror

Today I learned that Group and Count do not pay attention to "THEN" in...

Best way to automate password reset of sql account

By adrob39

I'm looking to have a timer job every 90 days that runs a ps...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers