SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained….

PLEASE NOTE: This blog post has been updated from its original posting to clarify other details about installation of SQL Server 2008 and Visual Studio 2008 SP1. I must say that I’m personally proud to see our release of SQL Server 2008. I’ve been involved with the product team on this release since its early…

66

Installing SQL Server on Windows 8

One of the things I often try to do is make sure I understand the experience of customers when installing new versions of SQL Server or existing versions of SQL Server on new Windows Operating Systems. So I took a recent tour of the experience installing SQL Server on Windows 8. I thought you might…

35

SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained

The dust has now settled after the release of SP2 for SQL Server 2005 so I thought I would take some time to explain a few details about the re-release of Service Pack 2 and the fixes that have been posted by Microsoft since this re-release. There is much to digest in this post so…

33

TCP Offloading again?!

I have spent probably hundreds of hours on cases involving TCP Offloading and I know most of the signs (intermittent dropped connections, missing traffic in network traces).  However, I have to admit I got burned by it the other day and spent several more hours working an issue than I should have. I was working…

32

How to fix your SQL Server 2008 Setup before you run setup…

Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place? This would include a new installation,…

32

SQL Server 2005 and 2008 Setup Failures (Compressed DATA Directory)

We are always looking at customer issue reports in order to improve our software and your experience.   The SQL Server Setup development team has identified numerous Watson reports of failed setups due to the compression state of the DATA directory. Shown below is a failure I reproduced on my local machine.   The DATA directory has…

26

How to Rebuild System Databases in SQL Server 2008

In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as "rebuild master"). You were required to use the setup.exe program with command line switches. This is no different in SQL Server 2008 but the command line switches have changed some and the process behind the…

22

Fun with Locked Pages, AWE, Task Manager, and the Working Set…

I realize that the topic of “locked pages’ and AWE can be confusing. I don’t blame anyone for being confused on this. I also realize we have blogged and talked about this topic many times perhaps “beating it to death”. And I certainly know this is not really fun to anyone(but it made for a…

20

Upgrade for SQL Server 2008 can fail if you have renamed the ‘sa’ account

UPDATE TO THIS POST: We now have a fix for this problem as documented at 968829  FIX: Error message when you try to upgrade aninstance of SQL Server 2005 to SQL Server 2008: “Wait on the DatabaseEngine recovery handle failed. Check the SQL Server error log for potentialcauses” http://support.microsoft.com/default.aspx?scid=kb;EN-US;968829 However, because this is setup, you…

20

RML Utilities for Microsoft SQL Server Released

    The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005.  The utilities are collectively called the RML…

19