I am just taking a quick show of hands; and maybe some information, if you are willing.  (And if this hasn't happened to you, I apologize for taking up your time.) I have had various problems on multiple installations of Books Online throughout the entire Katmai / SQL Server 2008 cycle.  They have been on both 32 and 64-bit; with / ...

Channel 9 has two screencast that deal with the new geography data type in SQL Server 2008. Saving Virtual Earth Polygons to SQL Server 2008 Marc Schweigert shows you how to draw a polygon on a Virtual Earth map and save it using ASP.NET AJAX, Windows Communication Foundation (WCF), LINQ to SQL, and the new geography data type in SQL Server ...

I just started working on a LiveLesson DVD for Addison-Wesley tentatively titled "SQL Server Fundamentals for the Accidental DBA". The DVD will focus on the essential skills required to work with SQL Server for people that are not full-time DBAs. I will keep you posted as I have more details. For more information about the LiveLesson ...

Introduction SQL Server 2008 RC0 has been out for a while. You can download it here. This post is not a detailed examination of the setup options. There are much better articles and posts out there if you want more information. This post represents one way to get SQL Server 2008 RC0 up and running so you can start learning the new ...

The new SQL Server installation is so different, I thought I would take a second to write about it. For starters, the whole thing is now called the SQL Server Installation Center.   This tool is broken down into seven sections which include the following: Planning - This section gives you access to documentation and allows you to ...

“I sense you skipped SQL Server 2005 in you...  Skipping SQL Server 2005 leads to a bigger learning curve...  A bigger learning curve leads to not knowing the product as well...Not knowing the product as well leads to suffering..Running in compatibility mode 8.0 is the path to the darkside.. SQL Server 2008 (mode 10.0) is the force...May ...

For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Management Studio that is shipping with SQL Server 2008 is going to bring you some surprises, when you try to present a list of databases in Object Explorer.It ...

Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Then, my last week as a DBA at Advanstar, followed by my first week as a Trainer for ...

Remember this post 46 New Dynamic Management Views In SQL Server 2008 CTP6? I just checked SQL Server 2008 RC0 and there are no new Dynamic Management Views when compared to CTP6. Sorry, can't make up any DMVs :-(   Now, if you could do this SELECT CAST('00:15:00' as TIME(0)) + 5 instead of SELECT DATEADD(hh,5,CAST('00:15:00' as ...

In this post, I continue to explore the implications of SQL Server 2008 data compression. It is particularly worth highlighting the fact that SQL Server 2008 data compression is performed at the page level instead of the table level. In other words, when SQL Server 2008 goes about compressing data, it does it one page at a time, and its ...