Microsoft SQL Server 2012 Standard - 10 CALs

Microsoft SQL Server 2012 Standard - 10 CALs
  • Platform: Windows
  • Manufacturer: Microsoft
  • Type: Retail Boxed, Full Edition
  • MPN: 228-09842
  • Stock Code: 016152
  • More: Microsoft SQL Server
  • Availability: Call For Availability
Our Price: $5,360.92

Related Products

Product Description

Microsoft SQL Server 2012 Standard Edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud - enabling effective database management with minimal IT resources.

Microsoft SQL Server 2012 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.

Highlights:

  • The 9s you need with AlwaysOn
  • Blazing-fast query performance with ColumnStore Index
  • Rapid data discovery via Power View and PowerPivot
  • Credible, consistent data via BI Semantic Model and Data Quality Services
  • Scale on demand from devices to datacenter to cloud
  • Write applications once, run anywhere with SQL Server Data Tools

Microsoft SQL Server 2012 will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security features for mission critical workloads; Breakthrough Insight with managed self-service data exploration and stunning interactive data visualizations capabilities; Cloud On Your Own Terms by enabling the creation and extension of solutions across on-premises and public cloud.

New SQL Server 2012 Capabilities

  • 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.
  • Distributed Replay
    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%1 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 SQL Azure for more cost-effective and fully redundant data protection options.
  • 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.
  • Improved Manageability
    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.

1The 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.

Integrate Data and Enable Basic BI

  • More Easily Integrate Data
    More 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.

Develop Innovative Applications

  • Enable More Innovative Development
    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.

Microsoft SQL Server 2012 Overview

Specifications / System Requirements

Version2012
Language(s)English (International)
Distribution MediaDVD-ROM
Package TypeRetail Boxed Package
License PricingStandard
License TypeComplete Package
License Quantity1 User
System Requirements:
Operating SystemWindows Server 2008 R2 SP1, Windows 7 SP1, Windows Server 2008 SP2, Windows Vista SP2 (see Extra Details for detailed requirements)
Min CPUx86: 1 GHz Pentium III-compatible processor or faster, x64: AMD Opteron, AMD Athlon 64, Intel Xeon/Pentium IV with EM64T support
Min HDD6 GB
Min RAM1 GB
Min Screen Requirements800x600
Peripheral DevicesDVD-ROM drive; mouse & keyboard
Other Software RequirementsMicrosoft Internet Explorer 7.0 or later

Extra Details

System Requirements

Hardware and Software Requirements

  • Framework1
    .NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Replication, Master Data Services, Data Quality Services, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.
    • If you run Setup on a computer with the Windows Vista SP2 or Windows Server 2008 SP2 operating system, and you do not have .NET 3.5 SP1, SQL Server Setup requires you to download and install.NET 3.5 SP1 before you can continue with the SQL Server installation. The error message includes a link to the download center, or you can download .NET 3.5 SP1 from Windows Update. To avoid interruption during SQL Server Setup, you can download and install .NET 3.5 SP1 before you run SQL Server Setup.
    • If you run Setup on a computer with the Windows Server 2008 R2 SP1 operating system, you must enable .NET Framework 3.5 SP1 before you install SQL Server 2012.
    .NET 4.0 is a requirement for SQL Server 2012. SQL Server installs .NET 4.0 during the feature installation step. SQL Server Express does not install .NET 4.0 on the Server Core mode of Windows Server 2008 R2 SP1. You must install .NET 4.0 before you install SQL Server Express on a Server Core installation of Windows Server 2008 R2 SP1.
    SQL Server Setup installs the following software components required by the product:
    • .NET Framework 41
    • SQL Server Native Client
    • SQL Server Setup support files
  • Windows PowerShell
    SQL Server 2012 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio.
  • Network Software
    Supported operating systems for SQL Server 2012 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols:
    • Shared memory
    • Named Pipes
    • TCP/IP
    • VIA
    Note
    • Shared memory and VIA are not supported on failover clusters.
    • The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
  • Virtualization
    SQL Server 2012 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions, and Windows Server 2008 R2 SP1 Standard, Enterprise, and Datacenter editions.
    In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2012 instance. Requirements are listed later in this topic.2
    Within the Hyper-V role on Windows Server 2008 SP2 and Windows Server 2008 R2 SP1, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 or Windows Server 2008 R2 SP1 32-bit or 64-bit editions.
    Important
    • We recommend that SQL Server 2012 be shut down before shutting down the virtual machine.
    • Guest failover clustering is supported in SQL Server 2012.
  • Internet Software
    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.
  • Hard Disk
    SQL Server 2012 requires a minimum of 6 GB of available hard-disk space.
  • Drive
    A DVD drive, as appropriate, is required for installation from disc.
  • Monitor
    SQL Server 2012 requires Super-VGA (800x600) or higher resolution monitor.
  • Internet
    Internet functionality requires Internet access (fees may apply).

1If 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 Setup will download.NET Framework 4 to complete the installation of the prerequisites.

2Running SQL Server 2012 on a virtual machine will be slower than running natively because of the overhead of virtualization.

Processor, Memory, and Operating System Requirements

  • Memory1
    Minimum:
    • Express Editions: 512 MB
    • All other editions: 1 GB
    Recommended:
    • Express Editions: 1 GB
    • All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
  • Processor Speed
    Minimum:
    • x86 Processor: 1.0 GHz
    • x86 Processor: 1.4 GHz
    Recommended:
    • 2.0 GHz or faster
  • Processor Type
    • x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
    • x86 Processor: Pentium III-compatible processor or faster

1The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server 2012 minimum memory requirement.

WOW64 Support:
WOW64 (Windows 32-bit on Windows 64-bit) is a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode, even though the underlying operating system is a 64-bit operating system.

  • 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. For more information about supported operating systems, select an edition of SQL Server 2012 from the sections below.

Server Core Support:
SQL Server 2012 is now supported on a Server Core installation of Windows Server 2008 R2. Installing SQL Server 2012 is supported on the Server Core mode of the following Windows Server 2008 R2 editions:

  • 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

Notes
SQL Server editions that are supported on Windows Server 2008 R2 64-bit x64 Standard edition are also supported on Windows Small Business Server 64-bit x64.

Operating System Support:

  • SQL Server Standard (32-bit)
    • Windows Server 2008 R2 SP1 Datacenter/Enterprise/Standard/Foundation/Web (64-bit)
    • Windows 7 SP1 Ultimate/Enterprise/Professional (32/64-bit)
    • Windows Server 2008 SP2 Datacenter/Enterprise/Standard/Web (32/64-bit)
    • Windows Server 2008 SP2 Foundation (64-bit)
    • Windows Vista SP2 Ultimate/Enterprise/Business (32/64-bit)
  • SQL Server Standard (64-bit)
    • Windows Server 2008 R2 SP1 Datacenter/Enterprise/Standard/Foundation/Web (64-bit)
    • Windows 7 SP1 Ultimate/Enterprise/Professional (64-bit)
    • Windows Server 2008 SP2 Datacenter/Enterprise/Standard/Foundation/Web (64-bit)
    • Windows Vista SP2 Ultimate/Enterprise/Business (64-bit)
  • SQL Server Developer (32-bit)
    • Windows Server 2008 R2 SP1 Datacenter/Enterprise/Standard/Web (64-bit)
    • Windows 7 SP1 Ultimate/Enterprise/Professional/Home Premium/Home Basic (32/64-bit)
    • Windows Server 2008 SP2 Datacenter/Enterprise/Standard/Web (32/64-bit)
    • Windows Vista SP2 Ultimate/Enterprise/Business/Home Premium/Home Basic (32/64-bit)
  • SQL Server Developer (64-bit)
    • Windows Server 2008 R2 SP1 Datacenter/Enterprise/Standard/Web (64-bit)
    • Windows 7 SP1 Ultimate/Enterprise/Professional/Home Premium/Home Basic (64-bit)
    • Windows Server 2008 SP2 Datacenter/Enterprise/Standard/Web (64-bit)
    • Windows Vista SP2 Ultimate/Enterprise/Business/Home Premium/Home Basic (64-bit)

Extended System Support
SQL Server 2012 64-bit versions include support for extended systems, also known as Windows 32-bit on Windows 64-bit (WOW64). WOW64 is a feature of 64-bit editions of Windows that enables 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is 64-bit.

NOTE

Product information, specifications, and compatibility are for advisory purposes only, and is the buyers full responsibility to verify with the manufacturer prior to ordering.