Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

Data Hierarchies With SQL Server 2008

SQL Server 2008 supports a new data type, HierarchyID, that helps solve some of the problems in modeling and querying hier­archical information. In the September 2008 issue of MSDN Magazine , Kent Tegels introduces you to the HierarchyID data type by Read More...
Posted Friday, September 05, 2008 7:00 AM by tdorsey | 0 Comments
Filed under:

September 2008 MSDN Magazine now online

The September 2008 issue of MSDN Magazine is now available online. Here's what's in the issue: Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008 We explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems Read More...
Posted Monday, September 01, 2008 7:00 AM by tdorsey | 1 Comments
Filed under: ,

Advanced Basics: The LINQ Enumerable Class

The Enumerable class plays an important role in every LINQ query you create. Because the Enumerable class's extension methods can process many other classes—including Array and List—you can use methods of the Enumerable class not only to create LINQ queries, Read More...
Posted Wednesday, July 16, 2008 7:00 AM by tdorsey | 0 Comments

SQL Server Data Services

SQL Server Data Services (SSDS) is a robust, scale-free data service that internally uses proven SQL Server technology and exposes its functionality over industry standard Web service interfaces. In the July 2008 issue of MSDN Magazine , David Robinson Read More...
Posted Wednesday, July 09, 2008 7:00 AM by tdorsey | 0 Comments

Test Run: Testing SQL Stored Procedures Using LINQ

The need to test a program that accesses and manipulates a back-end SQL Server database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In the April 2008 issue of MSDN Magazine Read More...
Posted Monday, May 12, 2008 7:00 AM by MSDNMagazine | 0 Comments

Extreme ASP.NET: Controls for Silverlight and Data-binding

In the March 2008 issue of MSDN Magazine , in our Extreme ASP.NET column, Fritz Onion explains how the new ListView control can literally replace all other data-binding controls in ASP.NET . Fritz demonstrates how ListView makes several data-binding tasks Read More...
Posted Wednesday, March 19, 2008 10:44 AM by MSDNMagazine | 0 Comments

Apply Test-Driven Development to your Database Projects

Visual Studio Team System Database Edition, also known as DBPro or Data Dude, introduced a product lifecycle methodology to database development. DBPro also introduced a database unit-testing designer that makes it easy to either generate or write T-SQL-oriented Read More...
Posted Friday, March 07, 2008 7:00 AM by MSDNMagazine | 0 Comments
Filed under: ,

Data Points: Designing an Entity Data Model

The Entity Framework is an exciting new technology for ADO.NET developers that enables you to view data using a logical model instead of a physical model. At the heart of the Entity Framework is the Entity Data Model (EDM), which defines the entity types, Read More...
Posted Wednesday, February 13, 2008 7:00 AM by MSDNMagazine | 0 Comments

Uncover Hidden SQL Server Data to Optimize Application Performance

Many application performance problems can be traced to poorly performing database queries; however, there are many ways you can improve database performance. SQL Server 2005 gathers a lot of information that you can use to identify the causes of such Read More...
Posted Wednesday, January 09, 2008 10:47 AM by MSDNMagazine | 4 Comments
Filed under: ,

Data Points: Common Table Expressions

Common Table Expressions (CTEs) can help improve the readability (and thus the maintainability) of SQL statements without compromising performance. They also make writing recursive code in T-SQL significantly easier than it was in previous versions of Read More...
Posted Friday, September 28, 2007 7:00 AM by MSDNMagazine | 2 Comments
 
Page view tracker