November 8th, 2012Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade:
· SQL Server 2012 SP1 introduces support for cross-cluster migration of AlwaysOn Availability Groups deployments to a new Windows Server Failover Clustering (WSFC) cluster. A cross-cluster migration moves one AlwaysOn availability group or a batch of availability groups to the new, destination WSFC cluster with minimal downtime. The cross-cluster migration process enables you to maintain your service level agreements (SLAs) when upgrading to a Windows Server 2012 cluster. SQL Server 2012 SP1 must be installed and enabled for AlwaysOn on the destination WSFC cluster. The success of cross-cluster migration depends on thorough planning and preparation of the destination WSFC cluster.
Selective XML Index:
· SQL Server 2012 SP1 introduces a new type of XML index known as a Selective XML Index. This new index can improve querying performance over data stored as XML in SQL Server, allow for much faster indexing of large XML data workloads, and improve scalability by reducing storage costs of the index itself.
DBCC SHOW_STATISTICS works with SELECT permission:
· In earlier releases of SQL Server, customers need administrative or ownership permissions to run DBCC SHOW_STATISTICS. This restriction impacted the Distributed Query functionality in SQL Server because, in many cases, customers running distributed queries did not have administrative or ownership permissions against remote tables to be able to gather statistics as part of the compilation of the distributed query. While such scenarios still execute, it often results in sub-optimal query plan choices that negatively impact performance. SQL Server 2012 SP1 modifies the permission restrictions and allows users with SELECT permission to use this command.
· Note that the following requirements exist for SELECT permissions to be sufficient to run the command: Users must have permissions on all columns in the statistics object and Users must have permission on all columns in a filter condition (if one exists).
· Customers using Distributed Query should notice that statistics can now be used when compiling queries from remote SQL Server data sources where they have only SELECT permissions. Trace flag 9485 exists to revert the new permission check to SQL Server 2012 RTM behavior in case of regression in customer scenarios.
New function returns statistics properties:
· The dynamic management function sys.dm_db_stats_properties returns properties of statistics for the specified database object (table or indexed view) in the current SQL Server database. You can use this function to return information such as the last time the statistics object was updated for the table or indexed view, or the number of rows that were sampled for statistical calculations.
SSMS Complete in Express:
· Customers who use the SQL Server Express With Tools, SQL Server Express COMP, SQL Server Express with Advanced Services and SQL Server Management Studio Express now have SQL Server Management Studio complete. These Express Editions now ship the SSMS feature with functionalities that exist with the SSMS from full editions of SQL Server.
SlipStream Full Installation:
· Provides customers with a pre-built "Slipstream image" that consists of a compressed, self-extracting .exe and a '.box' payload file that contains a SQL Server 2012 RTM image (Setup.exe, MSI’s, etc.) along with the most recent Service Pack. When the package is executed, the two images are merged in real-time providing the user with a single Setup workflow experience, landing the operation (Install, Upgrade, AddNode, etc) at the encompassed SP1 level, executing any updates made to Setup components themselves in the Service Pack
· Customers can perform new instance installations (or SQL Server 2008/2008 R2 upgrades) at the Service Pack functional level using a single click install workflow experience. This can be performed directly by utilizing the slipstream .exe from the command line just as they would use Setup.exe by supplying all appropriate setup command line parameters. This is in contrast to having to install RTM media, find and download the desired Service Pack (for the correct language and CPU), apply the Service Pack, then load Setup.exe to perform the desired setup action.
Business Intelligence highlights (with SQL Server 2012 SP1, Office and SharePoint Server 2013):
· Enable self-service BI as a natural part of users day-to-day activities in Excel 2013.
· Access and mash-up data from any source (PowerPivot).
· Stunning visualizations and data discovery (Power View).
· Work with hundreds of millions of rows of data (powered by xVelocity in-memory technologies).
· Discover, assess and audit user created spreadsheets via SharePoint Server 2013 Preview.
· A new version of the Reporting Services add-in for SharePoint and an updated SharePoint mode report server that supports SharePoint 2013.
· A new architecture for SQL Server 2012 SP1 CTP4 PowerPivot that supports a PowerPivot server outside a SharePoint 2013 farm. A Windows Installer package (spPowerpivot.msi) that enhances the PowerPivot for SharePoint experience. Additional features include PowerPivot Gallery, schedule data refresh, and management dashboard.
Management Object Support Added for Resource Governor DDL:
In SQL Server 2012 SP1, SQL Server Management Objects are updated to support the syntax of CREATE RESOURCE POOL (Transact-SQL):
· AFFINITY SCHEDULER
· AFFINITY NUMANODE
The following management objects limit CPU usage and affinitize resource pools to schedulers and NUMA nodes:
May 15th, 2012
· FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
· SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services
· FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 when you run log shipping from many databases to one secondary server
· FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment
· FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed
· FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version
· The fix is related to usage of BindParameter method and the reference of long type parameters that are used by this method.
· The fix is to update UpgradeIncompleteFeatureConfigEventHandler.cs to include RebuildDatabase scenario when you reset ConfigurationState.
· For document libraries with the “Opening Documents in the Browser” setting set to “Open in the client application” GetSnapshot.exe ignore the configuration and always displays the workbook by using Excel Services as if the setting was “Open in the browser”.
· FIX: On a Russian Localized build of the Reporting Services Configuration Manager, Execution Account information that is contained clipped strings.
· The ExpectedCount and ExpectedElapsedMs usage counts are updated to reflect the actual counts respectively.
· Fixes an issue in which SQL Server 2008 R2 Analysis Services crashes during the database synchronization.
· Trace flag 1264 is removed and so that the process name is collected by default in non-yielding scenario dumps. The number of thread records in non-yielding scenario dump files is increased from 1K to 16K.
· SQL Server 2008 R2 changes the FireAgain parameter to True if an event should be logged. However, after some codes are removed by mistake, some logs are missing because of the FireAgain parameter is only determined by the external event listener. After you apply this hotfix, the issue is resolved.
· Consider the following scenario. You have indexed view projects columns from base and non-base tables in SQL Server 2008 R2. A column from the non-base table has the same order id and type as a column of the base table. In this scenario, SQL Server 2008 R2 switches the partitions. After you apply the hotfix, SQL Server 2008 R2 experiences an error instead of switches the partitions.
· Fixes an issue in which an object that is allocated on a SOS_Task PMO could be also used by other TASK which has a different life span. This service pack uses the correct PMO for allocating the object.
· After you apply the hotfix, the optimizer understands that CRYPT_GEN_RANDOM can return different outputs for the same input.
· Fixes an issue in which an incorrect value is returned when you run the SCOPE_IDENTITY().
· Fixes an issue in which the SQL Server 2008 R2 setup crashes when you install SxS with Shiloh OLAP SP3a. This issue occurs because the Shiloh OLAP SP3a incorrectly writes the version registry key as "Service Pack 3.0."
· Fixes an issue in which an incorrect CPU time is reported by sys.dm_exec_query_stats when parallel query plans are involved.
· Fixes an issue that occurs when internal asynchronous file reading buffers are splitting the multi-character column delimiter in two parts. The fix is to correctly reset the current parsing pointer after buffers are switched.
· The fix will only use the synchronization if the SQLWixCompilerExtension operation runs in candle.
· This fix changes the HierarchyGet operation to avoid a certain code path for the explicit cap that only applies to the derived part of the hierarchy. The update is a one-line update that is low risk.
· Fixes an issue in which you receive errors in a statement when purging from snapshots.notable_query_text.
· Bad GUID values parsed from flat files could cause errors. The fix is to fall back into a truncation mode if the source buffer is bigger than max size of a GUID string.
April 7th, 2012
· SQL Server AlwaysOn, a new high availability solution delivering increased application availability, lower TCO and ease of use.
· xVelocity, in-memory technologies significantly boost data warehouse and analytics performance by up to 100x.
· Power View, a web-based, highly interactive, data visualization and presentation solution designed to enable business users and decision makers to quickly discover meaningful insights from their data.
· Data integration and management, new and enhanced tools to deliver credible, consistent data to the right users at the right time, including new SQL Server Data Quality Services and enhanced Master Data Services.
· Enhanced PowerPivot functionalities enable customers to leverage new advanced analytic capabilities and further ease of use while still working within the familiar tools provided by Excel.
· The new Business Intelligence (BI) Semantic Model provides a single, scalable model for BI applications, from reporting and analysis to dashboards and scorecards.
· SQL Server Data Tools, a new tool that unifies SQL Server and cloud SQL Azure development for both professional database and application developers.
November 18th, 2011
· Added core capabilities for increased mission critical confidence, including multiple secondaries in SQL Server AlwaysOn and multi-tenancy enhancements with Resource Governor.
· New functionality in the Power View (”Crescent”) data-exploration and visualization tool, including the inclusion of Change Data Capture support for Oracle enables broader support for heterogeneous data with Data Warehouses.
· Snapshot backups in Windows Azure from inside Management Studio.
September 30th, 2010
· SQL Server Utility. After you apply SP2, an instance of the SQL Server 2008 Database Engine can be enrolled with a utility control point as a managed instance of SQL Server. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online.
· Data-tier Application (DAC). Instances of the SQL Server 2008 Database Engine support all DAC operations after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.
· Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services SharePoint integration. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in for SharePoint 2007 products. The new add-in supports the integration of SharePoint 2007 products with SQL Server 2008 R2 report servers. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What's New (Reporting Services).
April 21st, 2010PowerPivot for SharePoint:
· PowerPivot for SharePoint adds shared services and infrastructure for loading, querying, and managing PowerPivot workbooks that you publish to a SharePoint 2010 server or farm. To create PowerPivot workbooks, you use PowerPivot for Excel.
PowerPivot for Excel:
· PowerPivot for Excel is an add-in to Excel 2010 that can be downloaded from the web and installed on client workstations. You use PowerPivot for Excel to assemble and create relationships in large amounts of data from different sources, and then use that data as the basis for PivotTables and other data visualization objects that support data analysis in Excel.
Multi-Server Administration and Data-Tier Application:
· The SQL Server Utility forms a central repository for performance data and management policies that tailor the operation of instances of the Database Engine that have been enrolled in the utility. It also includes a Utility Explorer for centralized management, and dashboards that report the state of the managed instances. A data-tier application (DAC) forms a single unit for developing, deploying, and managing the database objects used by an application.
Master Data Services:
· Master Data Services is comprised of a database, configuration tool, Web application, and Web service that you use to manage your organization's master data and maintain an auditable record of that data as it changes over time. You use models and hierarchies to group and organize data to prepare it for further use in business intelligence and reporting tools, data warehouses, and other operational systems. Master Data Services integrates with source systems and incorporates business rules to become the single source of master data across your organization.
Features Supported by the Editions of SQL Server 2008 R2:
· The largest database supported by SQL Server Express has been increased from 4 GB to 10 GB.
Connecting to the Database Engine Using Extended Protection:
· SQL Server now supports Extended Protection, using service binding and channel binding to help prevent an authentication relay attack. Also, see Extended Protection for Authentication with Reporting Services.
November 12th, 2009
· Building on the trusted, productive, and intelligent data platform delivered with SQL Server 2008, The Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP) provides a wealth of new improvements that will help your organization scale with confidence, improve IT efficiency, and enable managed self-service BI. This CTP release includes new and enhanced capabilities for application and multi-server management, complex event processing, master data services, and end user reporting. Also introduced is PowerPivot for Microsoft Excel (previously known as project “Gemini’) to empower users to easily access, integrate, analyze and share information using Microsoft Office tools they are already familiar with.
Key features in this CTP release include:
· A new Control Point Explorer for central multi-instance and application utilization management.
· Built-in wizards to help you quickly set up and enroll instances and Data-Tier Application components into central management.
· Dashboard viewpoints for quick insight into application and instance utilization.
· Report Builder 3.0
· PowerPivot for Microsoft® Excel
· Master Data Services
· StreamInsight core technology engine.