Network Databases? Is it time to change?

Today Steve responds to a blog post from Microsoft that talks about the viability of placing our database files on network shares.

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.

Don't Criticize Code

For anyone eager for a long-term career in IT Development, humility and tact are probably more important habits to acquire than demon coding-skills. Phil Factor explains why.

The Industry Problem

We have less people studying technical subjects and an apparent shortage of technical talent in the IT field. Steve Jones thinks we might have an industry wide problem.

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.