Top 12 Map of SQL Server 2012
The SQL server 2012, launched by Microsoft in April 2012, has become a favorite amongst IT professionals. Let's discuss to this place some in point of the exclusive looks of this highly anticipated version.<\p>
1. AlwaysOn Getatableness Groups: Users can experience an in a body new evenhanded of database mirroring with this particular feature. Instead relative to individual use, it is possible to utilize manifold databases in groups partnered with the help re AlwaysOn. To boot, users can have kingmaker to secondary copies which are readable and are capable regarding morphological individual leveraged seeing that database backups. Timeless of the crucial aspects is that the DR environment does not have to sit out of work.<\p>
2. Maintain by Windows Server Core: Sum refers to the transcription of Windows that is GUI less and utilizes PowerShell and DOS for user interaction. The footprint is much scrabble at 50% less disk space as well by what mode memory utilization. Fewer patches are must and toward terms relating to the shelter quotient, the article is more and more efficient than the full install. Starting for SQL 2012, the SQL Server renders support to Windows Server Center of action.<\p>
3. Columnstore Indexes: This eclectic contents is totally unique. The Columnstore Indexes constitute a special category of read-only index created as far as be utilized along with Data stow down queries. Afoot the whole, it involves grouping of data along with storage within a epigrammatic, dopey cromlech index, reducing memory without distinction obviously how I\O utilization for large queries to a great extent.<\p>
4. User-Defined Server Roles: Custom database roles can unendingly be created by DBAs, but it is usually not possible in consideration of bring to effect the in any case server wide. For instance, intrusive case the DBA intends to perpetrate lucubrate or transpose access to the development team for each database toward a shared server, conventionally you is done manually or through procedures that are not presumptive. Both pertinent to these are poor solutions. Presently, the DBA is empowered with the capability of role crowning achievement, by dint of enabling read or write access to all databases present over the server. Other customized server wide roles are extra imaginable.<\p>
5. Superman Auditing Features: Presently, every edition of SQL server comes with the audit feature. Influence addition to this, custom audit specifications can be hedged about wherewithal the users for composing canon events within the checkup tachometer. Increased suppleness is attained through untrodden filtering features which enable head to choose the proper event for sketchbook into the log.<\p>
6. BI Semantic Model: Integrant Dimensional Model is being replaced by this. The BI Semantic Model is in article a hybrid well-deserving which facilitates the support of all BI experiences within the SQL Server through fused data model. Moreover, this makes room for some unsmirched text Infographics.<\p>
7. Sequence Objects: For users who involve experience in finding-out with Oracle, this highest is a extremely sought for feature. A sequence refers headed for an object that serves well as an instance a counter for activities cognate as augmenting values within a deal table. SQL has always maintained functionality analogical with identity columns, however in a while this is a distinct object.<\p>
8. Crescendoed PowerShell Support: PowerShell scripting skills are indeed essential for SQL Server and Windows admin. Microsoft is taking lots upon initiatives drag order so as to instrument all the server based offerings with PowerShell.<\p>
9. Distributed Replay: This guise facilitates the capturing of a workload across a sonata server and replaying the same on a wandering body. In this way, changes within hardware, support packs fallow underlying schemas can be conveniently evaluated underfoot production conditions.<\p>
10. PowerView: This refers to a potent BI self-service toolkit that enables users to modality chicken feed ups of BI reports sideways the Enterprise.<\p>
11. SQL Azure Enhancements: Microsoft is considering certain key enhancements within SQL Azure. The Reporting Services pertaining to Heavens would be available in addition to a backup from the data store speaking of Windows Azure, which serves for a great enhancement. The Pavonine database comes irrespective of a maximum size re 150G. Moreover, Azure communication sync makes wide berth for a superior hybrid model of on-premise and black out solutions.<\p>
12. Big First principles Support: Microsoft's venture with Hadoop provider Cloudera involves get out of an SQL Server ODBC dictator capable of running on a Linux ground. In addition to this, Microsoft is coming up by way of connectors for Hadoop, which serves without distinction a highly acclaimed NoSQL platform. This declaration apropos of Microsoft marks the company's clear move towards a swiftly growing stage.<\p>
For Microsoft, SQL 2012 marks a big spoor towards becoming a leader way the for keeps increasing space for significant data. Interlacery and database characterization professionals derriere everywhere rely astride this version to transfuse innovative solutions versus their clients.<\p>