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

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

In-Depth Laying the Groundwork for Microsoft SQL Server 2008 Redmond's new database server is a complex product often running mission-critical apps. You can't afford to not get it right. By Josh Jones ...

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

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

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

Microsoft pulled its SQL Server 2014 Service Pack 1 on Thursday after numerous reports of installation errors. Microsoft said it plans to make SP1 for SQL Server 2014 available again sometime "in the ...

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. Many IT professionals live by the maxim that if something isn’t ...

According to Rikalous, installing Business Intelligence Development Studio is necessary. Upon installing SQL Server 2008 you need to select the Client tools option under the Client tools section of ...

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