Common Table Expressions

Column Level Permissions

GRANT Column Level Permissions

A Hex on Your Database

BETWEEN

Know your UNION(s), NULL(s), COUNT(s) ?

Identity Columns

When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.

SQL 2005 Restore Script Generator

This script will generate a restore statement with supporting MOVE operations to a new directory structure.

Find for SQL Objects, Entities or Text

Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist