SQL Server and SDS


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.

Not Just a Designer: Code First in Entity Framework

Code First is a new development approach in the Entity Framework 4.1 stack that can simplify the understanding and maintenance of your domain model.

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.

ViewModel Questions

Benjamin Day's exploration of leveraging the ViewModel in Silverlight and Windows Phone 7 development ("6 MVVM Tips") generated plenty of feedback.

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.

Why You Really Should Be Using LINQ

Peter Vogel introduces a new column on application development in the real world, and begins by advocating for Language Integrated Query.

Not Using LINQ Yet? Here's a Few Reasons Why.

Peter Vogel introduces a new column on application development in the real world, and begins by advocating for Language Integrated Query.

Subscribe on YouTube