SQL Friday, The Best SQL Server Links Of The Past Week Episode 5

Here we are with another amazing episode of the SQL Friday, The Best SQL Server Links Of The Past Week show
Obviously this week is another slow week, here is what I found interesting this past week in SQL Land:

Failure to load Report Manager due to truncated UserAgent string
CSS SQL Server Engineers write about this issue

A year in review, The 31 best blog posts on SQLBlog for 2008
31 of the best post of 2008 on sqlblog.com

SQL Server 2005 JDBC Driver and Database Mirroring
PSS SQL Server Engineers engineers explain the problem with the JDBC driver and database mirroring

Managing TempDB in SQL Server: TempDB Basics (Version Store: Simple Example)
Explanation of how the version store works, see also these two links:

Managing TempDB in SQL Server: TempDB Basics (Version Store: logical structure) and Managing TempDB in SQL Server: TempDB Basics (Version Store: Growth and removing stale row versions)

Reproducing deadlocks involving only one table
Alexander Kuznetsov shows how you can have one table deadlocks

That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future

*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum