Microsoft's SQL Server 2012 Standard Edition is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
It gives you basic data management and business intelligence capabilities for non-critical workloads with minimal IT resources. This is a server and 10-client access license.
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.
Take database development to the next level with SQL Server Data Tools, an integrated development experience for database and Business Intelligence (BI).
Greater Uptime and Recovery
Reduce OS patching by as much as 50-60%¹ with new support for Windows Server Core. 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
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 as well as improved manageability through Contained Database Authentication that uses self-contained access information without the need for server logins.
Simplified application testing and minimized 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. Enhancements to Sys Prep helps IT to create VMs for private cloud solutions more efficiently. Meanwhile, updated management packs for System Center Operations Manager help IT centrally manage their infrastructure.
Integrate Data More Easily
Easily integrate data from multiple disparate sources with enhancements to Integration Services which include rich DBA and IT Implementer support for the deployment and administration of ETL tasks, including better tracking of SSIS packet status, run SSIS as a server and the ability to run administration and other capabilities as a separate SQL Server instance.
Enable Reporting and Analytics
Support for multi-dimensional models allows IT to build business logic and scale to users through Reporting Services. Meanwhile, Report Builder 3.0 provides an intuitive report authoring environment for business users and supports many of the key capabilities of SQL Server Reporting Services. Additionally, Microsoft SQL Server 2012 Data Mining Add-ins for Microsoft Office 2010 (Data Mining Add-ins) helps end users take advantage of SQL Server predictive analytics in Office Excel 2010 and Office Visio 2010.
Enable More Innovative Development
Now take database development to the next level with SQL Server Data Tools, an integrated development experience for developers building next-generation web, enterprise and data-aware mobile applications across on-premises and public cloud. Meanwhile, the Data-tier Application Framework (DAC Fx) dramatically helps simplify the development, deployment and management of database applications server to cloud.
Rich Support for Content
SQL Server 2012 makes it easier to manage content as an integrated part of an application. New FileTable makes it easier to manage content into FILESTREAM blob storage with standard tools and applications. Improvements to full-text indexing help yield better performance and search functionality. Meanwhile, new statistical semantic search technology supports automatic concept extraction and innovative key phrase search options for more sophisticated search across unstructured files.
Extend Any Data, Anywhere
SQL Server 2012 supports relational and non-relational data, including Big Data sources like Hadoop. Additionally, customers can extend heterogeneous environments using any industry standard APIs (ADO.NET, ODBC, JDBC, PDO, and ADO) across varied platforms including .NET, C/C++, Java, Linux, and PHP.
Table of Contents
Show moreShow less
SQL Server 2012 requires Super-VGA (800 x 600) or higher resolution monitor.
A DVD drive, as appropriate, is required for installation from disc.
SQL Server 2012 requires a minimum of 6 GB of available hard-disk space.
Minimum x86 Processor: 1.0 GHz
x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster
.NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.
NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step.
If you are installing the SQL Server Express editions, ensure that an Internet connection is available on the computer. SQL Server Setup downloads and installs the .NET Framework 4 because it is not included in the SQL Server Express media.
SQL Server Express does not install .NET 4.0 on the Server Core mode of Windows Server 2008 R2 SP1 or Windows Server 2012. You must install .NET 4.0 before you install SQL Server Express on a Server Core installation of Windows Server 2008 R2 SP1 or Windows Server 2012.
Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio.
Internet Explorer 7 or a later version is required for Microsoft Management Console (MMC), SQL Server Data Tools (SSDT), the Report Designer component of Reporting Services, and HTML Help.
Virtualization: Within the Hyper-V role on Windows Server 2008 SP2, Windows Server 2008 R2 SP1 or Windows Server 2012, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit/64-bit or Windows Server 2008 R2 SP1 64-bit or Windows Server 2012 64-bit editions
WOW64 Support: On a supported 64-bit operating system, SQL Server 32-bit edition can be installed to the WOW64 32-bit subsystem of a 64-bit server. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations. For SQL Server 64-bit edition installations on supported 64-bit operating systems, Management Tools are supported in WOW64
SQL Server 2012 is now supported on a Server Core installation of Windows Server 2008 R2 and Windows Server 2012. Installing SQL Server 2012 is supported on the Server Core mode of the following editions of Windows Server:
Windows Server 2012 64-bit x64 Datacenter
Windows Server 2012 64-bit x64 Standard
Windows Server 2008 R2 SP1 64-bit x64 Datacenter
Windows Server 2008 R2 SP1 64-bit x64 Enterprise
Windows Server 2008 R2 SP1 64-bit x64 Standard
Windows Server 2008 R2 SP1 64-bit x64 Web