The Enterprise Scripting Workshop

About this Session

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 data professionals. A basic understanding of PowerShell is helpful, but not required. 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

About the Presenters

Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of experience in high-end databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight. He is also an international speaker and the creator and author of the wildly popular (and free) Minion Maintenance tools and is President of MinionWare, LLC.

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, co-hosts the DBAs@Midnight webshow, blogs, reviews, and podcasts. Jen is also an international speaker and co-writes the MinionWare flagship product, Minion Enterprise.