Microsoft SQL Server 2012 Standard
SQL Server 2012 Capabilities
Microsoft SQL Server 2012 Standard offers many benefits for you and your organization that can save you time and money.
Ready for the cloud, the Microsoft SQL Server 2012 Standard Server License boasts incredibly fast performance. Rapid data discovery gives end users powerful insights via seamless data exploration and visualization.
User-defined server roles let you easily manage permissions around data access, helping you separate duties and enhance compliance with strict data-access policies. Distributed replay meanwhile helps you simplify application testing and minimize errors with production-like application and configuration changes as well as upgrades. You can boost your database development with SQL Server Data Tools in an integrated development experience for database and business intelligence.
Windows Server Core Support
Reduce OS patching by as much as 50-60%¹ with new support for Windows Server Core.
User-Defined Server Roles
Easily manage permissions around data access to support separation of duties and enable compliance around strict data access policies.
Simplify application testing and help minimize errors with production-like application testing and configuration changes, and upgrades.
SQL Server Data Tools
Take database development to the next level with SQL Server Data Tools an integrated development experience for database and BI.
Things You Can Do
Run Non-Critical Applications
Greater Uptime and Recovery
Reduce OS patching by as much as 50-60%¹ with new support for Windows Server Core. Meanwhile, Database Recovery Advisor introduces significant user experience enhancements to the ways DBAs can restore databases using SQL Server Management Studio. Within Management Studio, customers can now move a logical copy of their SQL Server databases directly to Windows Azure SQL Database for more cost-effective and fully redundant data protection options.
¹The percentage reduction in patching varies and can be less based on the server roles that are enabled and the type of patches that are applied.
Support for Better Compliance
More easily manage permissions around data access with User-Defined Server Roles to support separation of duties. Help increase manageability and decrease complexity of database schema through new Default Schema for Groups that allows a default database schema for Windows group user accounts. Better control database access to deployed applications while improving manageability through Contained Database Authentication that uses self-contained access information without the need for server logins.
Simplify application testing and minimize errors on a single database with application changes, configuration changes, and upgrades using new Distributed Replay. Added support for Windows PowerShell 2.0 automates management tasks across the Microsoft platform and enhancements to Sys Prep help IT more efficiently create VMs for private cloud solutions. Meanwhile, updated management packs for System Center Operations Manager help IT centrally manage their infrastructure