SQL Server Code Name is the latest release primarily focus on High Availability, High Scalability , Cloud and BI. Key feature are listed below. Programming EnhancementSequencesIn simple terms, it is a new database object and a substitute for the Identity of columns.
SELECT BusinessEntityID, FirstName, LastName FROM Person.Person ORDER BY BusinessEntityID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY; Column Store (“Apollo”)
Columnstore indexIt improves data warehouse query performance by “hundreds to thousands of times in some cases” if it is combined with enhanced query processing.FileTablesWith file Table you can store files and documents in special tables in SQL Server and access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.The FileTable feature builds on top of SQL Server FILESTREAM technology. Circular arc segment support for spatial typesIt is a new spatial data type defined by three points in a two dimensional
plane and the third point cannot be the same as the first point. Table Partitioning up to 15,000Support growing data warehousing with table partitioning that now scales to 15,000 partitions.Extended Events enhancements Enhancements include flexible event selection, logging, and filtering with Extended Events. Property-scoped full-text
search (Extended Properties Index)
Statistical semantic search
Customizable proximity search
High AvailabilitySQL Server AlwaysOnThis feature is a brand name for availability and recovery. In this release several new recovery and faileover feature to enhance over all availability Failover Availability GroupAvailability Groups provides an integrated set of options including automatic and manual failover of a group of databases, support for up to four secondaries, fast application failover and automatic page repair. Failover Cluster Instancessupport multi-site clustering across subnet which helps enable cross-datacenter failover of SQL Server instances. Active SecondriesIn 2012 backup sever will not sit idle , they secondary instances to are utilized for running report queries and backup operations which helps eliminate idle hardware and improve resource utilization. Connection Director
AutoStatThis feature auto-creates and updates temporary statistics needed for queries running on the readable secondary. These temporary statistics area stored in TempDB therefore no physical changes are required in the user database. This allows the optimizer to generate optimal query plans on secondary replica as it would do on the primary replica and it does not require any user intervention.Windows Server Core SupportSQL2012 natively support installation Server Core (Minimum Install) that in turn reduces overall database downtime because Server Core installation greatly reduces patching requirements. Database Recovery Advisor:This feature include a visual timeline that presents the backup history of the database and the available points in time to which the user can restore the database, algorithms to streamline identifying the right sets of backup media to get the database back to a specific point in time, and page restore dialog in SSMS to do page-level restores of the database. StreamInsight EnhancementMicrosoft StreamInsight is Microsoft’s Complex Event Processing technology to help businesses create event-driven applications and derive better insights by correlating event streams from multiple sources with near-zero latency. Several features are improved to enhance availability of StreamInsight BI EnhancementBI Semantic Model (BISM).Analysis Services will include a new BI Semantic Model (BISM). BISM is a 3-layer model that includes:
BISM will enhance Microsoft's front end analysis experiencing including Excel, Reporting Services and SharePoint Insights. Microsoft has said that BISM is not a replacement for the current BI Models but more of an alternative model. In simple terms, BISM is a relation model that includes BI artifact such as KPIs and hierarchies. Ad-hoc Reporting (Crescent)
Data Quality Service (DQS)
SharePoint 2010 share serviceThis is a new service provides Integration with SharePoint., SQL Server Data Tools (SSDT)The SQL Server Data Tools (SSDT) add-in for Visual Studio 2010 to work with and upgrade SQL Server 2005 and 2008 reports, the Reporting Services Excel/Word rendering extension to generate reports for earlier versions of Excel/Word. |
2.What Is New > MSSQL >