By responding to potential threats with thoughtfulness, and a zeal to add value, SQL and Big Data could be big business for Redmond.
- By Andrew J. Brust
- 02/01/2012
SQL Server 2012 will feature three versions, including a new category.
DynamoDB, based on NoSQL, uses solid-state drives to increase speed.
- By Jeffrey Schwartz
- 01/19/2012
Visual Studio Magazine's first-ever survey shows high salaries and a strong future for Microsoft-focused developers.
Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say.
- By Andrew J. Brust
- 12/01/2011
One big change is the move from per-processor to per-core licensing.
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."
A primer on how to update objects, including adds and deletes, in the Entity Framework.
The "Mango" update to Windows Phone 7 includes LINQ to SQL abilities. Use them while building a movie review app.
- By Nick Randolph
- 10/13/2011
Microsoft's next-generation database is expected in first half of 2012.
CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.
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
High-transaction environments can use distributed caching to boost performance without major code changes.
Build a Web site using MVC 3 and the Razor View Engine.
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