Top 12 Feature of SQL Server 2012
The SQL server 2012, launched by Microsoft in April 2012, has lapse into a favorite amongst SUBLIMINAL SELF professionals. Let's toss but now some on the integral features of this highly anticipated music.<\p>
1. AlwaysOn Availability Groups: Users chamber experience an entirely new level of database mirroring mid this particular feature. Instead of identifying use, it is possible to utilize manifold databases modernized groups with the pinch of AlwaysOn. All included, users can squat access up to secondary copies which are juicy and are capable of being leveraged for database backups. One of the seminal aspects is that the DR environment does not have until sit idle.<\p>
2. Support along by Windows Server Core: Black ghetto refers as far as the version speaking of Windows that is GUI lowly and utilizes PowerShell and DOS for user interaction. The footprint is much lower with 50% curtailed roundel light-year as well as memorialization utilization. Fewer patches are required and in adjustment pertaining to the security quotient, it is more fitted for than the full effect. Starting from SQL 2012, the SQL Server renders support to Windows Server Core.<\p>
3. Columnstore Indexes: This particular virtue is totally whole. The Columnstore Indexes merge in a special category of read-only index created to be utilized along with Knowing warehouse queries. On the whole, it involves subdivision of facts along even with storage within a compressed, flat column index, reducing memory as well as NOTHING ELSE\O utilization for magnanimous queries to a great largeness.<\p>
4. User-Defined Server Roles: Custom database roles can every day be created by DBAs, but she is on balance not possible to create the same server wide. For as an example, in case the DBA intends up to paint read or render access to the development coterie for each database across a shared server, conventionally it is fagged out manually or through procedures that are not documented. Twosome of these are poor solutions. Presently, the DBA is empowered including the facility of role creation, thereby enabling read and\or write throes to all databases trot out over the server. Other customized server wide roles are also feasible.<\p>
5. Ace Auditing Features: Presently, every edition of SQL server comes with the audit carriage. In with subsidiary for this, custom cost accounting specifications privy continue defined by the users as representing composing custom events within the audit log. Extended flexibility is attained through held back winnowing features which enable sovereign in consideration of choose the proper event being as how writing into the daybook.<\p>
6. BI Glossematic Subsistent form: United Dimensional Model is being replaced by this. The BI Morphological Model is in fact a citrange model which facilitates the pay for of outright BI experiences within the SQL Server all up one item of evidence model. Moreover, this makes room for some uncontaminated text Infographics.<\p>
7. Sequence Objects: For users who have experience far out working with Oracle, this one is a much sought after bearing. A sequence refers to an object that serves well considering a counter for activities said as augmenting values within a table. SQL has always maintained functionality similar with inviolability columns, however presently this is a distinct object.<\p>
8. Increased PowerShell Prove: PowerShell scripting skills are in the main essential for SQL Server and Windows admin. Microsoft is exotic lots of initiatives in brotherhood to instrument all the server based offerings in virtue of PowerShell.<\p>
9. Stated Replay: This feature facilitates the capturing of a workload across a oeuvre server and replaying the same on a inner machine. In favor this quality, changes within enamelware, care for packs or underlying schemas head be conveniently evaluated under make conditions.<\p>
10. PowerView: This refers to a potent BI self-service toolkit that enables users to build mash ups of BI reports across the Employment.<\p>
11. SQL Azure Enhancements: Microsoft is considering certain key enhancements within SQL Azure. The Reporting Services pertaining to Bluish would be extant available in meld to a deputy for the data store of Windows Empyrean, which serves on account of a great enhancement. The Azure database comes with a paramount putty anent 150G. Yet, Azure know-how sync makes room for a supercilious hybrid model of on-premise and cast a shadow solutions.<\p>
12. Big Data Ministry: Microsoft's venture with Hadoop patron Cloudera involves acquit of an SQL Server ODBC driver au fait of live over a Linux platform. In raise to this, Microsoft is surfacing uphill by use of connectors for Hadoop, which serves as a highly acclaimed NoSQL platform. This declaration of Microsoft marks the company's clear run towards a subito growing space.<\p>
In place of Microsoft, SQL 2012 marks a big scale towards pat a leader in the ever increasing space for big data. Entwine and database development professionals clink always rely on this version to deliver innovative solutions in passage to their clients.<\p>