MS SQL Server 2012 - DBA Articles

What's New in SQL Server 2012 - Installation

SQL Server 2012 introduces the following changes to SQL Server Setup:

01. Datacenter Edition:

Datacenter edition which was introduced in SQL Server 2008 R2 is no longer available as a SQL Server 2012 edition.

02. Business Intelligence Edition:

SQL Server 2012 includes a new edition of SQL Server - SQL Server Business Intelligence.

SQL Server 2012 Business Intelligence edition delivers comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions. It offers exciting functionality such as browser based data exploration and visualization; powerful data mash-up capabilities, and enhanced integration management.

03. Enterprise Editions:

Starting SQL Server 2012, we have two editions for Enterprise differentiated based on licensing model.

    Enterprise Edition: Server/Client Access License (CAL) based licensing

    Enterprise Edition: Core-based Licensing

04. Changes to Operating System Requirements:

Starting with SQL Server 2012, Service Pack 1 is the minimum requirement for Windows 7 and Windows Server 2008 R2 operating systems.

05. Data Quality Services:

You can now install Data Quality Services (DQS) using the SQL Server Setup.

06. Product Update:

Product Update is a new feature in SQL Server 2012 Setup. It integrates the latest product updates with the main product installation so that the main product and its applicable updates are installed at the same time.

07. Server Core Installation:

Starting with SQL Server 2012, we can install SQL Server on Windows Server 2008 R2 Server Core SP1.

08. SQL Server Data Tools:

Starting with SQL Server 2012, you can install SQL Server Data Tools (SSDT) which provides an IDE for building solutions for the Business Intelligence components: Analysis Services, Reporting Services, and Integration Services. SSDT - Formerly called Business Intelligence Development Studio.

09. SQL Server multi-subnet clustering:

You can now configure a SQL Server failover cluster using clustered nodes on different subnets.

10. MB file share is a supported storage option:

System databases (Master, Model, MSDB, and TempDB), and Database Engine user databases can be installed on a file share on an SMB file server. This applies to both SQL Server stand-alone and SQL Server failover cluster installations.

11. Local Disk:

Local Disk is now a supported storage option for tempdb for SQL Server failover cluster installations.

12. BUILTIN\administrators:

BUILTIN\administrators and Local System (NT AUTHORITY\SYSTEM) are not automatically provisioned in the sysadmin fixed server role.

13. Operating Systems:

The protection of operating services under a per-service SID is now extended to all operating systems.

14. Default Accounts:

Setup now offers default accounts for the SQL Server services whenever possible.

15. Active Directory:

The Active Directory Helper service is no longer installed because it is no longer needed.

16. Itanium support:

SQL Server Itanium editions are no longer supported.

17. Microsoft Books Online for SQL Server:

The SQL Server documentation is no longer included in the installation media, but must be either viewed online, or downloaded as a local help collection.

18. Microsoft Sync Framework:

Microsoft Sync Framework is no longer included in the SQL Server 2012 installation media.

More Reference URL:

* * * * *

Email Your Comment To AUTHOR