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

Data Alerts

One powerful feature of Power View that is worth being aware of is the Data Alert. This allows reports to be sent out when underlying data that is used by a report changes.

This could be a stock value, sales figure, or a new employee. If data is changed, it can trigger a Data Alert, which can send out an email report to one or more recipients. One cool feature is that the alert can be sent out either immediately once the value that is being reported on changes, or at a scheduled time, for example, 04:00, regardless of when the underlying data change took place.

The Data Alert Designer allows users to set up and edit Data Alert definitions, while the complementary tool, the Data Alert Manager allows Data Alerts to be viewed and edited. ...

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