If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.  Read more...

Read more...

The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.  Read more...

This article will show you how to install SQL Server on to a Windows Core Server host.  Read more...

Robert Pearl brings us a few more potential SQL Server 2008 installation issues on Windows 7 and a few workarounds that might help you get around them.  Read more...

MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.  Read more...

The installation process for SQL Server 2008 has many different options. These options allow you more control over your SQL Server Instance configuration. Having this additional control allows you to set up your SQL Server 2008 instances out of the box with the appropriate configuration, like directory structure, accounts, etc. In this article I'll walk you through the SQL Server installation process.  Read more...

You have a Windows 64-bit server and need to install the 32-bit version of SQL Server 2005 Reporting Services on this machine. In this tip I will walk through the steps you need to take for this installation.  Read more...

Because installing SQL Server is so easy it is tempting to cut corners, fail to plan properly and blindly accept default options without considering the alternatives.  Read more...

Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.  Read more...

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.  Read more...

This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.  Read more...

I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.  Read more...

When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error  Read more...

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...

Read more...

This article highlights the steps involved to install SQL Server 2008.  Read more...

Read more...

Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.  Read more...

In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.   Read more...