[us_page_title description=”1″ font_size=”1.8rem” inline=”1″]

Join me at SQL Intersections for a great lineup this year!

In April, I will be at SQLintersection at the Walt Disney World Swan in Lake Buena Vista, Florida.

This year, you can save $50 on attending by using my last name (MILLER) as the promo code, AND if you register by January 31st, you may be eligible for free hardware as well – a Microsoft Band 2, a Surface 3, or an XBox One.

You can visit the site to see the full lineup of sessions and workshops. I’m going to be presenting two 200-level sessions on PowerShell and Encryption and a Workshop on PowerShell:

SQL Server Encryption
Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. Master the concepts of SQL Server Encryption when you are done with this session.

SMO Internals for High Performance Automation using PowerShell
In today’s fast paced world, automation is becoming a necessity and not a luxury. PowerShell is a powerful tool that allows you to leverage Windows objects and coupled with SMO you have the power to connect to SQL Server objects. This is all great, but not understanding how SMO works, you could find that your automations are not as fast as you would hope, when accessing SQL Server. This session will take you beneath the surface and demonstrate the secret sauce that will help you get the most out of your SQL Server automation scripts and have them perform. Understanding is the key here and we will get you there in this session. Let’s take your automation to infinity and beyond.


PowerShell for the DBA from 0-60 in a Day
Think of how many servers or instances you maintain. Putting tools in your toolbox becomes a critical part of your life as a DBA. How many clicks can be reused? We will be taking you from 0–60 and everywhere in between with how PowerShell fits into a DBA’s day in the life. We will go from getting PowerShell connected to SQL Server to walking away with a toolbox starter kit that will help you get automated and allow you to focus on harder problems than modifying database options or getting information from SQL Server and storing it away for later analysis. The toolbox alone will make it well worth your attendance.

Join me in the quest to become a PowerShell DBA.

Hope to see you there!

Read More

T-SQL Tuesday #61–Giving Back


I like this topic because I think about it all the time.  I have learned so much from others and I am trying each year to ensure that I give back by speaking at SQL Saturday’s across the country.  No one pays for my trips (most of the time) but it is the least I can do for those that have helped me in my career.

Giving back is so much more than just speaking or giving a gift, it is about helping someone replace you in the Community. Mentoring, speaking, teaching and leading.  I lead my SQL Server User Group locally with another awesome guy and I speak at local events thanks to another great guy. In our town we have Utah Geek Events run by Pat Wright who keeps us full of opportunities to give back. I just cannot get enough.

So this year will be full of speaking, leading the group and attending the other User Group locally

Technorati Tags: ,

to ensure that I am available. Not for love given to me but to ensure that if I have experience that someone needs, that I am there to share with no strings, no ego and no agenda. That is how I will give back this year.

I hope to blog more and get more articles written and to support just a little bit more than last year so that people looking to learn will have yet another place to go to get some help. Thanks to all those that have helped me along the way, most of you know who you are and the list would be way too long to list here and I would for sure leave someone out and I would never do that to my #SQLFamily.

Happy Holidays and see you around.

Read More