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.

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.