Attending PASS Summit? Take a great Tuesday precon!

I'm Speaking Graphic_LargeWe’re just two weeks away from the PASS Summit in Seattle,  and there is most definitely still time to get into our Tuesday pre-conference session, “The Enterprise Scripting Workshop“. That’s a full day of training with 100 of your closest friends* for just $495.



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 this 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.

Session Title:      The Enterprise Scripting Workshop

Session Code:    DBA-298-P

Session Date:     10/27/2015

Session Room:  6A



7:30 – 8:30 Continental Breakfast
8:30 – 10:00 Pre-conference Sessions
10:00 – 10:15 Refreshment Break
10:15 – 12:00 Pre-conference Sessions
12:00 – 13:00 Lunch
13:00 – 14:30 Pre-conference Sessions
14:30 – 14:45 Refreshment Break
14:45 – 16:30 Pre-conference Sessions


*May not be exactly 100. Might not be actual closest friends, yet.

You DO have outstanding, free backup and maintenance, right?

It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on, or that you read about it on (or one of our newsletters).

Or it’s possible that you’ve missed the news. So, ahem.

Index Maintenance

We have created Minion Reindex – a free, standalone index maintenance module for SQL Server. It is both simple to install and run (it’s effectively “plug and play”), and deeply configurable. Seriously, just take a look at the highlights sheet.

My favorite feature? How intensely configurable the thing is. Order indexing any which way you want, and add code to run before or after, and so much more. Not to mention the in-app help, and the live logging.


And Minion Backup is our free, standalone SQL Server backup module. Again, simple to install/run, and deeply deeply configurable.  Here’s the MB highlights PDF.

My favorite features here: table configuration that lets you use one single job to run all of your backups. And the easy stripe/mirror/cop/move. Oh yeah, and also everything I said about Minion Reindex counts here, too.

And then there’s the management software you always wanted

In addition to the free modules, we’ve also created Minion Enterprise: a SQL Server management solution that’s absolutely mind blowing.

My current favorite feature might be the Active Directory expansion module. Or maybe the central backup management. Or…no, there are too many. Hit up the highlights doc.

More info! (Ever so much more…)

So here are a few great places to go for each Minion product:

Product Documentation Training More

Minion Reindex



RTF (zip)


Introduction to Minion webinar


Press release

Minion Backup



RTF (zip)


Introduction to Minion Backup webinar

Press release

Minion Enterprise



RTF (zip)

Videos Press release

Free 90 day trial



PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)

The last week of October, we’ll be at the PASS Summit in Seattle, WA.  As some of you already know – and as I said last year – “this is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion mixed in.”  It’s gonna be a blast, again, and so here’s some of the stuff you should know about.


You really ought to register, you know, and while you’re at it you might want to sign up for an all day pre-conference session (a “precon”). We’re giving one this year titled “The Enterprise Scripting Workshop“!

Get on Twitter to connect with other attendees. #Summit15 is the official hashtag, but most of us tend to use the more general #sqlpass.

Denny Cherry hosts an annual PASS Summit First Timer’s webcast, which he records and posts. Check out his site for the recording.

24 Hours of PASS – 24 hours of live, free webcasts – was September 17 and 18. Recordings are here; definitely catch Sean’s precon preview.

Taking part, if you can’t attend

The keynotes and luncheons are usually live broadcast, and you can order session recordings to cuddle up with at home. I suppose you can put on a kilt, go hit a karaoke bar with friends, drink too much, and contract the nerd flu, if it’ll make you feel more like you were at Summit. That’s what I’d do.

Some of the best stuff, if you’re there

Right before the Summit starts:

During the Summit:

  • There’s a first timer orientation on Tuesday night, right before the welcome reception.
  • Come see us in the vendor area! is an official PASS Summit 2015 sponsor, and we’re really excited about it.
  • Hit a luncheon or two:  Women in Technology, and/or the Birds of a Feather (if they’re having it this year…I haven’t heard yet).
  • Drop by the evening events. The Welcome Reception is usually worthwhile, and the Community Appreciation Party was at the quite awesome EMP Museum last year! (No idea yet where it is this year…)
  • There are always more events, so keep an eye on Twitter and on the Summit website for photowalks, karaoke, Kilt Day, and more.

Our Sessions

  • On Tuesday October 27, Sean and I present “The Enterprise Scripting Workshop” precon.
  • I am on a panel with Karen Lopez and Allan Hirt: “Panel: Will the DBA Job of the Future Still Involve DBAs?”
  • And Sean is presenting his outstanding “Monster Text Manipulation: Regular Expressions for the DBA”.

Happy days,
Jen McCown

P.S. For those who missed something in particular from this announcement, email DM or email me with your questions: Jen at MidnightDBA com. Apologies to the rest of you for the cryptic postscript.

Real news, real tech.