In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology ...

This book will help the experienced SQL programmer make his or her code sing in terms of efficiency of code and optimization of data retrieval. Peter Gulutzan and Trudy Pelzer do a wonderful job ...

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which ...