- Shopping Bag ( 0 items )
This is an in-depth informational book about SQL Server, based upon the real-world experience of the authors - a book of applied technology. Emphasis is placed on the more complex aspects of the product, including using the new tools and features, administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning SQL Server performance.
Microsoft SQL Server 2014 Unleashed is presented in a format that is suitable for those who are already familiar with prior versions of SQL Server. At the beginning of each chapter is a brief summary of the major changes or new features or capabilities of SQL Server related to that topic. If you are already familiar with SQL Server, you can use this section to focus on the information in the chapters that covers the new features and capabilities in more detail.
The book provides a behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You'll learn what the underlying SQL commands are, to allow them to fully unlock the power and capabilities of SQL Server. All SQL code examples, sample databases, and application code are included with the book to enable you to rapidly learn from live examples and create viable solutions from these samples themselves.
Specific to this edition:
SQL Server 2014 has advanced to new levels of capabilities that include further enhancements to high availability, cloud options via Azure, and further performance enhancements provided via major database engine features such as memory optimized tables, Buffer Pool Extension and delayed durability. The updates and changes from the 2012 version reflect expanded capabilities in the most critical areas of the product (High Availability, BI/DW, Integration, Performance, Master Data services, Data Quality services, and DB Administration).
Introduction
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
Overview
This is an in-depth informational book about SQL Server, based upon the real-world experience of the authors - a book of applied technology. Emphasis is placed on the more complex aspects of the product, including using the new tools and features, administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning SQL Server performance.
Microsoft SQL Server 2014 Unleashed is presented in a format that is suitable for ...