How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that...

Last Week to Enter the Exceptional DBA Contest

Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward...

Microsoft Data Quality Services in SQL Server 2012

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012.  The...

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .

First, in BOL, for "DBCC...

Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!

 
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...

The New Phone Book Is Here!

I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....

The report execution has expired or cannot be found. [rsExecutionNotFound]

I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or...

Using a Symmetric Key

In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn't Apply to Dropped Databases or Does...

A Fire Drill and Voter Registration

I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...