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

Next>