Another great one day training event in Richmond, VA on Jan 30. Be sure to attend.

TSQL Challenge 22 - Filling balls into boxes based on rules and preferences

by Press Release

T-SQL Challenges

T-SQL Challenges

We have got some boxes and balls. Our job is to put balls into those boxes. But, wait a second! The balls should be filled into the boxes based on some rules and preferences configured by the user. Here are the rules.

DevWeek 2010 is Coming Up

by Press Release

SQLServerCentral.com

Reviews

The time has come again for the UK’s biggest conference for .NET developers and SQL Server professionals. Read the press release about this years DevWeek.

Get Your ANSI_NULLs Settings Consistent

by William Talada

SQLServerCentral.com

ANSI_NULLs

William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.

SQL Server Consolidation : how to decide on the right approach

by Press Release

SQLServerCentral.com

pass

The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.

The Dying Administrator

by Steve Jones

SQLServerCentral.com

Editorial

Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.

Celko's SQL Stumper: The Class Scheduling Problem

by Additional Articles

SimpleTalk

T-SQL Challenges

What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!