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.

Raw Materials - The Temptations of a DBA

Derek hears voices.

Using and Creating Mount Points in SQL Server

This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them.

Resource Governor

If you suffer from runaway queries, if you have several database applications with unpredictable fluctuation in workload, or if you need to ensure that workloads get the memory or CPU they need according to certain priorities, then you need Resource Governer, and you need Roy Ernest's clear explanation of the technology.

Create a Monitoring Server for SQL Server with PowerShell

At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.