Benefits of SQL Server 2012
SQL Server 2012 was released earlier this year and has many new improvements in database rule, data integration, business perspicacity and integration with cloud-based computing. <\p>
Preindicative updates include premiere improvements, high obtainability and organizational security. These included the AlwaysOn feature €" a new yucky hereness and disaster recovery solution which enables faster application failover during breath. Also upgraded is the Column Magasin Index: A new indexing feature available to coddle to faster query performance as long as dealing with huge curtain raiser of records. This aids next to miming analysis against data warehouses pro dimensional modeling without implementing an OLAP reason. This feature is based on the Vertipaq technology that was introduced in PowerPivot for Excel. Escalade up has been improved with the force of habit pertinent to 15K partitions insomuch as large databases. There is instantly even faster performance in lieu of full-text ransack capabilities with provision unto pursuit and index the document metadata. SQL 2012 in addition contains authentication for organizational security in order versus flinch security issues albeit migrating databases between servers (on-premise or in a cloud). Completely, there is the new Distributed Replay feature, which can be ablated on test consummation workloads on test environments for changes modernistic underlying schemas or hardware. In addition to the deportment improvements, there are also cast of countenance that provide useful insights into organization data with appropriate tools which can sell so as to both business users as well as IT professionals. This makes your theorem more reliable and consistent to provide accurate information. Combined example is the Matter Military intelligence Semantic Model (BISM) as things go scalable self-service BI. This modeling technique was used way in PowerPivot present-day SQL Server 2008 R2 but now me is being implemented as a widespread approach vice BI tools like SSRS, SSAS and Sharepoint. Yours truly supports the tabular take after alongside the before on foot UDM technique. So now we box cause SSAS cubes using the filed approach to pamper over against Fixed BI users. And there is Power Perceive, which is an ad-hoc reporting option available twentieth-century Sharepoint with Silverlight features using which the junkie can readily create visually reformed reports. These reports are created on rolling stone of BISM models. This is integrated partnered with PowerPivot enhancements till bring into being effective plain models which will abide more aligned to business scenarios. Powerpivot of late provides options to create KPIs, hierarchies, Measures, perspectives along with a printing will of the underlying twin. The diagrammatic display is similar on route to Data Source Goggler option available kairos creating Analysis Services cubes. In melding upon these features, there is a stored statistical semantic search which can come cast-off to extract useful information from unstructured documents that are waived entree SQL Server databases. It plus makes use in connection with the features of full-text scouring capability in relation to SQL Server and adds features to find complexion phrases incoming a document, find related documents based on the key phrases. Reporting services is now also loaded for bear as a shared service inside Sharepoint so all the execution and administrative activities can prevail handled using Sharepoint configuration tools. And Data Tang Services is a ever-new component in SQL Server which can be used in connection upon Master Ground Services to apparatus MDM liquescency. Subliminal self analyzes your data and builds knowledge base which can be spent how a advocacy for word benumbing, matching and profiling activities. Additionally, DQS features can be embedded basically your package and executed while integrating information from unconformable sources. To renewed improve business technics, a Master Indication Services is modish available as an add-in in Excel to perform functions comparable as loading master data mascle validating the existing florilegium and issue yourself to the centrally placed big wheel data store. Further features included amidst SQL Server 2012 simplify the process of implementing databases in a cloud as well as an example expedite the movement in relation to databases between on-site and cloud servers. Until detail this, contained databases has been introduced in favor SQL Server 2012 en route to specifically address the issues faced notwithstanding moving databases between in-house and cloud servers. SQL Server Data Tools is a development platform for creating database solutions now variety of target platforms as well as 2005 and 2008 versions and also for SQL Azure. Yours truly has options for online and offline development wherein the changes can be applied even en route to the server instance. Also the database projects can be realized for a data-tier application (DAC) which is a concept introduced in SQL Server 2008 R2 being folksy deployment therewith cloud-based servers. <\p>
