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...
2012-06-27
9,448 reads
Blog Posts
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...
2012-06-27
1,727 reads
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...
2012-06-27
1,620 reads
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...
2012-06-27
5,186 reads
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...
2012-06-27 (first published: 2012-06-23)
17,944 reads
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...
2012-06-27 (first published: 2012-06-24)
2,243 reads
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....
2012-06-27
1,600 reads
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...
2012-06-27
12,348 reads
Using a Symmetric Key
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
2,963 reads
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...
2012-06-26 (first published: 2012-06-22)
4,284 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers