Microsoft SQL Server 2012 Business Intelligence

Microsoft SQL Server 2012 Business Intelligence
  • Platform: Windows
  • Manufacturer: Microsoft
  • Type: Retail Boxed, Full Edition
  • MPN: D2M-00063
  • Stock Code: 016401
  • More: Microsoft SQL Server
  • Availability: Call For Availability
Our Price: $15,120.47

Related Products

Product Description

Microsoft SQL Server 2012 Business Intelligence delivers a comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions.

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.

SQL Server 2012 Business Intelligence Edition Capabilities

  • PowerPivot
    Empower users to access and mash-up data from virtually any source and easily collaborate and share insight using familiar tools with PowerPivot.
  • Power View
    Discover new insights with Power View, an interactive browser-based data visualization and presentation experience for users of all levels.
  • BI Semantic Model
    Provide consistent view across heterogeneous data sources and easily transform end user created apps into corporate BI solutions.
  • Master Data Services
    Maintain master data across the organization structures used for object mapping, reference data and metadata management.
  • Data Quality Services
    Help improve data quality by using organizational knowledge and 3rd party reference data providers to reliably profile, cleanse, and match data.
  • xVelocity
    xVelocity in-memory analytics engine provides a generational leap in performance while allowing an interaction with an unprecedented amount of data.

Things You Can Do

  • Rapid data exploration & visualization
    Discover new insights at the speed of thought with Power View, a highly interactive, familiar browser-based data exploration, visualization, and presentation experiences for users of all levels, Additionally, PowerPivot helps empower users to access and mash-up data from virtually any source, including Big Data sources using familiar tools.

  • Managed self-service BI
    Balance the need to monitor, manage, and govern the data and analytics end users create with IT dashboards controls across SQL Server and Microsoft SharePoint that help IT monitor end user activity, data source usage, and gather performance metrics from servers. New to SQL Server 2012, IT can also transform end user-created BI applications in PowerPivot into corporate-grade solutions managed by IT.

  • Corporate and scalable reporting and analytics
    Build and deploy advanced scalable, secure and manageable BI corporate solutions with advanced analytics and reporting, tabular BI Semantic Model and xVelocity in-memory analytics engine. Business users gain advanced predictive analytics with the simplicity and familiarity of Microsoft Excel with SQL Server 2012 Data Mining Add-ins for Microsoft Office.

  • Credible, consistent data
    With SQL Server 2012, IT can better control and manage data through a new BI Semantic Model and enhancements to SQL Server Integration Services. Meanwhile, new Data Quality Services uses organizational knowledge and 3rd party reference data providers to reliably cleanse data and a new Master Data Services Add-in for Excel makes it easy for end users to manage and maintain central data.

  • Greater Uptime, Manageability, and Security
    Reduce OS patching by as much as 50-60% with new support for Windows Server Core.¹ Meanwhile, SQL Server Management Studio introduces Database Recovery Advisor...

¹ 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.

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 Quantity25 Clients
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.