Sean McCown

Sean McCown is a Certified Master in SQL Server and a SQL Server MVP with 20 years of experience in databases. He is founder and co-owner of the website MidnightDBA.com, where he records free SQL Server training videos and co-hosts the weekly Web show, DBAs@Midnight. He is also co-owner and principal consultant of MidnightSQL Consulting.

10 more do's and don'ts for faster SQL queries

10 best new features in SQL Server 2014

10 best new features in SQL Server 2014

SQL Server 2014 highlights SQL Server 2014 is jockeying for King of OLTP. While completely bypassing BI enhancements, Microsoft has attacked a host of OLTP performance problems from many angles: slow disk performance with...

SQL Server 2014 pushes the pedal to the metal

SQL Server 2014 is a significant release with two overarching themes: cloud and speed -- or, to be specific, Azure integrations and in-memory OLTP (online transaction processing). Truth be told, I'm more excited about the speed...

Is enough ever enough?

It can be really hard dealing with different people in the office.  I mean, there are so many different types of people that there's no way it can always go smoothly.  And then when you throw everyone's agenda into the mix then it...

Microsoft MCM prep guide

I've recently been awarded the Microsoft Certified Master for SQL Server 2008.  And as a result I thought I'd give you my MCM prep guide.  Now, I'm going to be purposefully vague because we're not allowed to reveal any details about...

The hidden cost of falling behind

Companies have long since gotten out of writing their own software.  Most think it's well worth the money to buy a package and either customize it or live with its shortcomings.  Now, whether they're right or not is a topic for...

PASS Summit 2012 Day 3 Keynote

Today's keynote started with a lovely little song by Buck Woddy and Rob Farley.  It was a song of woe and a slow query.  I would sing it for you but I wouldn't do it justice. Then a tribute to Wayne Snyder who ended his speech...

Rock the kilt

Here we are on day 2 of PASS 2011, and it's without a doubt the best day of the Summit. Not only is it the day after the event we, the MidnightDBAs sponsor, but it's also officially kilt day. A few years ago some people started...

PASS 2011 Begins

I'm sitting here at the blogger table at the PASS Summit 2011. I got here Sunday, and it's already been an action-packed week. We spent the first 2 days on MS campus in MVP sessions and I'm already tired. So far the most...

How long is your downtime?

It's always a fine line to walk how much you need to pad your downtime estimates.  The business doesn't want to be down forever, but at the same time they get upset when you run over for whatever reason.  I always pad my tasks...

Forget innovation, get the basics down

As a technologist I'm always thrilled to be able to work with a computer whenever I go someplace.  However, it usually ends in despair because while everyone's trying too hard to make tons of money off of every click, nobody's...

A case against third-party management tools

One of the biggest businesses in IT is 3rd party tools.  And the DB market has almost more than I can even count.  We've got tools for everything from backups to security and defrag.  It's amazing how many of those things there are. ...

Load More