For years, nobody cared that the legacy image-syncing application consumed as much bandwidth and processing time as it did.
Microsoft this week released updates for both the current and upcoming versions of SQL Server.
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.
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.
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.
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.
Benjamin Day's exploration of leveraging the ViewModel in Silverlight and Windows Phone 7 development ("6 MVVM Tips") generated plenty of feedback.
- By Readers of Visual Studio Magazine
- 05/01/2011
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.
- By Roger Jennings
- 05/01/2011
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.
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.
Peter Vogel introduces a new column on application development in the real world, and begins by advocating for Language Integrated Query.
Peter Vogel introduces a new column on application development in the real world, and begins by advocating for Language Integrated Query.
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.
- By Roger Jennings
- 03/01/2011
The frequency with which Microsoft has changed database access technologies is remarkable, with each new scheme offering the promise that .NET developers have finally arrived at a long-term solution.
- By Mark Michaelis
- 01/01/2011
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.