Recently organizations, fellow SQL Server MVPs and DBAs have asked me for resources on how to install a SQL Server 2008 Failover Cluster from both a SQL Server and a Windows Server 2008 perspective.

Installing SQL Server on Windows Server 2008 R2 64-bit is not as simple as it appears Most of my test servers are still 32-bit machines. It’s not until recently that I have started to use 64-bit ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.

Ok, by now my first upgrade experience with Katmai is well-documented. So I thought I’d pass along some of my other experiences and some of the things I’ve learned. My Vista upgrade: I have a copy of ...

So I have my new shiny DMZ setup with my RODC and now am trying to setup SQL 2012 on a clean Server 2008R2 server. This server only has access other machines in DMZ, including the RODC. RODC has ...

The Microsoft SQL Query Analyzer is part of the client tools that come with Microsoft SQL Server 2000 Enterprise Edition. It's designed to analyze the SQL queries that you or a program makes that ...

I just did a new server install for a customer and had to install SQL 2008 in trial mode for the 2 instances they run. I had a deadline for the install (in otherwords the customer sent all her ...