John Gallardo's Weblog
From Windows Phone
DataContext.Log and Windows Phone
Among the many features that are compatible between Linq To SQL on desktop Windows and on...
Author: John Gallardo [MSFT] Date: 05/27/2011
Now From Windows Phone
Last November I decided to leave the SQL Reporting Services team and join the Windows Phone...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 03/23/2009
Hiding Rendering Extensions
This is documented behavior, but we see lots of questions on it. A good mechanism for...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 07/10/2008
All those temporary files (RSTempFiles)
When you install Reporting Services, we create a few directories: LogFiles ReportManager...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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....
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 03/29/2007
ReportServerTempDB IO Saturation
Reporting Services uses a temporary database for storage of objects which are, well, temporary. For...
Author: John Gallardo [MSFT] Date: 03/21/2007
Aggregating rsExecutionNotFound Posts
The posts about things dealing with rsExecutionNotFound seem to be what people find most interesting...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 08/13/2006
Interviewed for SQLServerCentral.com
Steve Jones recently interviewed me for a regular column he has on sqlservercentral.com. Check it...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 03/16/2006
Changes
Couple of changes since we shipped SQL Server 2005. I have moved from the Relational Engine team...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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....
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 11/01/2005
More Gadgets!
https://microsoftgadgets.com/default.aspxThe "gadgets" folks have updated their blog to include some...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 09/30/2005
XQuery Contains vs Fulltext Contains
The XQuery/XPath 2.0 functions and operators specification defines a function called “contains.” It...
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] 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....
Author: John Gallardo [MSFT] 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...
Author: John Gallardo [MSFT] Date: 09/09/2005