Introducing Microsoft SQL Server 2014

Introducing Microsoft SQL Server 2014

by Ross Mistry, Stacia Misner


4 New & Used Starting at $1.99


NOTE: This title is also available as a free eBook on the Microsoft Download Center. It is offered for sale in print format as a convenience.

Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs of your business. Get the early, high-level overview you need to begin preparing your deployment now.

Coverage includes:

  • SQL Server 2014 Editions and engine enhancements
  • Mission-critical performance enhancements
  • Hybrid cloud enhancements
  • Self-service Business Intelligence enhancements in Microsoft Excel
  • Enterprise information management enhancements
  • Big Data solutions

Product Details

ISBN-13: 9780735684751
Publisher: Microsoft Press
Publication date: 04/14/2014
Series: Introducing Series
Pages: 208
Product dimensions: 7.30(w) x 8.80(h) x 0.40(d)

About the Author

Ross Mistry is National Director, Microsoft Technology Centers (MTC). His team focuses on SQL Server high availability, virtualization, and private cloud. He has published numerous books and articles, and speaks at conferences worldwide.

Table of Contents

Introduction xi

Part 1 Database Administration

Chapter 1 SQL Server 2014 editions and engine enhancements 3

SQL Server 2014 enhancements for database administrators 4

Availability enhancements 4

Backup and restore enhancements 7

Scalability and performance enhancements 8

Security enhancements 10

Platform for hybrid cloud 11

SQL Server 2014 editions 13

Enterprise edition 13

Standard edition 14

Business Intelligence edition 15

Specialized editions 16

SQL Server 2014 licensing overview 16

Hardware and software requirements 17

Installation, upgrade, and migration strategies 18

In-place upgrade 18

Side-by-side migration 20

Chapter 2 In-Memory OLTP investments 23

In-Memory OLTP overview 23

In-Memory OLTP fundamentals and architecture 25

Four In-Memory OLTP architecture pillars 26

In-Memory OLTP concepts and terminology 27

Hardware and software requirements for memory-optimized tables 28

In-Memory OLTP use cases 28

Myths about In-Memory OLTP 29

In-Memory OLTP integration and application migration 29

Will In-Memory OLTP improve performance? 31

Using the Memory Optimization Advisor to migrate disk-based tables 31

Analyzing In-Memory OLTP behavior after memory-optimized table migration 32

Using In-Memory OLTP 33

Enabling In-Memory OLTP in a database 34

Create memory-optimized tables and natively compile stored procedures 34

Execute queries to demonstrate performance when using memory-optimized tables 35

Appendix 36

Memory-optimized table 36

Natively compiled stored procedure 37

Chapter 3 High-availability, hybrid-cloud, and backup enhancements 39

SQL Server high-availability and disaster-recovery enhancements 40

AlwaysOn Availability Groups enhancements 40

AlwaysOn Failover Cluster Instances enhancements 43

Platform for hybrid cloud 46

Cloud disaster recovery 46

Deploy a database to a Windows Azure Virtual Machine 50

Storing SQL Server data files in Windows Azure 51

Extending on-premises apps to the cloud 52

Backup and restore enhancements 53

SQL Server backup to a URL 53

Encryption for backups 56

SQL Server Managed Backup to Windows Azure 59

Part II Business Intelligence Development

Chapter 4 Exploring self-service BI in Microsoft Excel 2013 63

Excel Data Model and Power Pivot 63

Working with the Data Model 64

Managing data as a Power Pivot model 65

Power Query 67

Searching for data 68

Importing data 69

Loading the worksheet or Data Model 71

Shaping data 71

Combining data 75

Power View 77

Creating a Power View report 77

Working with visualizations 78

Sharing a Power View report 79

Power Map 79

Creating a Power Map 80

Visualizing geographic data 80

Exploring the 3-D map 84

Displaying values over time 84

Enhancing a map 84

Working with tours, scenes, and layers 86

Sharing Power Map 87

Chapter 5 Introducing Power BI for Office 365 89

Power BI sites 89

Configuring featured workbooks 91

Opening Power View in HTML5 91

Adding favorite reports to My Power BI 92

Shared queries 93

Creating a shared query 93

Using a shared query 94

Managing query metadata 94

Reviewing usage analytics 94

Power BI Q&A 95

Power BI for Mobile 97

Preparing a workbook for mobile viewing 97

Using Power BI for Mobile 97

Sharing a report from Power BI for Mobile 99

Power BI administration 99

Chapter 6 Big data solutions 101

Big data 101

Describing big data 101

Exploring the history of Hadoop 102

HDInsight 104

Creating a storage account for HDInsight 105

Provisioning an HDInsight cluster 106

Loading data into a storage account 106

Working with Hive 108

Analyzing data from Hive 110

PolyBase 115

Exploring the benefits of PolyBase 115

Accessing HDFS data from PDW 116

Index 119

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews