How SQL Server statistics are generated and updated

One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics...

Friday Followup For May 16, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

PASS SQLSaturday Events: June 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...

Teamwork Keeps The Ship Afloat

I’m back from my

on the

with a big on

my face.
Like a good

I took lots (over 1400) pictures of

and

and

I also swam with...

Missing Indexes Script v2

As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a...

Missing Indexes Script v2

Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them...

Powershell Tips–PSEdit

I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked...

ExpressProfiler: The New Kid on the Block

I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...

Password Cracking–Part 1

I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...

Peace Officers Memorial Day and Half Staff

Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...