Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.

Sqlcmd is dead. Long live Sqlcmd

SQL Server 2008 and higher ship with the invoke-sqlcmd cmdlet while SQL Server 2005 and higher includes the sqlcmd.exe utility. Not wanting to take a dependency on invoke-sqlcmd, a few years ago I’d written a simpler variation I called invoke-sqlcmd2 which I’ve updated along with others.

You might think with… Read more

5 comments, 1,902 reads

Posted in Chad Miller on 12 November 2012

Scripting SSIS Package Deployments

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

Automating Deployments

One of the keys areas you should be looking at automation, possibly through scripting is deployments. If you’re doing… Read more

8 comments, 2,328 reads

Posted in Chad Miller on 6 November 2012

Cloning SQL Servers to a Test Environment

I’ve been involved in a project to set up a full test environment of dozens of SQL Servers. The requirements of the test environment where such that they needed to be cloned via V2V or P2V from source servers, the servers would then be renamed and located within a completely… Read more

0 comments, 2,866 reads

Posted in Chad Miller on 5 November 2012

Using Invoke-WebRequest

The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be brought over. Well, I kind like some of the answers I provided in the SQL Server forum and wanted to download them into a text file in case I ever… Read more

0 comments, 1,044 reads

Posted in Chad Miller on 26 October 2012

Upcoming Fall Events

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 IT Pro Camp on Saturday, September 22nd, 2012.

IT Pro Camps are focused on serving the needs of  IT Pro’s (Windows system administrators). This is will be… Read more

0 comments, 562 reads

Posted in Chad Miller on 9 September 2012

Jacksonville IT Pro Camp 2012 Presentation

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

Read more

0 comments, 527 reads

Posted in Chad Miller on 19 June 2012

Jacksonville IT Pro Camp

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

IT Pro Camps are focused on serving the needs of  IT Pro’s (Windows system administrators). After having completed IT Pro Camps in Tampa, South Florida, Orlando, and Sarasota, the Jacksonville IT Pro… Read more

0 comments, 523 reads

Posted in Chad Miller on 3 June 2012

Appending New Rows Only

I saw a question in the forums related to inserting new rows into a SQL Server table only if they didn’t exist. The current solution was using an ADO.NET DataTable , checking for new rows and then pushing the rows back to SQL Server by calling the Update method on… Read more

2 comments, 2,344 reads

Posted in Chad Miller on 27 April 2012

Backup Database Object

I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is easy to solve, but only if you’re familiar with SMO :). Even so, there some more obscure aspects of SMO like URNs which not many people are aware of. If… Read more

5 comments, 807 reads

Posted in Chad Miller on 17 April 2012

Table-Valued Parameter Example

I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case of table-valued parameters is for sending a list or array of items as parameter to a SQL Server stored procedure or function. This is more efficient than parsing strings or… Read more

1 comments, 756 reads

Posted in Chad Miller on 13 April 2012

Transforming Event Log Data

Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module audits all security administration activity to a custom Windows Event log. In this blog post, I’ll described a process to transform and incrementally load the audit data into a… Read more

2 comments, 2,602 reads

Posted in Chad Miller on 23 March 2012

Reconciling SPNs

As part of troubleshooting Kerberos authentication for SQL Server I had to verify SPNs so I thought I’d blog about the process I went through. Sometimes I think a post blog is nothing more than public documentation of  a complex problem …

Get SQL Server SPNs from Active Directory

Before… Read more

1 comments, 948 reads

Posted in Chad Miller on 20 February 2012

Sharing Profiles

A question came up in a class I was teaching:  “How do you share your Powershell profiles across accounts?”

Well, there’s documented way of sharing profiles on the same machine where you create an All Users profile. As stated in help about_Profiles Powershell will look in the following locations for… Read more

0 comments, 400 reads

Posted in Chad Miller on 11 February 2012

Sarasota IT Pro Camp

Join system administrators IT professionals and database professionals in addition to managers at all levels who work with Microsoft technologies for the Sarasota IT Pro Camp on Saturday, February 18th, 2012.

IT Pro Camps are focused on serving the needs of  IT Pro’s (Windows system administrators). IT Pro’s haven’t… Read more

0 comments, 477 reads

Posted in Chad Miller on 4 February 2012

Orlando IT Pro Camp 2012 Presentation

Presentation and scripts from my Storing Powershell Output session at Orlando IT Pro Camp 2012.

Read more

0 comments, 881 reads

Posted in Chad Miller on 31 January 2012

Orlando IT Pro Camp

The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro Camps I’m helping put together the Orlando IT Pro Camp. Register to attend this free event on Saturday, January 21st. Orlando will be even bigger than Tampa or South… Read more

0 comments, 551 reads

Posted in Chad Miller on 10 January 2012

Importing CSV Files to SQL Server with PowerShell

Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off another guest blogger week  (Nov 28th 2011) with my guest blog post, Four Easy Ways to Import CSV Files to SQL Server with PowerShell. The post demonstrates the following approaches to importing CSVs into a SQL… Read more

0 comments, 1,380 reads

Posted in Chad Miller on 28 November 2011

Some SQL Server Security Housekeeping

Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using either T-SQL, a Centeral Management Server and Powershell.

Task #1 Remove a SQL Server Login from the Sysadmin Role

Let’s say you’re given the task to remove a login from… Read more

0 comments, 829 reads

Posted in Chad Miller on 14 November 2011

Delegated SQL Server Administration with Powershell

Providing delegated administration to groups that need to perform various security functions has always been a difficult task, but thanks to Powershell V3 (currently in CTP 1 as of this blog post) and PowerGUI we have new tools to provide a solution.

The Problem

You have groups outside of database… Read more

0 comments, 1,398 reads

Posted in Chad Miller on 7 November 2011

Older posts