SQL Server, JDBC, XA, and Windows 7

One of the Support Engineers on my team approached me the other day and asked if the SQL Server 2005 JDBC driver we ship works out of the box with XA transactions on Windows 7.  I am embarrassed to say that I did not know the answer off the top of my head.  I figured…

0

Empty Windows

I ran into an odd behavior the other day with SSRS 2008.  I was troubleshooting a Reporting Services 2008 issue where the authentication was not properly configured, so the customer would get three login prompts and then a blank screen. Now, anyone who has been supporting SSRS for any period of time is familiar with…

0

New and improved setspn

Ever have one of those “I want to kick myself” when you realize something you had been putting off investigating would have saved you a bunch of time?  I did just the other day. In my role, I am often trying to get SPNs configured properly for SQL Server and Reporting Services (and Analysis Services…

0

UnsupportedClassVersionError – huh?!

I was recently doing some testing with the new SQL Server 2005 v2.0 JDBC driver and couldn’t get the code to run.  Now, as anybody who does Java development in a text editor like myself knows, it is pretty easy to get the wrong CLASSPATH going if you occasionally work with different JDBC driver versions. …

0

GZIP Compression and Reporting Services

I recently ran into a surprising limitation in Reporting Services.  I say surprising because I honesty didn’t know it was a limitation, not because I am surprised at the limitation.  It also turns out that this limitation is unfortunately not documented in the Reporting Services documentation. GZIP (see the Other Uses section of http://en.wikipedia.org/wiki/Gzip) is…

0

Waaay more connections than necessary

We had a dump where we got a .NET OutofMemory exception.   The ASP.NET folks looked at the dump and saw a large number of rooted TDS objects.  I wasn’t sure where those were coming from, so pulled up the dump to evaluate this. 0:033> !dumpheap -stat…0x65400574   11,959    1,339,408 System.Data.SqlClient.SqlConnectionString0x654049c0   11,959    1,482,916 System.Data.SqlClient.TdsParser0x65405fdc   11,958    1,530,624 System.Data.SqlClient._SqlMetaData0x65404744  …

1