Amazon has announced support for .NET on AWS Elastic Beanstalk and a new RDS service for SQL Server, bringing better manageability to .NET/SQL Server apps hosted on AWS.
SQL Server 2008 R2 SP1 brings several features such as DAC Framework for easier schema upgrades, new DMVs and XEvents for better supportability, Improved Query Performance with ForceSeek and ForceScan and Disk space control for PowerPivot.
In "Slow in the Application, Fast in SSMS?", SQL Server MVP, Erland Sommarskog, explores the various things that affect Query Plan, compilation of Dynamic SQL and other things that ultimately affect your SQL Server Database Performance. He covers various concepts and scenarios like parameter sniffing, query plan caching, Blocking, saved settings, issues with linked servers and more.
Microsoft has announced the availability for download of SQL Server 2008 R2 SP1 CTP, including all cumulative updates, and SQL Server 2008 R2 SP1 Feature Pack CTP1, containing a number of stand alone tools adding more value to SQL Server 2008.
Microsoft has released the SQL Server Migration Assistant (SSMA) for MySQL 1.0, and has refreshed SSMA for Oracle v4.2, SSMA for Sybase v4.2, and SSMA for Access v4.2. These toolkits helps customers migrating their MySQL/Oracle/Sybase/Access databases to SQL Server and some even to SQL Azure.
SQL Server 2008 R2, Windows Server 2008 R2, and Visual Studio 2010 will be the last major versions to support Intel’s Itanium processor. While extended support will be offered for 8 years, new investments in the Itanium should be weighed carefully against AMD’s far more popular x64 architecture.
Despite years of complaining from developers and the mockery of vendors such as IBM, Microsoft is continuing its policy of shipping components of Visual Studio that are incompatible with the current version SQL Server Reporting Services.
In an attempt to lure web developers to its platform, Microsoft has created the WebsiteSpark program which offers a consistent package of Microsoft web development applications plus support and training for 3 years for a fee of $100 paid at the end of the program.
As we reported last year, SQL Server 2008 R2 will support 256 logical processors. Other features include better multi-server management tools and geospatial visualization in Reporting Services 3. A preview of the new version is available to MSDN and TechNet subscribers. The general public will have access later this month.