The Final Question

Check out the final question for the DBA in Space contest. It's a math tease that needs research. If you can solve it, and you work with databases, enter the contest at dbainspace.com

Installing SQL Server 2008R2 on a Windows 2008R2 Core Server

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

Raw Materials - The Trojan Horse

Excuse me, was that geek or Greek?

A Temporary Disagreement

Last month, Phil Factor caused a furore amongst some MVPs with an article that dared to suggest that for reasonably small-scale strategic uses, and with a bit of due care and testing, table variables are a "good thing". Not everyone shared his opinion.

Win a Trip into Space

The DBA in Space competition ends this Friday, November 18. You can still enter, and answer all the questions this week. If you work with databases in any way, you're eligible.

Tips for Upgrading a Cluster to SQL 2008 - Part 1

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008

TSQL Challenge 69 - Find the most relevant advertisement based on keyw

Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.

Webinar: Whatever your source control system - seamlessly link it to SQL Server

In this webinar consisting of 30 minutes of software demonstrations followed by Q&A, you will learn how to link your database to your existing source control system within SQL Server Management Studio using Red Gate’s SQL Source Control.

We will also give you an exclusive preview of forthcoming custom scripts features in the next version of SQL Source Control and SQL Compare.

Window Functions in SQL Server

With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.

Organizational Approaches to Master Data Management

This series of technical articles describes organizational approaches to master data management.