Paul Bertucci is the founder of Data by Design, LLC (www.dataxdesign.com), a global database consulting firm with offices in the United States and Paris, France. He recently spent 6 years as the Chief Architect and Director of the global Shared Services team for Autodesk, Inc. running BI/DW/ODS, Big Data, Identity Management, SOA, Integration (EAI & ETL), MDM, Collaboration/Social, SaaS application platforms, and Enterprise Architecture teams. Prior to Autodesk, he was the Chief Data Architect at Symantec for 4 years. He is also co-founder and CTO for Diginome, Inc. (www.diginome.com), a data provenance/integrity software company. Paul has more than 30 years of experience with database design, data architecture, big data, data replication, performance and tuning, master data management (MDM), data provenance/DataDNA, distributed data systems, data integration, high-availability, enterprise architecture, identity management, SOA, SaaS, and systems integration for numerous Fortune 500 companies, including Intel, Coca-Cola, Apple, Toshiba, Lockheed, Wells Fargo, Safeway, Sony, Charles Schwab, Cisco Systems, Sybase, Symantec, Veritas, and Honda, to name a few. He has authored numerous database articles, data standards, and high-profile database courses, such as Sybase’s “Performance and Tuning” and “Physical Database Design” courses. Other Sams Publishing books that he has authored include the highly popular Microsoft SQL Server 2000 Unleashed, Teach Yourself ADO.NET in 24 Hours, Microsoft SQL Server High Availability, Microsoft SQL Server 2005 Unleashed, Microsoft SQL Server 2008 R2 Unleashed, and Microsoft SQL Server 2012 Unleashed. Mr. Bertucci is a frequent speaker at industry conferences such as Informatica World, Oracle World, and the MDM Summit, and at Microsoft-oriented conferences such as SQL Saturday’s, Silicon Valley Code-Camp, PASS conferences, Tech Ed’s, and SQL Server User Groups. He has deployed numerous systems with Microsoft SQL Server, Sybase, DB2, Postgres, MySQL, NoSQL, Paraccel, Hadoop and Oracle database engines, and he has designed/architected several commercially available tools in the database, data modeling, performance and tuning, data integration, digital DNA, and multidimensional planning spaces. Paul just finished a major “Master Data Management for Big Data” project with Intel Corporation that deployed MDS (with Profisee’s Maestro) in a data mastering as a service architecture. Paul received his formal education in computer science and electrical engineering from UC Berkeley (Go Bears!). He lives in the great Pacific Northwest (Oregon) with his five children: Donny, Juliana, Nina, Marissa, and Paul Jr. Mr. Bertucci can be reached at pbertucci@dataxdesign.com or Bertucci@Alum.CalBerkeley.Org.

Chris Gallelli is the president of CGAL Consulting Services, Inc. His company focuses on consulting services in the areas of database administration, database tuning, advanced stored procedure development, Integration Services, Powershell development and database programming using Microsoft Visual Studio. Chris has more than 20 years of experience with SQL Server or Sybase and more than 25 years in the field of information technology. He has a bachelor’s degree in electrical engineering and a master’s degree in business administration from Union College. Chris currently lives near Albany, New York, with his lovely wife, Laura, and two beautiful daughters, Rachael and Kayla. Other Sams Publishing books that he has coauthored include Microsoft SQL Server 2000 Unleashed, Microsoft SQL Server 2005 Unleashed, Microsoft SQL Server 2008 R2, and Microsoft SQL Server 2012 Unleashed. Chris can be reached at cgallelli@gmail.com.

Alex T. Silverstein is owner and chief technologist of Unified Digital Group, LLC (http://unifieddigital.com), a custom software development firm headquartered near Saratoga Springs, New York. He specializes in designing high-availability software systems using SQL Server and Microsoft .NET. Alex has more than 18 years of experience providing application development, database administration, and training services worldwide to a variety of industries. He was also a coauthor of previous editions of this book. You can reach Alex anytime via email at alex@unifieddigital.com.

Part I: Welcome to Microsoft SQL Server
1 SQL Server 2014 Overview
2 What's New in SQL Server 2014

Part II: SQL Server Tools and Utilities
3 SQL Server Management Studio
4 SQL Server Command-Line Utilities
5 SQL Server Profiler
6 SQL Distributed Replay

Part III: SQL Server Administration
7 SQL Server System and Database Administration
8 Installing SQL Server 2014
9 Upgrading to SQL Server 2014
10 Client Installation and Configuration
11 Database Backup and Restore
12 Database Mail
13 SQL Server Agent
14 SQL Server Policy Based Management
15 Security and User Administration
16 SQL Server Data Encryption
17 Managing Linked Servers
18 SQL Server Configuration Options
19 Working with and Deploying to SQL Azure

Part V: Database Administration
20 Creating and Managing Databases
21 Creating and Managing Tables
22 Creating and Managing Indexes
23 Implementing Data Integrity
24 Creating and Managing Views
25 Creating and Managing Stored Procedures
26 Creating and Managing User-Defined Functions
27 Creating and Managing Triggers
28 Transaction Management and the Transaction Log
29 Database Snapshots
30 Database Maintenance

Part VI: SQL Server Performance and Optimization
31 Understanding SQL Server Data Structures
32 Indexes and Performance
33 Memory-Optimized Tables and the Buffer Pool Extension
34 Understanding Query Optimization
35 Managing the Query Optimizer
36 Query Analysis
37 Locking and Performance
38 Database Design and Performance
39 Monitoring SQL Server Performance
40 SQL Server Database Engine Tuning Advisor
41 Managing Workloads with the Resource Governor

Part VII: SQL Server High Availability
42 SQL Server High Availability Fundamentals
43 Replication
44 SQL Server Failover Clustering
45 SQL Server Always On and Availability Groups

Part IX: SQL Server Business Intelligence Features
46 SQL Server 2014 Analysis Services
47 SQL Server Integration Services
48 SQL Server 2014 Reporting Services
49 Data Quality Services
50 Master Data Services
51 Parallel Data Warehouse Appliance

Index

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.