SQL Server and SDS


Free Databases in the Window Azure Marketplace

The Windows Azure Marketplace has a hidden jewel: a host of free and nearly free databases ready for monetization.

Updates in Entity Framework

A primer on how to update objects, including adds and deletes, in the Entity Framework.

'Denali' Makes Way for 'SQL Server 2012'

Microsoft's next-generation database is expected in first half of 2012.

Understanding LINQ to SQL on Windows Phone 7.5

The "Mango" update to Windows Phone 7 includes LINQ to SQL abilities. Use them while building a movie review app.

A CLR Alternative to the SQL Server ISNUMERIC function

CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

Eliminate Joins by Modifying Entity Framework Models

Peter Vogel explains why adding associations to Entity Framework navigations helps you avoid using Joins.

To Think in LINQ

If you start "thinking in LINQ" you'll get more done with less code, and what you write will be simpler than using SQL.

Can SQL Server Punch Through the Clouds to No. 1?

SQL Azure has become a major pillar in Microsoft's cloud-based strategy.

Using Razor with Visual Basic

Build a Web site using MVC 3 and the Razor View Engine.

Scale ASP.NET Apps Through Distributed Caching

High-transaction environments can use distributed caching to boost performance without major code changes.

WCF: Creating Long-Running Services

Not all business operations finish in seconds. Using Windows Communication Foundation you can still create -- as a single project -- an application that supports business services that take hours (or days or weeks or months) to complete.

C# Practice Makes Perfect

For years, nobody cared that the legacy image-syncing application consumed as much bandwidth and processing time as it did.

Microsoft Releases SQL Server 'Denali' CTP3, SQL Server 2008 R2 SP1

Microsoft this week released updates for both the current and upcoming versions of SQL Server.

Batting Clean up with Reader Questions

Peter Vogel answers reader questions, including extending custom sections in the config file, using CreateQuery and ESQL in the Entity Framework, and reading lambda expressions.

Issuing SQL in Entity Framework

If you're considering a move into the world of LINQ and Entity Framework, you have to consider the possibility that LINQ and Entity Framework won't let you issue some bizarrely complicated SQL statement. Don't worry -- should that ever happen, you have options.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.