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

Summary

In this chapter, you have learned about the new tabular model and which of the three Analysis Services architectures is the best fit for your environment. You saw how to install the three models, determine which model is currently running on your server and how to bypass the default string store limit.

You will probably agree that there is so much to explore in SQL Server 2012 Analysis Services that it deserves a book to itself. If you have not already delved in deep, we hope you have learned enough to start your journey into the world of BI. You are now in a firm position to start exploring the topics we have not had the scope to cover here. One thing is for sure, it is incredibly exciting to see Analysis Services evolve.

In the next chapter, ...

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