Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
From Windows Phone
DataContext.Log and Windows Phone
Among the many features that are compatible between Linq To SQL on desktop Windows and on...
Date: 05/27/2011
Now From Windows Phone
Last November I decided to leave the SQL Reporting Services team and join the Windows Phone...
Date: 05/24/2011
RS PowerShell Gems – The WMI Provider
For IT administration of a Report Server instance, you will occasionally need to use WMI. We...
Date: 05/26/2010
RunningJobContext.IsClientConnected
I’ve seen a few people get confused over what this error message in the Reporting Services log file...
Date: 06/01/2009
Hiding parameter area when viewing reports
When rendering reports, oftentimes the application would like to minimize as much of the non-report...
Date: 03/23/2009
Hiding Rendering Extensions
This is documented behavior, but we see lots of questions on it. A good mechanism for...
Date: 02/05/2009
Avoid using HttpContext in your reports
On one of our internal mailing lists, someone was asking trying to retrieve some HTTP Headers that...
Date: 01/09/2009
Scaling out the Viewer Control and rsExecutionNotFound
One of the criteria that the report server uses to match the provided SessionID with a stored report...
Date: 08/08/2008
Scaling Up: SSRS 2008 vs. SSRS 2005 (spoiler: 2008 wins)
The SQL Customer Advisory Team just released a Technical Note comparing SQL Server Reporting...
Date: 07/10/2008
All those temporary files (RSTempFiles)
When you install Reporting Services, we create a few directories: LogFiles ReportManager...
Date: 06/30/2008
Joel on Martian Headsets (standards)
I'm generally not a big fan of the "link dump" style blog. However, the latest post on Joel On...
Date: 03/17/2008
More on SSRS 2008 memory management
This is a continuation of a previous posting that I made which introduced some of the memory...
Date: 03/11/2008
Where has John been?
Ok, it has been a little while. But I have been pretty busy lately. His name is Christopher. We have...
Date: 03/11/2008
Memory Management in Reporting Services 2008
One of the big pushes for SSRS 2008 has been to reduce the occurrence of OutOfMemoryExceptions...
Date: 12/10/2007
Ensuring up to date results through URL Access
A pretty common pattern that I see exporting of reports through URL Access using a simple hyperlink....
Date: 10/24/2007
Back from a blogging vacation?
I guess it was an unintended vacation. We've been busy here in the Reporting Services...
Date: 09/11/2007
SQL Server 2008 (Katmai) and Reporting Services
Today the first public release of SQL Server 2008 is shipping. Of course, Reporting Services is...
Date: 06/04/2007
EMF Rendering and Persisted Streams
EMF rendering in Reporting Services has an interesting history. When SSRS first shipped, we did not...
Date: 05/24/2007
Diagnosing Reporting Services Issues
I was poking around some other SSRS blogs from folks here on the product team, and I found this post...
Date: 03/29/2007
ReportServerTempDB IO Saturation
Reporting Services uses a temporary database for storage of objects which are, well, temporary. For...
Date: 03/21/2007
Aggregating rsExecutionNotFound Posts
The posts about things dealing with rsExecutionNotFound seem to be what people find most interesting...
Date: 02/01/2007
Careful when using rc:Toolbar=false
I'm in the middle of reinstalling Visual Studio, and so I thought I would share an interesting story...
Date: 01/31/2007
Mono device makes good -- wins award
From Miguel de Icaza's blog: https://tirania.org/blog/archive/2007/Jan-17.html I had no idea that the...
Date: 01/18/2007
Load Testing Reporting Services
This question came across one of our internal discussion aliases, and it wasn't the first time I had...
Date: 01/15/2007
Diagnosing rsInternalError
You know the one. You try to render a report and you end up hitting the dreaded "An internal catalog...
Date: 12/05/2006
A Great Place to Ask a Question
Recently I have had a couple of people send questions directly to me via the "Email" tab asking me...
Date: 12/05/2006
Transitioning between SOAP and URL Access
The SSRS Web Server supports two basic protocols, SOAP and URL Access. The SOAP API is great for...
Date: 11/17/2006
SQL Express and Reporting Services Catalog
SQL Server Express with Advanced Services SP1 shipped a while ago and it includes Reporting...
Date: 10/30/2006
Session Timeout during execution
Reporting Services has a notion of a user session. This is not the same as ASP.Net's notion of a...
Date: 10/11/2006
Live Reports and rsReportNotReady Error
rsReportNotReady is only supposed to be thrown when a report is configured to run from an execution...
Date: 08/30/2006
Windows Live Writer
The Windows Live folks just released Windows Live Writer. It's a tool which runs on your desktop and...
Date: 08/13/2006
Interviewed for SQLServerCentral.com
Steve Jones recently interviewed me for a regular column he has on sqlservercentral.com. Check it...
Date: 08/03/2006
Should I modify Reporting Services stored procedures?
The answer, is quite simply "No." Someone shot a post from Google Groups through my inbox this...
Date: 06/30/2006
Reporting Services and Windows Authentication
Windows Authentication is good stuff, and rightly so many people are using it in their Reporting...
Date: 03/16/2006
Changes
Couple of changes since we shipped SQL Server 2005. I have moved from the Relational Engine team...
Date: 01/25/2006
Hi Alan
https://blogs.msdn.com/alanga/archive/2006/01/25/517675.aspxAlan is a good friend of mine that works...
Date: 01/25/2006
Using XML value() method to take advantage of a relational index
The Performance Optimizations for XML Data Type in SQL Server 2005 whitepaper written by Shankar...
Date: 01/05/2006
Transforming XML data into a rowset using the nodes() method
Usually there are a couple of scenarios in which you want to take XML data and convert it into a...
Date: 12/15/2005
SQL Server Query Optimizer Blog
Ian Jose, an Architect here in SQL Engine working on the Query Optimizer, has just started a blog....
Date: 11/10/2005
Using fixed values does not result in smaller instances...
XML Schema has an interesting feature where you can define a value as being "fixed". The meaning...
Date: 11/01/2005
More Gadgets!
https://microsoftgadgets.com/default.aspxThe "gadgets" folks have updated their blog to include some...
Date: 11/01/2005
Answer: Fulltext and XML in SQL Server 2005
A little while ago I threw out this quiz regarding XML and SQL Server 2005's full text search...
Date: 10/17/2005
Jinghao blogs about SQL Server in Chinese
Jinghao (my manager here in the SQL Server Engine team) has started up a blog about SQL Server. His...
Date: 10/17/2005
Peter Jackson to Exec Produce Halo movie!
This one is making the rounds here at work. In case you don't recognize the name, he is the guy who...
Date: 10/04/2005
Quiz: Fulltext and XML in SQL Server 2005
Using SQL Server's fulltext engine is a great way to optimize your XQuery statements which use...
Date: 09/30/2005
XQuery Contains vs Fulltext Contains
The XQuery/XPath 2.0 functions and operators specification defines a function called “contains.” It...
Date: 09/21/2005
TEMPDB optimizations for SQL Server 2005 - Help your XML Datatype performance!
https://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx Wei mentions a couple of optimizations...
Date: 09/13/2005
Building an RSS reader in SQL Server 2005
People used to write "Hello, World!" applications in order to demo new languages and technologies....
Date: 09/13/2005
Seeking on the XML Value Index
This might be long, so I am going to cut to the chase right now. If you are using predicates which...
Date: 09/09/2005