book

What's New in SQL Server 2012

by Rachel Horder

October 2012

Intermediate to advanced

238 pages

5h 17m

English

Packt Publishing

Read now

Unlock full access

Support files, eBooks, discount offers and moreWhy Subscribe?Free Access for Packt account holdersInstant Updates on New Packt Books
What this book covers

Downloading the example codeErrataPiracyQuestions
SQL Server 2012 EditionsEnterprise EditionStandard EditionBusiness Intelligence EditionLicensing in the CloudDeveloper EditionExpress EditionObtaining SQL Server 2012EvaluationRetailNavigating the Installation Process
Management Studio keyboard shortcutsNew Dynamic Management Views (DMVs)The new OS Volume Stats DMVSpatial indexesColumnstore indexesCreating a columnstore indexRestrictionsContained databasesMaking an existing database partially containedMigrating your logins to a contained databaseContained database security
Default schemas for groupsUser defined server rolesSQL Server Audit enhancements
String functionsCONCATFORMAT
EOMONTHDATEFROMPARTSTIMEFROMPARTSDATETIMEFROMPARTSDATETIMEOFFSETFROMPARTS
TRY_PARSEPARSEIIF
FIRST_VALUELAST_VALUELAGLEAD
Database ProjectsSupport for SQL Server 2005, 2008 and SQL AzureIntelliSense and debuggingInstalling SQL Server Data ToolsInstalling without Visual Studio 2010 pre-installedInstalling with Visual Studio 2010 pre-installedCreating a new project
Business Intelligence Semantic Model
Multidimensional and data mining modelCreating a multidimensional model databaseTabular modelTabular model databaseThe xVelocity tabular engine modeCreating a tabular model databasePowerPivot for the SharePoint modelInstalling a modelMultidimensional and Tabular modelsPowerPivot for SharePointDetermining a previously installed model
Using scalable string storage
Deprecated features
Minority Reporting Services
SSISDB – the SSIS Catalog database
Giving users access to integration services
Upgrading from SQL Server 2005 and 2008
Adding a connection manager at the package levelChanging the scope of a connection manager
Validating a project or packageQuerying the SSISDB
How to set up basic SSIS loggingView the results of logging
Setting up a Data Tap
Reasons for using Data Quality Services
Enabling TCP/IP for remote access to the DQS serverMaking data accessible for DQS operationsGranting a DQS role on DQS_Main for DQS users
Understanding domains
Identifying invalid records and columnsDQS versus T-SQL
Mirroring, clustering and availability groupsAvailability groupsAvailability group restrictionsAvailability group advantagesUsing availability groups
TerminologyDistributed ReplayTrace fileIntermediate fileControllerClientTargetDReplay
CapturePreprocessReplayConfigurationMonitoringCanceling
Measure twice, cut once
Reasons for migrating to the cloudSQL Azure suitabilityHow SQL Azure differs from hosted web and database servicesDifferences between a public and private cloudMigrating a database to SQL AzurePublic cloud costsDifferences between SQL Azure and SQL Server Standard/Enterprise editionsUsing SQL AzureNew skillsSQL Azure and the future of databases
What is big data?The need for big data platformsIs SQL Server redundant?About HadoopAbout HiveDifferences in the Microsoft environmentHadoop and OLTPGetting started with HadoopThe Microsoft Hadoop/Sqoop connector

Content preview from What's New in SQL Server 2012

Master Data Services (MDS)

Microsoft has added plenty of new features to Master Data Services in this 2012 release. If you are already using the service, then you will know that it is possible to write an entire book devoted purely to MDS. To end this chapter, we will quickly review some of the new features in MDS.

It is now easier to install MDS, as you do this during the database engine installation process and no longer need a separate installer. As with other additional services, such as Integration Services and Reporting Services, you don't need to install this the first time you install the database engine. Just run through the installation setup again and choose to add new features.

To use the Master Data Manager web application, you need ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft® SQL Server 2012 Unleashed

Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein

Pro SQL Server 2012 Practices

Bradley Ball, TJay Belt, Glenn Berry, Jes Borland, Carlos Bossy, Louis Davidson, Ben DeBow, Grant Fritchey, Jonathan Gardner, Jesper Johansen, Jeremy Lowell, Wendy Pastrick, Kellyn Pot'vin, Mladen Prajdić, Herve Roggero, Chris Shaw, Gail Shaw, Jason Strate

Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)

Scalability Experts, Inc.

Microsoft® SQL Server 2005 Unleashed

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein, Tudor Trufinescu, John Kane

Publisher Resources

ISBN: 9781849687348Other