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

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.

SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...

In this article, we’ll discuss how to resolve Managed SQL Server Installer has stopped working when trying to install SQL Server. So the scenario is when you click on “New SQL Server stand-alone ...

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

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...