Product features

• Basic availability and disaster recovery
  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.
• Support for compliance
  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 the default schema for groups that allows a default database schema for Windows group user accounts.
• Reporting and analytics
  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.
• Rich data integration
  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.
• Improved manageability
  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.
• Robust development tools
  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.
• Extend any data, anywhere
  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 PHPE.