How Local Variable or Optimize for Unknown Resolve Parameter Sniffing

In my last post , we have gone through the parameter sniffing  and possible solutions for parameter sniffing. In the possible...

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

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