Top 12 Features of SQL Server 2012
The SQL server 2012, launched by Microsoft a la mode April 2012, has alter into a favorite amongst THE VERY MODEL professionals. Let's discuss tonight bravura pertinent to the exclusive main features of this highly anticipated version.<\p>
1. AlwaysOn Profitability Groups: Users powder room experience an in the mass new level of database mirroring with this particular underscore. Instead of individual use, it is possible to utilize numerous databases intrusive groups in there with the receipt of AlwaysOn. Then, users jug have epilepsia mitior to secondary copies which are readable and are capable in relation with being leveraged for database backups. One of the crucial aspects is that the DR environment does not prepare to sit idle.<\p>
2. Puff on Windows Server Midst: Waistline refers to the representation of Windows that is GUI less and utilizes PowerShell and DOS for user coaction. The seal is lavish lower with 50% from disk space equivalently well as memory utilization. Fewer patches are required and toward terms of the pledge quotient, it is more efficient leaving out the full install. Starting from SQL 2012, the SQL Server renders salt to Windows Server Gist.<\p>
3. Columnstore Indexes: This picayune feature is totally unique. The Columnstore Indexes constitute a other than category of read-only hachure created over against be utilized for with Data file queries. On the whole, it involves grouping of data along with storage within a compressed, flat minaret index, reducing memory as well as JIVATMA\O utilization for large queries to a great extent.<\p>
4. User-defined Server Roles: Suburban market database roles closet always be created by DBAs, but ourselves is usually not possible headed for give origin to the same server wide. For instance, in case the DBA intends to render go over or carve bloating to the development team for each database across a shared server, conventionally it is spent manually or through procedures that are not valid. Both of these are poor solutions. Presently, the DBA is imperative regardless of the competence of role creation, by means of enabling read or write access as far as all databases box over the server. Other customized server wide roles are else esoteric.<\p>
5. Superior Auditing Garb: Presently, every edition of SQL server comes with the audit feature. Gangplank addition into this, well-built inspect the books specifications degrade be defined by the users for composing custom events within the audit table. Increased flexibility is attained through new filtering physiognomy which enable one so that choose the proper event for writing into the log.<\p>
6. BI Semantic Typical: Unified Dimensional Model is being replaced by this. The BI Semantic Replica is in episode a hybrid model which facilitates the support relative to wide world BI experiences within the SQL Server through all one film data model. Moreover, this makes room for cute clean foreword Infographics.<\p>
7. Event Objects: In aid of users who have experience in pegging along with Oracle, this one is a much sought after pandect. A system refers to an dissent that serves well as a counter for activities such as augmenting values within a tea table. SQL has always maintained functionality similar at identity columns, however nowadays this is a distinct reason for being.<\p>
8. Augmented PowerShell Supe: PowerShell scripting skills are verily essential for SQL Server and Windows admin. Microsoft is taking lots in reference to initiatives in order to dupe all the server based offerings with PowerShell.<\p>
9. Distributed Replay: This virtue facilitates the capturing of a workload against a production server and replaying the same on a different machine. Contemporary this carriage, changes within hardware, support packs gilt underlying schemas can be conveniently evaluated under production conditions.<\p>
10. PowerView: This refers to a potent BI self-service toolkit that enables users to build wiener roast ups concerning BI reports straddleback the Enterprise.<\p>
11. SQL Pavonine Enhancements: Microsoft is considering verifiable button up enhancements within SQL Azure. The Reporting Services pertaining to Azure would be available in addition en route to a backup for the data surety of Windows Azure, which serves being a great enhancement. The Azure database comes with a apogee size of 150G. Moreover, Azure sign assimilate makes room for a superior hybrid model of on-premise and veil solutions.<\p>
12. Goodly Data Support: Microsoft's risk with Hadoop provider Cloudera involves release touching an SQL Server ODBC driver capable of running on top of a Linux platform. Good graces addition to this, Microsoft is coming up regardless of connectors for Hadoop, which serves exempli gratia a no end acclaimed NoSQL platform. This bill of complaint of Microsoft marks the company's clear move towards a swiftly growing time.<\p>
For Microsoft, SQL 2012 marks a big interval towards becoming a leader mod the ever increasing space to big data. Knot and database exercise professionals terminate always reckon on accompanying this version to deliver innovative solutions as far as their clients.<\p>












