Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
What's New in SQL Server 2012
What's New in SQL Server 2012
Credits
About the Authors
Acknowledgment
Acknowledgment
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Installing SQL Server 2012
SQL Server 2012 Editions
Enterprise Edition
Standard Edition
Business Intelligence Edition
Licensing in the Cloud
Developer Edition
Express Edition
Obtaining SQL Server 2012
Evaluation
Retail
Navigating the Installation Process
Summary
2. SQL Server Administration
Management Studio keyboard shortcuts
New Dynamic Management Views (DMVs)
The new OS Volume Stats DMV
Spatial indexes
Columnstore indexes
Creating a columnstore index
Restrictions
Contained databases
Making an existing database partially contained
Migrating your logins to a contained database
Contained database security
Security management
Default schemas for groups
User defined server roles
SQL Server Audit enhancements
Master Data Services (MDS)
Summary
3. Transact SQL
String functions
CONCAT
FORMAT
Datetime functions
EOMONTH
DATEFROMPARTS
TIMEFROMPARTS
DATETIMEFROMPARTS
DATETIMEOFFSETFROMPARTS
Conversion functions
TRY_PARSE
PARSE
IIF
OFFSET and FETCH
SEQUENCE
WITH RESULT SETS
Error handling with THROW
FileTable table type
New T-SQL analytical functions
FIRST_VALUE
LAST_VALUE
LAG
LEAD
SQL Server Data Tools
Database Projects
Support for SQL Server 2005, 2008 and SQL Azure
IntelliSense and debugging
Installing SQL Server Data Tools
Installing without Visual Studio 2010 pre-installed
Installing with Visual Studio 2010 pre-installed
Creating a new project
Creating database projects
Summary
4. Analysis Services
Business Intelligence Semantic Model
The three models
Multidimensional and data mining model
Creating a multidimensional model database
Tabular model
Tabular model database
The xVelocity tabular engine mode
Creating a tabular model database
PowerPivot for the SharePoint model
Installing a model
Multidimensional and Tabular models
PowerPivot for SharePoint
Determining a previously installed model
Resource usage reporting
Extended Events for Analysis Services
String store constraint
Using scalable string storage
Summary
5. Reporting Services
Deprecated features
Power View and SharePoint modes
Minority Reporting Services
Data Alerts
Report Builder 2012
Excel Renderer for Excel 2007-2010
Word Renderer for Word 2007-2010
Summary
6. Integration Services
SSISDB – the SSIS Catalog database
Introducing the ssis_admin role
Giving users access to integration services
Fixed database-level roles
Upgrading from SQL Server 2005 and 2008
New functions
Shared connection managers
Adding a connection manager at the package level
Changing the scope of a connection manager
Enhancements to the Flat File Connection Manager
Undo and redo
Deployment models
Validating a project or package
Querying the SSISDB
Comparing and merging packages
Color coded and indicator status codes
Package execution logs
How to set up basic SSIS logging
View the results of logging
Package execution reports
Expression indicators
Change Data Capture support
Data taps
Setting up a Data Tap
Deprecated feares
Resources
Summary
7. Data Quality Services
Reasons for using Data Quality Services
Installing Data Quality Services
Enabling TCP/IP for remote access to the DQS server
Making data accessible for DQS operations
Granting a DQS role on DQS_Main for DQS users
Using Data Quality Services
Understanding domains
Coupling rules to data: the Data Quality Project
Identifying invalid records and columns
DQS versus T-SQL
Resources
Summary
8. AlwaysOn
Mirroring, clustering and availability groups
Availability groups
Availability group restrictions
Availability group advantages
Using availability groups
Summary
9. Distributed Replay
Terminology
Distributed Replay
Trace file
Intermediate file
Controller
Client
Target
DReplay
Architecture
Distributed Replay – a hands on example
Installation
Usage
Capture
Preprocess
Replay
Configuration
Monitoring
Canceling
Additional resources
Summary
10. Big Data and the Cloud
Measure twice, cut once
SQL Azure: SQL Server in the cloud
Reasons for migrating to the cloud
SQL Azure suitability
How SQL Azure differs from hosted web and database services
Differences between a public and private cloud
Migrating a database to SQL Azure
Public cloud costs
Differences between SQL Azure and SQL Server Standard/Enterprise editions
Using SQL Azure
New skills
SQL Azure and the future of databases
Big data and Hadoop: horses for courses
What is big data?
The need for big data platforms
Is SQL Server redundant?
About Hadoop
About Hive
Differences in the Microsoft environment
Hadoop and OLTP
Getting started with Hadoop
The Microsoft Hadoop/Sqoop connector
Notes on the Microsoft Hadoop/Sqoop connector
Summary
A final word from the authors
← Prev
Back
Next →
← Prev
Back
Next →