January 2007 - Posts

• Eminent Microsoft Researcher Jim Gray Missing

  Jim Gray left his home for a full-day excursion in his sailboat and hasn't been seen since. Details within... Read More... Posted Tuesday, January 30, 2007 9:19 AM by KKline | 3 Comments Filed under: People

• Read Index Structure

  Kevin details how to dispaly an index structure the page number and some data for the leaf level pages. Read More... Posted Thursday, January 25, 2007 5:52 PM by KKline | 0 Comments Filed under: Internals

• Spatial Indexing

  New research in spatial indexing may be added to a future release of SQL Server. Read More... Posted Monday, January 22, 2007 12:46 PM by KKline | 2 Comments Filed under: Internals

• The Future of MSDN and TechNet

  Microsoft is publicly vetting future funtionality for the MSDN and TechNet websites at two sandbox websites: www.trymsdn.com www.trytechnet.com Popular features will migrate to the actual websites in the future. You'll notice that search and support are Read More... Posted Monday, January 15, 2007 10:00 AM by KKline | 0 Comments

• SQL Server Supported Service Packs

  Microsoft provides a list of the currently supported service packs and versions of SQL Server at Supported Service Pack List . This useful information can help you plan your support and upgrade plans for supporting older versions of SQL Server 2000. Be Read More... Posted Thursday, January 11, 2007 10:03 AM by KKline | 0 Comments

• Surviving the Data Avalanche Webcast Available

  I hosted a vendor roundtable to a packed house at the PASS 2006 Community Summity. The topic of the roundtable was "Surviving the Data Avalanche" and was a free form discussion about topics related to the enormous upswing we're seeing throughout the SQL Read More... Posted Wednesday, January 10, 2007 10:43 AM by KKline | 0 Comments Filed under: Performance

• A Transaction Log "Ballast" File

  I've done a lot of sessions and articles about performance tuning your SQL Server environment over the years. A common question that comes up is where and how to place the log files of a SQL Server database. Of course, ideally, you'd place the transaction Read More... Posted Monday, January 08, 2007 4:28 PM by KKline | 0 Comments Filed under: Performance

• RAID Example Revisited

  Thanks to several alert readers, I was quickly notified that my posting of RAID explained via a water cooler analogy had been hijacked by a porn site. You can now find the picture at here . Many thanks, -Kevin Read More... Posted Saturday, January 06, 2007 5:07 PM by KKline | 1 Comments Filed under: Humor