Preventing Subscriptions from Blocking Interactive Report Executions

A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server.  They manage a busy...

2010: The Year In Review

“Quitting smoking is easy; I’ve done it dozens of times.” the great American writer Mark Twain once said.

Although I’ve never...

SQL Server Hardware Book

One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working...

Group Level Page Numbering using Reporting Services 2008 R2

Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection)...

SQL Server 2008 Diagnostic Information Queries (Dec 2010)

I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse...

Busy Week

It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL...

Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)

 
One thing I have gotten wrong before, or not elaborated on during a past presentation on mirroring, although Roman Rehak mentioned...

Soft Skills Matter More Than You Think

Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...

Do IF statements cause recompiles?

I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...

T-SQL Tuesday #13– The Business and Disaster Recovery

I’m hosting this month’s T-SQL Tuesday blog party, but that doesn’t mean I can’t participate. I posted the invitation last...