SQL Server


New Editions and Pricing for SQL Server 2012

One big change is the move from per-processor to per-core licensing.

New Deal Allows SQL to Run in Amazon Cloud

Microsoft and Amazon have agreed on a deal that will allow cheap use of Amazon's cloud resources for SQL Server 2012, formerly code-named "Denali."

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.

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

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

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.

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.

Performance Tips: Speed up Data Access

Faster performance in business applications comes down to reducing the "critical two" -- disk I/O and trips to the server. Doing that means doing a lot of things right, starting with your database design -- and tweaking your ADO.NET code helps, too.

SQL or No SQL for Big Data in the Cloud?

The relational model and SQL dominate today's database landscape, but NoSQL is gaining adherents in the era of "big data." But Roger Jennings says SQL and NoSQL may not be as exclusive as many developers think.

Deleting all Data from a SQL Server Database (Part 2)

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Deleting All Data from a SQL Server Database

There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems.

Build Big-Data Apps in SQL Azure with Federation

Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology Previews.

Crystal Reports vs. SQL Server Reporting Services

If you're trying to decide whether to use Crystal Reports or SQL Server Reporting Services with ASP.NET, you can rest assured that there is no bad choice.

Manage Database Design with Red Gate SQL Source Control

Red Gate SQL Source Control is a useful tool for SQL Server developers using TFS or Subversion, but falls short in managing database design changes.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.