Dallas TechFest 2011

You can’t learn something as complex as Powershell in a single hour so we’re going to have another one right away. This class picks up where Part 1 left off and continues with more SQL Server administration tasks. This session will delve more into the day-to-day tasks that will make your life as a DBA much easier and allow you to go to lunch on time.

Have you been wanting to learn powershell but don’t know where to get started, or even why you should bother? This is where you start. Here I’ll show you what powershell is, what it’s all about, how the language is organized, and how to do some real work in SQL Server. Come see why the world is so excited about Powershell and join the club of the DBAs who work faster and smarter. After this session you won’t be a Powershell guru, but you will be able to understand blog examples and continue your learning from other resources. Don’t put off Powershell any longer.

Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success with it.