Catch The Enterprise Scripting Workshop in Orange County, Baton Rouge, Albany, or Atlanta this year!

Explaining all the things
Explaining all the things

Sean and I have put together our bazillion (read: like 30 combined) years of SQL Server DBA-ing into one big, shiny pre-conference session that’s coming at you in multiple states of the union!

The Enterprise Scripting Workshop. What on earth is that about, anyway?  The short version is that we teach you the philosophy of managing a SQL shop, not Server By Agonizing Server (SBAS), but with a true enterprise mindset. And no, you do not have to know Powershell before you attend, but it can certainly help.

Our Chicago class this year rated the session at an average 9.4 out of 10! Just a few of the feedback comments from attendees:

I really enjoyed the day, gave me some good perspective…

Great session. I was afraid it was going to be just a bunch of scripting with various languages …It was so much more!

Nice answering of questions with reasons not just one-sided opinions.

Good team work! Hope to attend your sessions in future.

It’s a fun class, and Sean and I really enjoy it too!

Abstract

The database administrator (DBA) life can be frustrating: You rarely have time to innovate because the same tasks fill up your time day after day. Your users are unhappy about how long it takes to resolve “simple” tickets. You need to put big items on hold to manage special requests. As careful as you are, mistakes creep in the busier you get.

In the pre-conference workshop, learn how to develop enterprise scripts with a huge range of uses. A good set of reusable scripts can reduce task time from hours or days to just a few minutes, and eliminate mistakes from your environment.

  • Enterprise philosophy: Tackle simple tasks with the whole environment in mind.
  • Single data store: Define the benefits and uses of a single central database for common-use data and metadata.
  • Choice of tools: Choose the best tool (e.g., PowerShell, T-SQL, SSIS) for the job.
  • Environment ground work: Prepare your environment for enterprise scripting.
  • Real-world scripts: Work through dozens of enterprise scripting issues (e.g., alerting, error handling, multiple SQL versions) as you develop a real enterprise script in class

This session is for DBAs with a basic understanding of PowerShell. It’s for anyone who touches backups or security, maintains databases, troubleshoots performance, monitors disk space, or any of a hundred other DBA tasks. Enterprise scripting is for anyone who has more tasks than time.

Agenda

The morning will be spent largely in discussion and lecture, so the attendee has solid scripting principles to build upon. The afternoon session will be spent largely in actual enterprise script development.

  • Morning
    • Introducing your enterprise
    • Enterprise philosophy
    • The ideal SQL shop
    • Elements of enterprise scripts
  • Afternoon:
    • T-SQL and regular expressions
    • Developing the Script
    • Applying RegEx

Resources

If you’re dying to get started without us, take a look at a few related resources:

Happy days, and see you soon!
Jen McCown
http://www.MidnightDBA.com/Jen