The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Bill McEvoy
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 Michael Otey
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 Itzik Ben-Gan
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 Anup Kafle
SharePoint can become an isolated data island--unless you use SQL Server Integration Services to integrate that data into SQL Server databases.
By Andrew J. Kelly
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 Shaunt Khaldtiance
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 Michael K. Campbell
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 Dino Esposito
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 Denny Cherry
What you need to know about properly configuring your storage resources, and the storage solutions that work best with SQL Server.
Make the right SQL Server choice by checking out this list of SQL Server 2008 Express editions before you buy.
By
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.
advertisement