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.

Cloning SQL Servers to a Test Environment

by Chad Miller

Chad Miller

I’ve been involved in a project to set up a full test environment of dozens of SQL Servers. The requirements...

2012-11-08 (first published: 2012-11-05)

4,239 reads

Scripting SSIS Package Deployments

by Chad Miller

Chad Miller

Before I delve into the subject of scripting SSIS package deployments, I’m going to take a slight detour and explain...

2012-11-06

6,713 reads

Using Invoke-WebRequest

by Chad Miller

Chad Miller

The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be...

2012-10-26

3,143 reads

Upcoming Fall Events

by Chad Miller

Chad Miller

During September/October I’ll be presenting at several in-person events:

Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...

2012-09-09

1,109 reads

South Florida IT Pro Camp 2012 Presentation

by Chad Miller

Chad Miller

Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.

2012-07-22

1,105 reads

Jacksonville IT Pro Camp 2012 Presentation

by Chad Miller

Chad Miller

Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.

2012-06-19

1,167 reads

Jacksonville IT Pro Camp

by Chad Miller

Chad Miller

Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...

2012-06-03

1,227 reads

Appending New Rows Only

by Chad Miller

Chad Miller

I saw a question in the forums related to inserting new rows into a SQL Server table only if they...

2012-04-27

5,467 reads

Backup Database Object

by Chad Miller

Chad Miller

I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...

2012-04-17

1,803 reads

Table-Valued Parameter Example

by Chad Miller

Chad Miller

I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...

2012-04-13

3,525 reads

Blogs

Unlocking Real-Time Financial Insights: The Power of Microsoft Fabric

Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...

Understanding Lakehouse Permissions in Microsoft Fabric

By Joyful-Craftsmen

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...

The Cost of Not Having a DBA

Does skipping a DBA save money? Wait until your system grinds to a halt,...

Read the latest Blogs

Forums

Union where it matches against only one shared column

Hi folks I have two tables, both with a NAME, START and END fields...

How to update using data from three tables?

I am in the process of migrating from MySQL to SQL Server. I have...

Select Returning Blank Rows

I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers