Sign in
John Gallardo's Weblog
From Windows Phone
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
LinqToSql
Microsoft
Personal
rsExecutionNotFound
SQL Server
SSRS
Windows Phone
XQuery
Archive
Archives
May 2011
(2)
May 2010
(1)
June 2009
(1)
March 2009
(1)
February 2009
(1)
January 2009
(2)
August 2008
(1)
July 2008
(1)
June 2008
(1)
March 2008
(3)
December 2007
(1)
October 2007
(1)
September 2007
(1)
June 2007
(1)
May 2007
(1)
March 2007
(2)
February 2007
(1)
January 2007
(3)
December 2006
(2)
November 2006
(1)
October 2006
(2)
August 2006
(3)
June 2006
(1)
March 2006
(1)
January 2006
(3)
December 2005
(1)
November 2005
(3)
October 2005
(3)
September 2005
(5)
August 2005
(2)
July 2005
(8)
June 2005
(7)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
John Gallardo's Weblog
Diagnosing rsInternalError
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
You know the one. You try to render a report and you end up hitting the dreaded "An internal catalog exception has occurred" error message. Generally speaking, this is an indication that something very bad happened within the server which is not necessarily...
John Gallardo's Weblog
A Great Place to Ask a Question
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
Recently I have had a couple of people send questions directly to me via the " Email " tab asking me for some specific one-on-one technical support for Reporting Services. I thank you very much for your interest in our product, but unfortunately I am...
John Gallardo's Weblog
Transitioning between SOAP and URL Access
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
The SSRS Web Server supports two basic protocols, SOAP and URL Access. The SOAP API is great for managing the catalog and doing some session management within the context of a report session, but is generally not the greatest thing in the world when actually...
John Gallardo's Weblog
SQL Express and Reporting Services Catalog
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
SQL Server Express with Advanced Services SP1 shipped a while ago and it includes Reporting Services. There is a bit of an annoying issue though. In the Express SKU, the database engine automatically creates databases with AutoClose on. This behavior...
John Gallardo's Weblog
Session Timeout during execution
Posted
over 7 years ago
by
John Gallardo [MSFT]
4
Comments
Reporting Services has a notion of a user session. This is not the same as ASP.Net's notion of a user session, and in fact the two are completely orthogonal to each other. SSRS's session maintains information about which report a user is looking at, the...
John Gallardo's Weblog
Live Reports and rsReportNotReady Error
Posted
over 7 years ago
by
John Gallardo [MSFT]
1
Comments
rsReportNotReady is only supposed to be thrown when a report is configured to run from an execution snapshot, and the execution snapshot has not yet been created. It is a pretty rare occurrence and the whole error code is really meant to cover the small...
John Gallardo's Weblog
Windows Live Writer
Posted
over 7 years ago
by
John Gallardo [MSFT]
1
Comments
The Windows Live folks just released Windows Live Writer . It's a tool which runs on your desktop and lets you publish blog entries to a bunch of different weblog formats. This is a test post on my MSDN blog. So far I think it is pretty cool. It autodetected...
John Gallardo's Weblog
Interviewed for SQLServerCentral.com
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
Steve Jones recently interviewed me for a regular column he has on sqlservercentral.com . Check it out! http://www.sqlservercentral.com/columnists/sjones/sqlserverspotlightonjohngallardo.asp
John Gallardo's Weblog
Should I modify Reporting Services stored procedures?
Posted
over 7 years ago
by
John Gallardo [MSFT]
1
Comments
The answer, is quite simply "No." Someone shot a post from Google Groups through my inbox this morning where some people were having problems with session timeouts (they were seeing rsExecutionNotFound exceptions). Their "solution" was to edit the...
John Gallardo's Weblog
Reporting Services and Windows Authentication
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
Windows Authentication is good stuff, and rightly so many people are using it in their Reporting Services deployments. Lately, there has been quite a rash of questions that people have regarding the inability to connect to their data sources when using...
John Gallardo's Weblog
Changes
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
Couple of changes since we shipped SQL Server 2005. I have moved from the Relational Engine team over to Reporting Services. Its interesting to see the product from a completely different end. At any rate, if you are actually reading this thing then you...
John Gallardo's Weblog
Hi Alan
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
http://blogs.msdn.com/alanga/archive/2006/01/25/517675.aspx Alan is a good friend of mine that works on Expression Interactive Designer. They have a CTP that was just released (downloading it now). Hi Alan!
John Gallardo's Weblog
Using XML value() method to take advantage of a relational index
Posted
over 7 years ago
by
John Gallardo [MSFT]
0
Comments
The Performance Optimizations for XML Data Type in SQL Server 2005 whitepaper written by Shankar gives some pretty good advice for writing your XQuery statements so that they take advantage of an available XML Index. However, oftentimes you will have...
John Gallardo's Weblog
Transforming XML data into a rowset using the nodes() method
Posted
over 8 years ago
by
John Gallardo [MSFT]
5
Comments
Usually there are a couple of scenarios in which you want to take XML data and convert it into a regular relational rowset. In SQL 2000, you probably used OpenXML for this, which works pretty well if you are only working on a single piece of XML data...
John Gallardo's Weblog
SQL Server Query Optimizer Blog
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
Ian Jose, an Architect here in SQL Engine working on the Query Optimizer, has just started a blog . Lots of good tips and practical advice for getting the most out of SQL Server's query optimizer.
John Gallardo's Weblog
Using fixed values does not result in smaller instances...
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
XML Schema has an interesting feature where you can define a value as being "fixed" . The meaning here is basically that an attribute or element has to have a particular value, and if it is not there in the instance, then that value is implied. However...
John Gallardo's Weblog
More Gadgets!
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
http://microsoftgadgets.com/default.aspx The "gadgets" folks have updated their blog to include some gadgets that you can add to start.com . I'm trying out the "Flickr" gadget as well as the "to-do" list gadget. Are you using start.com yet?
John Gallardo's Weblog
Answer: Fulltext and XML in SQL Server 2005
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
A little while ago I threw out this quiz regarding XML and SQL Server 2005's full text search support. As I stated in the quiz, there is a subtle difference between what you can get with contains() and the fulltext support. Specifically, the difference...
John Gallardo's Weblog
Jinghao blogs about SQL Server in Chinese
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
Jinghao (my manager here in the SQL Server Engine team) has started up a blog about SQL Server . His blog is targetting Chinese speakers. However, if you are like me and don't read Chinese you can get the fish to translate it for you .
John Gallardo's Weblog
Peter Jackson to Exec Produce Halo movie!
Posted
over 8 years ago
by
John Gallardo [MSFT]
1
Comments
This one is making the rounds here at work. In case you don't recognize the name, he is the guy who made the Lord of the Rings movies. http://www.xbox.com/en-US/news/2005/1004-x05showcase.htm Peter Moore, corporate vice president of Worldwide Marketing...
John Gallardo's Weblog
Quiz: Fulltext and XML in SQL Server 2005
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
Using SQL Server's fulltext engine is a great way to optimize your XQuery statements which use XQuery's contains function in a predicate . However, a bit of care has to be taken, because sometimes you might get results which you don't quite expect. ...
John Gallardo's Weblog
XQuery Contains vs Fulltext Contains
Posted
over 8 years ago
by
John Gallardo [MSFT]
3
Comments
The XQuery/XPath 2.0 functions and operators specification defines a function called “contains.” It performs a substring match on the two input strings and returns true if the value of the 2nd string is contained in the value of the 1st string. An example...
John Gallardo's Weblog
TEMPDB optimizations for SQL Server 2005 - Help your XML Datatype performance!
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx Wei mentions a couple of optimizations that can be made for TEMPDB heavy applications. Since XML datatype uses TEMPDB heavily for LOB storage, I recommend checking this out and instrumenting...
John Gallardo's Weblog
Building an RSS reader in SQL Server 2005
Posted
over 8 years ago
by
John Gallardo [MSFT]
1
Comments
People used to write "Hello, World!" applications in order to demo new languages and technologies. It seems that all of the demos de jour are RSS applications. Well, in order to continue the trend, I have decided to write a quick RSS reader which uses...
John Gallardo's Weblog
Seeking on the XML Value Index
Posted
over 8 years ago
by
John Gallardo [MSFT]
0
Comments
This might be long, so I am going to cut to the chase right now. If you are using predicates which involve non-string types in your XQuery statements, you want to use typed data. There, I said it. Now lets try to figure out why. The issue basically...
Page 2 of 3 (67 items)
1
2
3