470
Part V: Enterprise Data Management
To view miscellaneous information about the computer system while confi guring SQL Server, query the sys.dm_os_
sys_info dynamic management view.New in SQL Server 2012 Configuration
SQL Server 2012 brings many security enhancements for confi guration, specifi cally for service accounts
and permissions:■ (^) BUILTIN\administrators and Local System NT (NT Authority\SYSTEM) are no longer auto-
matically provisioned in the sysadmin fi xed server role on initial install.
■ (^) Setup now offers default accounts for SQL Server services whenever possible.
■ (^) Support for Managed Service Accounts and Virtual Accounts when installed on Windows
7 or Windows Server 2008 R2.
■ (^) Protection of operating services under a per-service SID now extended to all operating
systems.
Additionally there are quite a few major changes in regards to SQL Server Setup:
■ (^) Datacenter Edition, which was introduced in SQL Server 2008 R2, is no longer available as
a SQL Server 2012 edition. It’s functionality has been replaced by the Enterprise Edition.
■ (^) New edition: SQL Server Business Intelligence edition — this edition delivers business
intelligence-centric features such as Data Quality Services, Integration Services, Master
Data Services, PowerPivot for SharePoint, Power View, StreamInsight Standard Edition.
■ (^) Service Pack 1 is the minimum requirement for Windows 7 and Windows Server 2008 R2
operating systems.
■ (^) Data Quality Services can now be installed using SQL Server setup.
■ (^) Product Update — 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.
■ (^) Support for installing SQL Server 2012 on Windows Server 2008 R2 Server Core SP1.
■ (^) SQL Server Data Tools (formerly called Business Intelligence Development Studio) — IDE for
building solutions for the Business Intelligence components: Analysis Services, Reporting
Services, and Integration Services.
■ (^) Support for mutli-subnet clustering confi gurations.
■ (^) Support for SMB fi le shares as a storage option.
■ (^) Local disk is now a supported storage option for tempdb for SQL Server failover cluster
installations.
■ (^) Dropped support for Itanium.
For full details regarding these changes, go to http://msdn.microsoft.com/en-us/library/
cc645578(v=sql.110).aspx.
c19.indd 470c19.indd 470 7/30/2012 5:42:44 PM7/30/2012 5:42:44 PM
http://www.it-ebooks.info