SQL Server 2012 Standard

Main Features

SQL Server 2012 Standard includes the following key features:

• AlwaysOn Availability Groups
• Columnstore Indexes
• Contained Databases
• Enhanced Auditing
• Power View
• SQL Server Data Tools
• SQL Server Management Studio
• Transparent Data Encryption
• User-Defined Server Roles

Benefits

• Improved performance and scalability
• Enhanced security and compliance
• Reduced downtime and increased availability
• Improved manageability and ease of use
• Advanced business intelligence and analytics capabilities
• Support for cloud-based deployments
• Lower total cost of ownership

What's New in SQL Server 2012 Standard?

SQL Server 2012 Standard is Microsoft's popular relational database management system. It comes with several new features and improvements over its predecessor, SQL Server 2008 R2.

One of the major differences between the two versions is the support for AlwaysOn Availability Groups. This feature allows you to create a group of databases that can failover together, providing high availability and disaster recovery capabilities.

Another significant improvement in SQL Server 2012 Standard is the introduction of columnstore indexes. These indexes can significantly improve the performance of data warehousing queries by storing data in a columnar format, rather than the traditional row-based format.

SQL Server 2012 Standard also includes enhancements to the T-SQL language, such as support for sequences and the ability to define default values for table columns. Additionally, it offers improved security features, including user-defined server roles and contained databases.

Overall, SQL Server 2012 Standard is a significant upgrade over its predecessor, offering improved performance, availability, and security features that make it a compelling choice for organizations of all sizes.