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

Minimize permissions for file locations

When we talk about security, we often point to the Point of Least Privilege. I write a lot about applying...

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