Best Way to Calculate Age

Calendar Display with Language Specific Day/Month names

A stored procedure which takes a year and language as parameters and creates a calendar display for these parameters.

Distributed Transactions

Get a Return Every Time.

This article will show how you can produce a return regardless of variables passed and debugging tool for @SQL String.

TSQL Query

Writing Outer Joins in T-SQL

Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.

TSQL LAB 2 - Writing Conditional WHERE Clauses

Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.

Tic Tac Toe TSQL Style

This allows a player to play tic tac toe against an automated computer.

Removing Duplicate Records

How to remove duplicate records from a table.

Changing a Non-IDENTITY column to IDENTITY and vice versa

This article from new author Thomas Pieries, brings us a few methods for changing a Non-IDENTITY column to IDENTITY and vice versa as well as examining the advantages and disadvantages of each way.