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.

Technical Article

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

You rated this post out of 5. Change rating

2006-09-04 (first published: )

1,419 reads

Technical Article

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

You rated this post out of 5. Change rating

2006-06-27 (first published: )

312 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2005-10-24

13,559 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2005-10-04

11,314 reads

Blogs

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

EightKB 2024

By

EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s...

Read the latest Blogs

Forums

How to suppress the info of queries execution in Stored Procedure.

By rkordonsky 63916

I inherited the Stored procedure the whole purpose of it is to populate our...

ssis catalog not showing all executions

By stan

Hi we just migrated to 2019.  Unlike our previous server on which every ssis...

Is there a such thing as connections being made too fast in a package?

By stricknyn

Hi all, SSIS doing some quirky things and I wanted to run a scenario...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers