Update all SSRS reports to apply consistent header / footer on demand

Teaching good old SSRS a new trick…

Background
Not too long ago I had a client with a very simple, yet practical requirement: they...

Memory consideration (Windows + SQL)

We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...

Reblog: November 7 to November 13

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

12 Things To Check With SQL Server To Prepare For Winter

Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...

12 Things To Check With SQL Server To Prepare For Winter

Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...

PASS Summit 2014 Wrap Up

This past week of conferences was simply amazing. It was the best week of my career. Period. Now that I’m...

Friday Followup For November 14, 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 Summit 2014 Speaker Idol

For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...

Script to Monitor SQL Server Database Mirroring Status

SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need...

Another good reason to avoid AUTO_CLOSE

Does anybody need another good reason to avoid setting AUTO_CLOSE on a database? Looks like I found one.
Some days ago, all of...