SQL Server Magazine

		Options
LINQ to SQL in Action Although LINQ to SQL has T-SQL under the hood, it provides a higher-level set of query tools for developers to leverage. Use it to realize a new data-access layer and use auto-generated types to exchange data with the business and presentation layers.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

LINQ to SQL in Action: Joining and Grouping

Explore the workings of LINQ to SQL queries, then walk through examples of using LINQ to SQL to join and group data in .NET Framework applications.
By Dino Esposito 

Configuring Storage for Your SQL Server Environment

What you need to know about properly configuring your storage resources, and the storage solutions that work best with SQL Server.
By Denny Cherry 

Focus on Files and Filegroups

Most SQL Server DBAs wonder how many data files or filegroups they should have when they create a new user database. But they should be focusing on how to better utilize filegroups rather than on how many files they need.
By Andrew J. Kelly 

Integrating SharePoint Data with SQL Server

SharePoint can become an isolated data island--unless you use SQL Server Integration Services to integrate that data into SQL Server databases.
By Anup Kafle 

Subqueries and Joins for Running Aggregates

Both the subquery and join solutions perform reasonably well for calculating running aggregates when you have very small partitions, but the join approach is best for calculating multiple aggregates.
By Itzik Ben-Gan 

T-SQL 101: Stored Procedures

The final lesson in the T-SQL 101 series shows you how to create and execute stored procedures that get data into and out of databases.
By Bill McEvoy 

Get Ready for SQL Server 2008 SP1

In the Community Technology Preview (CTP) for SQL Server 2008 SP1 you’ll find a couple of important changes in the way that service packs are applied and used as well as some important new functionality for SQL Server 2008.
By Michael Otey 

Need to Find an Object But You Don't Know Its Exact Name? Try this Search Engine

Looking for an object in a SQL Server instance without knowing the object's exact name and the database in which it resides can be time-consuming. Here's a T-SQL stored procedure that will make your seach much quicker.
By Shaunt Khaldtiance 

Quickly Identify Columns with Mismatched Data Types

Here's a utility that you can use to quickly find which columns have mismatched data types across tables in a SQL Server 2008 or SQL Server 2005 database. Correcting these columns can improve performance and data integrity.
By Readers 

SQL Server 2008 Express Editions

Make the right SQL Server choice by checking out this list of SQL Server 2008 Express editions before you buy.
By Michael Otey 

Review: Toad for SQL Server

Here's an option if you're not satisfied with SQL Server Management Studio. With more features and smoother performance, it's a solid choice.
By Michael K. Campbell