Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be...

Better Presentations–Hide those Windows

This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL...

Business Intelligence Strategy – Beginning Steps

Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...

Last Weeks Top “Reading” Links #99

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now.

If one instance in a multiserver query presents an...

Parameterization Part 3: Parameter Sniffing

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a...

September 2014 – SQL Server Monthly Maintenance Checklist

image source
It’s time for a monthly reminder to review you SQL Server environment.  As with anything, just because it appears...

Automated Source Control: A Librarian For Your Database Objects, Part 2

I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to...

Friday Followup For August 29, 2014

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

Reblog: August 22 to August 28

Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...