InfoQ Homepage SQL Server 2008 R2 Content on InfoQ
News
RSS Feed-
AWS Beanstalk For .NET, RDS For SQL Server
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 Easier Schema Upgrades, Improved Query Performance
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.
-
MVP Erland Explores SQL Server Performance Concepts
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.
-
SQL Server 2008 SP1 and Feature Pack CTP Bring New Features and Tools
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.
-
Migrating from MySQL/Access to SQL Server/Azure with SSMA
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.
-
Visual Studio Dropping Support for Itanium
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.
-
Visual Studio/SQL Server Reporting Services Continue to be Incompatible
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.
-
Microsoft Offers a Set of Web Development Tools for $100
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.
-
What’s Next for SQL Server?
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.