August HRSSUG/HRNUG Combined Meeting

August 14, 2012

Tonight I presented SQL Server 2012: The Grand Tour to a combined meeting of the Hampton Roads SQL Server/SharePoint User Group and the Hampton Roads .NET User Group. It was a packed house and a great time!

The presentation materials can be downloaded from here.


PowerShell: A Tale of Two Checklists (Slidedeck)

October 24, 2011

In the past couple of weeks, I have been fortunate enough to deliver my new presentation, PowerShell: A Tale of Two Checklists, at the Richmond Code Camp and to the Hampton Roads SQL Server and SharePoint User Group. Thank you to all that attended either and especially those that offered me feedback. As promised, there are the slides from the presentation.

As for my demo script, based on some feedback that I received, I have decided to tweak it a bit before posting it. I want to take some of the custom stuff out and make a version that could be universally applicable. I also want to make it driven by a configuration file so that the file itself does not need to change each time you run it. So, stay tuned and thanks to those that offered these suggestions!

If you missed these events, don’t fret! I am slated to deliver this presentation again at the SQLSaturday event in Washington, DC, on November 5th. This event is free and sure to be a blast! Get more information and register here. Hope to see you there!


Presenting at Richmond Code Camp 2011.2

October 4, 2011

I am honored and excited to have been chosen to present at the upcoming Richmond Code Camp on Saturday, October 8, 2011. My presentation is titled “PowerShell: A Tale of Two Checklists” and is scheduled for just after lunch. This will be my first time presenting at a Code Camp and my first time presenting on PowerShell!  The examples in my presentation are geared towards using PowerShell with Server Management Objects (SMO) to automate SQL Server configurations, however many of the concepts and lessons apply to any use of PowerShell for automation. I have included the session abstract below.

PowerShell: A Tale of Two Checklists

It was the worst of times.  It was the age of foolishness.  I had a long-winded, manual, GUI-intensive checklist for configuring new SQL Server installations.  Automating that checklist with PowerShell and SMO ushered in the best of times and an age of wisdom.  In this session, we will walk through my new automated checklist, make the case for using PowerShell for such tasks, and point those still mired in the winter of despair and manual drudgery towards the spring of hope that is scripting and automation.

If you are in the Mid-Atlantic area and are looking for an excellent learning and networking opportunity, you cannot do any better than the Richmond Code Camp. The folks that run this event have been doing it twice a year for a number of years and it is very well run, free of charge, and there are usually quite a few giveaways at the end of the day. Register here and I hope to see you there!