Standard edition includes two-node failover clustering, log shipping, and peer to peer replication. Move a logical copy of SQL Server databases directly to Microsoft Azure SQL Database for more cost-effective and fully redundant data protection options.
Easily manage permissions around data access including user-defined server roles to support separation of duties and contained database authentication. 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.
Support for multi-dimensional models allows IT to build business logic with Reporting Services. Report Builder 3.0 provides an intuitive report authoring environment. Take advantage of SQL Server predictive analytics in Excel and Visio with the SQL Server Data Mining add-in.
Integrate data from disparate sources with SQL Server Integration Services (SSIS), which includes support for the deployment and administration of ETL tasks such as better tracking of SSIS packet status and the ability to run administration as a separate SQL Server instance.
SQL Server Management Studio and updated management packs for System Center help you centrally manage your infrastructure. Added support for Windows PowerShell 2.0 automates management tasks, and enhancements to Sys Prep help you more efficiently create virtual machines.
With SQL Server Data Tools, database development is integrated into Visual Studio and/or available for download to support building next-generation web, enterprise, business intelligence and data-aware mobile applications across on-premises and public cloud.
FileTable in SQL Server makes it easier to manage content into FILESTREAM blob storage. Improvements to full-text indexing yield better performance and search functionality. Statistical semantic search technology supports automatic concept extraction and innovative key phrase search options.
SQL Server supports relational and non-relational data, including Big Data sources like Hadoop. Customers can extend heterogeneous environments using industry standard APIs (ADO.NET, ODBC, JDBC, PDO, and ADO) across varied platforms including .NET, C/C++, Java, Linux, and PHP.