If you start "thinking in LINQ" you'll get more done with less code, and what you write will be simpler than using SQL.
SQL Azure has become a major pillar in Microsoft's cloud-based strategy.
- By Andrew J. Brust
- 10/01/2011
Build a Web site using MVC 3 and the Razor View Engine.
High-transaction environments can use distributed caching to boost performance without major code changes.
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.
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.
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.
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.
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
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.
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.
Mike worked as a SQL developer for a non-profit, debt management company that handled student loans.
- By Kathleen Richards
- 11/01/2010
In a Redmond Review column last year ("What's Old Is New Again," April 2009), I discussed a move by Microsoft to reform its then-named SQL Data Services (SDS).
- By Andrew J. Brust
- 10/01/2010
Microsoft today released Service Pack 2 for SQL Server 2008.
It's no surprise that 'Oslo', also known as SQL Server Modeling, has not survived the on-going battle of competing data platform strategies at Microsoft.
- By Kathleen Richards
- 09/22/2010
Microsoft extends its enterprise-capable database platform with powerful new management and scalability features -- and there's plenty in the latest rev for developers.
A new component in SQL Server 2008 R2 gives users the autonomy to set up business intelligence functionality in Excel without taking control of the process away from IT.
- By Andrew J. Brust
- 09/01/2010