Mapping SQL Server Logins to Database Users

Learn how to save time and prevent permission configuration problems when you move a SQL Server database from one computer to another.

Improve GridView Performance by Delegating Paging to SQL Server

Use SQL Paging to make your grids so fast that you’ll wonder if you really clicked the mouse button.

Using Optional Stored Procedure Parameters

Learn how to handle missing and invalid parameters in your Transact-SQL stored procedures.

Using Declarative Referential Integrity in SQL Server

The next time you are designing a new application database or adding new tables to an existing database, take a few moments to think about how you can leverage the DRI features of SQL Server to make your development life a little easier.

Find Scripts Quickly in SQL Server Management Studio

You’ll love this tip if you are tired of navigating all over your hard drive to find your scripts from inside SQL Server Management Studio.

Coding Transactions in Transact-SQL

This article demonstrates a pattern for coding transactions using Transact-SQL in SQL Server stored procedures.