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.

Gaining SQL Server SysAdmin Access

I’ve seen this come a few times at work and I’m sure most you have experienced something similar.

Someone or an application installs SQL Server, doesn’t grant access to the DBA group and asks for DBA support.

In SQL Server 2008 and higher the built-in local administrators group is no… Read more

2 comments, 2,106 reads

Posted in Chad Miller on 22 October 2011

SQL Saturday #85 Orlando 2011 Presentation

Presentation and scripts from my Storing Powershell Output session at SQL Saturday #85 Orlando 2011:

Read more

0 comments, 432 reads

Posted in Chad Miller on 24 September 2011

Managing AlwaysOn with Powershell

Although you can use SQL Server Management Studio or T-SQL to manage AlwaysOn, SQL Server Denali CTP 3 includes 25 cmdlet which together provide complete coverage for creating, confiiguring and administering the AlwaysOn database feature. In this post we’ll look at using Powershell to perform various management tasks for AlwayOn. Read more

0 comments, 1,260 reads

Posted in Chad Miller on 5 September 2011

Recursively Enumerating Local and AD Groups

If you ever need to flatten out groups which may include nested local and AD groups there’s a really easy way to do this in  the System.DirectoryServices.AccountManagement.GroupPrincipal GetMembers method. Here’s some PowerShell code which works against both local and AD groups. The code can easily be adapted into a… Read more

0 comments, 2,155 reads

Posted in Chad Miller on 14 August 2011

Using SMO Transfer Class to Script Database Objects

I’ve spent some time trying to get the SMO Transfer class to bend to my will. I want to script out all objects of a certain type or a select list of objects. As we will see a moment this was a bit a of challenge and it wasn’t until… Read more

0 comments, 927 reads

Posted in Chad Miller on 25 July 2011

South Florida IT Camp Presentation

Presentation and scripts from my Storing Powershell Output session at the South Florida 2011 IT Camp:

Read more

0 comments, 204 reads

Posted in Chad Miller on 24 July 2011

Denali SQLPS First Impressions

I’ve taken a few hours to try out Denali CTP 3 sqlps and noticed some welcome changes.  The biggest change for sqlps is that it has been implemented as module and plain old Powershell host–It’s no longer mini-shell!

SQLPS Host

SQLPS is now regular Powershell host implemented as the familiar… Read more

3 comments, 766 reads

Posted in Chad Miller on 18 July 2011

Creating Icons Files

While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so I started with a quick web search. I didn’t find any PowerShell scripts suited to the task, but did find an excellent  C# WinForm by Haresh Ambaliya:

http://code.msdn.microsoft.com/Convert-Image-file-to-Icon-c927d9f7

Although the… Read more

0 comments, 272 reads

Posted in Chad Miller on 3 July 2011

MVP Award

Today on July 1st 2011, I was pleasantly surprised to be recoginzed as a Microsoft Most Valuable Professional for contributions to the PowerShell technical communities:

To the many who have helped me, Microsoft, and the PowerShell community, thank you!

–Chad Miller

Read more

5 comments, 296 reads

Posted in Chad Miller on 1 July 2011

Counting Licenses for VMs

This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought I’d put together a post.

In June 2009, Microsoft released an update to SQL Server licensing which can significantly lower TCO for SQL Server instances running under VMs for  not… Read more

13 comments, 1,487 reads

Posted in Chad Miller on 28 June 2011

Tampa PowerShell Presentation

The presentation material from the Tampa PowerShell User Group 6/21/2011 meeting on PowerShell ETL is available here:

 

Read more

0 comments, 605 reads

Posted in Chad Miller on 22 June 2011

T-SQL Tuesday 19 Disasters and Recovery

This post is my contribution to T-SQL Tuesday, hosted this month by Allen Kin (blog | twitter).

A first step in any disaster recovery planning is inventorying your database servers. Although having having an up-to-date list of SQL Servers sounds simple enough the reality is in an… Read more

1 comments, 499 reads

Posted in Chad Miller on 14 June 2011

Tampa SharePoint Saturday 2011

I presented a 75 minute session at Tampa SharePoint Saturday on PowerShell Basics.

The presentation and demo scripts can be found here

My thanks to everyone who attended.

Read more

0 comments, 165 reads

Posted in Chad Miller on 11 June 2011

Use ACE Drivers and PowerShell to Talk to Text Files

As a follow up to my SQLRally 2011 Scripting Guy Guest Blog Post which dealt with Excel and Access files, this post explorers working with delimited text files using the ACE driver.

What about Import-CSV?

One of the first things I do when working with PowerShell is first look at… Read more

0 comments, 611 reads

Posted in Chad Miller on 10 May 2011

SQLRally 2011 Scripting Guy Guest Blog Post

Ed Wilson (Blog|Twitter) aka Scripting Guy has series of SQL Server related posts the week of  May 2nd 2011 including my guest blog post. The post, Use ACE Drivers and PowerShell to Talk to Access and Excel, demonstrates querying Excel and Access files from PowerShell… Read more

2 comments, 279 reads

Posted in Chad Miller on 4 May 2011

Upcoming Events

If  live in Central/South Florida or are planning a trip, we’ve got several IT community events worth checking out…

May

SQLRally in Orlando on May 12th through May 13th. Although SQLRally isn’t a free event, but the pricing is extremely low at only $299 if booked by April 12th.  I… Read more

0 comments, 253 reads

Posted in Chad Miller on 8 April 2011

Tampa IT Camp 2011 Lessons Learned Part 2

In part 1 I provide an overview of concept of IT Camp, how the plan was developed by borrowing ideas from similar events, and how we did on venue, sponsors and attendees. In this blog post I provide more details on overall event feedback.

Sessions

SharePoint, PowerShell and SQL topped… Read more

0 comments, 204 reads

Posted in Chad Miller on 3 April 2011

Tampa IT Camp 2011 Lessons Learned Part 1

On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys Admins) community which we called IT Camp. IT Camps are a free, one day learning event for anyone seeking professional development. This event serves IT professionals and students with a… Read more

0 comments, 651 reads

Posted in Chad Miller on 30 March 2011

Tampa IT Camp 2011 Presentation

I presented a one hour session at Tampa IT Camp on SQL Server PowerShell Extensions (SQLPSX): “In this session we will look at how the CodeProject SQLPSX can be used for real world PowerShell automation. Specific topics covered include using ADO.NET, retrieving SQL Server information, SSIS administration, Policy-Based… Read more

0 comments, 212 reads

Posted in Chad Miller on 20 March 2011

To Script or Not To Script

When approaching an automation problem the first questions you must answer is whether you should even invest the time to write a script. There are scenarios where it just isn’t worth your time. Depending on the tools available to you even the task of scripting out every database object could… Read more

1 comments, 206 reads

Posted in Chad Miller on 15 March 2011

Newer posts

Older posts