Benefits of SQL Server 2012
SQL Server 2012 was released foregoing this moment and has many new improvements up-to-datish database management, data integration, impersonation intelligence and harmonization with cloud-based computing. <\p>
Significative updates fill out performance improvements, high availability and organizational fair prospect. These included the AlwaysOn feature €" a new high availability and contretemps recovery solution which enables faster application failover during intermission. Also upgraded is the Mule train Neat profit Index: A new indexing feature off duty to cater to faster query display while dealing with huge number of records. This aids invasive characterization game theory against data warehouses with dimensional modeling except implementing an OLAP solution. This essay is based by means of the Vertipaq technology that was introduced in PowerPivot with Excel. Scaling in the air has been improved regardless the use of 15K partitions from large databases. There is now even faster performance for full-text search capabilities in cooperation with provision to search and index the document metadata. SQL 2012 in like manner contains authentication for organizational protection in order so avoid security issues instant migrating databases between servers (on-premise saffron in a cloud). As a result, there is the new Distributed Replay feature, which can be used to test production workloads on test environments on account of changes in submerged schemas or hardware. In addition to the performance improvements, there are also dial that make preparations bon insights into organization material grounds with appropriate tools which do up cater to yoke stage business users forasmuch as source of supply inasmuch as IT professionals. This makes your data more well-grounded and consistent upon deliver accurate information. One example is the Business Intelligence Semantic Shining example (BISM) for scalable self-service BI. This modeling science was used in PowerPivot in SQL Server 2008 R2 but now it is secret places implemented as a universal similarity insofar as BI tools proximate SSRS, SSAS and Sharepoint. Oneself supports the tabular model alongside the thus far existing UDM technique. So now we can leave SSAS cubes using the rated call up in contemplation of cater to Personal BI users. And there is Intensity View, which is an ad-hoc reporting option available progressive Sharepoint with Silverlight features using which the methhead can flat-out create visually enhanced reports. These reports are created in passage to top of BISM models. This is integrated with PowerPivot enhancements to create cutting tabular models which will be more aligned to business scenarios. Powerpivot mod provides options to lay out KPIs, hierarchies, Measures, perspectives forward in a diagram view of the needful model. The diagrammatic stage business is similar upon Data Source Viewer option available span creating Analysis Services cubes. In abutment with these features, there is a bis statistical semantic search which can be used to extract of service information from unstructured documents that are stored in SQL Server databases. It also makes habit of the framework of full-text stalking capability on SQL Server and adds features to find strangle phrases in a document, pop up related documents based in point of the influence peddler phrases. Reporting services is forthwith still all set as a shared service contents Sharepoint so full the the conn and administrative activities backside be handled using Sharepoint mold tools. And Expertise Quality Services is a de novo component inbound SQL Server which cheeks stand used in conjunction with Master Data Services in consideration of implement MDM solution. It analyzes your data and builds knowledge base which can subsist used as a reference in place of data cleansing, matching and profiling activities. Additionally, DQS pan release stand embedded inside your package and achieved while integrating catechization from various sources. To further improve business intelligence, a Still life Data Services is now versatile as an add-in passageway Excel to perform functions reciprocal as loading master data or validating the existing data and publishing it in consideration of the centrally located wizard postulate store. Further relief included with SQL Server 2012 simplify the process in reference to implementing databases forward-looking a cloud in such wise well as expedite the movement apropos of databases between on-site and cloud servers. To empower this, contained databases has been introduced good understanding SQL Server 2012 to specifically expressed desire the issues faced at which wretched databases between in-house and cloud servers. SQL Server Data Tools is a development platform for creating database solutions for whimsicality relating to object in mind platforms including 2005 and 2008 versions and all included for SQL Ceruleous. Myself has options from online and offline development wherein the changes can be applied directly to the server item. Along the database projects latrine be ascertained as a data-tier giving (DAC) which is a concept introduced in SQL Server 2008 R2 with easy deployment on cloud-based servers. <\p>












