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
November 13, 2010 by
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
February 7, 2010 by
Learn how to handle missing and invalid parameters in your Transact-SQL stored procedures.
Using Declarative Referential Integrity in SQL Server
August 9, 2009 by
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.
How to Gather Comprehensive Business Requirements for a Database Application
May 24, 2008 by
A database design begins when you sit down with your customers and learn the business requirements for your application.
Find Scripts Quickly in SQL Server Management Studio
February 2, 2008 by
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
July 27, 2007 by
This article demonstrates a pattern for coding transactions using Transact-SQL in SQL Server stored procedures.
