SQL Server with Mr. Denny:



October 10, 2011  2:00 PM

SSRS runs some crappy queries against the ReportServer Database

Posted by: Denny Cherry

While doing some research for my Half Day SQL PASS Session with Stacia Misner (blog | @staciamisner) I discovered that some of the queries which the SSRS engine runs against the ReportServer database are less than perfect total crap.  My specific...

April 21, 2010  3:09 PM

SQL Server 2008 R2 has been Released to Manufacturing

Posted by: Denny Cherry
Powerpivot, SQL Server, SQL Server 2008 R2, SSRS

Microsoft's new database platform SQL Server 2008 R2 has gone RTM.  This means that the code has been locked, and shipped to the DVD pressing company so that they can begin pressing the DVDs. For those looking on MSDN or TechNet to download the RTM version, hold off.  The final version will be...

July 28, 2008  11:00 AM

You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server

Posted by: Denny Cherry
RDL, SQL Server 2005, SQL Server 2008, SSRS

SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren't compatible.  You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won't be able to be deployed to the SQL 2005 report server. With enough major editing of the SQL 2008 report you can convert it...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: