SQL SERVER 2012
Enhancements
Cloud-ready platform
Database Administrators
·
AlwaysOn
Availability Groups
·
AlwaysOn
Failover Cluster Instances (FCI)
·
Support
for Windows Server Core
·
Recovery
Advisor (Scroll bar to show when and
which backup will take place)
Scalability and Performance Enhancements
·
Column store Indexes
·
Partition Support Increased ( up to 15000)
·
Online Index Create, Rebuild, and Drop ( Max
data types)
·
Achieve Maximum Scalability with Windows Server
2008 R2 ( support up to 256 processors and
2 TB memory in single OS instance)
Manageability Enhancements
·
SQL Server Management Studio
·
IntelliSense Enhancements
·
A new Insert Snippet menu to insert template
(CTRL+K)
·
Transact-SQL Debugger
·
Resource Governor Enhancements (dm_resource_governor_resource_pool_affinity)
·
Tight Integration with SQL Azure
·
Easy Startup Options Relocated
·
Data-Tier Application (DAC) Enhancements (single
unit of deployment containing all of the database’s schema, dependent objects,
and deployment requirements used by an application)
Security Enhancements
·
User-defined server roles for easier separation
of duties
·
Audit enhancements on all SKUs to improve
compliance and resiliency
o Stop,
continue and fail audit on network failure
o User
define audit events like application users
using sys.sp_audit_write
o Extended
event can filter data in audit saving.
·
Simplified security management, with a default
schema for groups
·
Contained Database Authentication, which
provides database authentication that uses self-contained access information
without the need for server logins
o Self-copy
of database, no orphan users
o Used
in migration and not in replication, change data capture
·
SharePoint and Active Directory security models
for higher data security in end-user reports
Programmability Enhancements
·
FileTable It builds on FILESTREAM technology.
FileTable offers organizations Windows file namespace support and Application
compatibility with the file data stored in SQL Server.
·
Statistical Semantic Search Three new Transact-SQL rowset functions to
query unstructured data
·
Full-Text Search Enhancements finding author,
title etc from file without open it
Editions ( 32 and 64
bit)
·
Enterprise edition
·
Standard edition
·
Business Intelligence edition
·
Specialized editions
o Web
o Developer
o Express
