Database Recovery Advisor gives database administrators better options in how they restore databases with SQL Server Management Studio. SQL Server Management Studio has been enhanced to offer fully redundant cloud backups with the new capability of moving logical copies of SQL Server databases directly to Microsoft SQL Azure.
Microsoft SQL Server 2012 Standard Edition makes it easier to manage access levels to and standard format of databases on both the server and in deployed applications for individual users and groups.
Database migration has also been simplified in Microsoft SQL 2012 Standard Edition, with the ability to create self-contained databases with all the metadata, security controls, and user access. When you move these databases, no setup is required. This is a huge time-saver for DBAs.
Integrations Services has made integrating data from multiple sources simpler in Microsoft SQL Server 2012 Standard Edition, which greatly enhances data capturing and display.
Because information management is a crucial part of business, Microsoft SQL Server 2012 Standard Edition has simplified content management as an integrated part of applications.
Microsoft SQL Server 2012 Standard Edition gives you the capability of extending data across heterogeneous environments with industry-standard APIs like ODBC and JDBC using a variety of programming platforms.