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
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
