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 ...

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 ...

Our Sales Department has some contact management software (ACT 2005 for Workgroups) that requires SQL Server 2000. The only OS we have that will support that is Small Business Server 2003- which also ...