Lesson 3: Database Management Tools and Techniques Lesson 3: Database Management Tools and Techniques By Jeff Jones BUY NOW $295 Buy for Teams Video Courses > 20462: Administering Microsoft SQL Server Databases Share LOGIN About This Course – Introduction to 20462 3:25 Course Outline 5:26 Preparing for the Labs 14:21 Hyper-V Remote Live Connectivity Test 5:20 Module 1: Introduction to SQL Server 2014 Database Administration – Introduction to SQL Server 2014 Database Administration 1:24 Lesson 1: Database Administration Overview 0:58 What Makes a Good Database Administrator? 2:44 Common Database Administration Tasks 3:08 Documenting Database Management Procedures 2:34 Lesson 2: Introduction to the SQL Server Platform 1:19 SQL Server Components 13:53 Lesson 3: Database Management Tools and Techniques 1:42 SQL Server Tools 13:58 Lab: Using SQL Server Administrative Tools Module 2: Considerations for SQL Server Installation – Considerations for SQL Server Installation 1:21 Lesson 1: Planning SQL Server installation 1:21 Considerations for SQL Server Installation 0:00 Minimum Hardware and Software Requirements 2:44 Assessing CPU and Memory Requirements 8:56 Storage I/O Considerations 4:45 Tools for Assessing Storage I/O Performance 5:46 Planning Service Accounts 9:22 Lesson 2: Installing SQL Server 2014 0:58 Options for Installing SQL Server 2014 3:38 Performing an Installation Demo 19:28 Unattended Installation and Upgrade 6:50 Lesson 3: Post-Installation Configuration 0:50 Performing Post-Installation Checks 3:46 Configuring Services and Network Protocols Part 1 1:42 Configuring Services and Network Protocols Part 2 14:10 Managing SQL Server Updates 2:28 Lab: Using SQL Server Administrative Tools 0:00 Module 3: Data Storage with SQL Server – Module 3 Introduction 2:40 Lesson 1: Introduction to Data Storage with SQL Server 1:37 How Data Is Stored in SQL Server 10:01 Considerations for Disk Storage Devices 7:30 Determining File Placement and Number of Files 7:46 Lesson 2: Managing Storage for System Databases 1:04 SQL Server System Databases 6:21 Considerations for tempdb 4:35 Demonstration: Moving tempdb Files 10:15 Lesson 3 Intro: Managing Storage for User Databases 1:46 Creating User Databases 5:28 Demonstration: Creating Databases 12:34 Altering User Databases 9:04 Introduction to Filegroups 5:52 Creating and Managing Filegroups 9:15 Lesson 4 Intro: Moving Database Files 1:21 Moving User Database Files 6:04 Detaching and Attaching Databases Demo 6:24 Lesson 5: Configuring the Buffer Pool Extension 1:31 Introduction to the Buffer Pool Extension 5:52 Configuring the Buffer Pool Extension 5:53 Demonstration: Configuring the Buffer Pool Extension 6:28 Module 4: Planning and Implementing a Backup Strategy – Planning and Implementing a Backup Strategy 1:43 Lesson 1: Understanding SQL Server Recovery Models 1:20 Overview of SQL Server Transaction Logs 4:12 Transaction Log File Structure 8:46 Working with Recovery Models 6:09 Bulk Logged Recovery Model 5:45 Capacity Planning for Transaction Logs 5:43 Working with Checkpoint Options 7:22 Demonstration: Logs and Full Recovery 6:37 Lesson 2: Planning a Backup Strategy 2:48 Backup Types 7:35 Determining Recovery Objectives 3:53 Full Database Backup Strategies 5:42 Discussion: Planning Backup Strategies Part 1 2:29 Discussion: Planning Backup Strategies Part 2 2:27 Discussion: Planning Backup Strategies Part 3 2:29 Discussion: Planning Backup Strategies Part 4 4:34 Lesson 3: Backing Up Databases and Transaction Logs 1:08 Introduction to SQL Server Backup 2:32 Media Sets and Backup Sets 7:13 Performing Database Backups 2:29 Performing Transaction Log Backups 3:40 Performing Partial and Filegroup Backups 1:32 Demonstration: Performing Backups 11:04 Lesson 4: Using Backup Options 1:09 Copy-Only Backups and Compression 4:18 Demonstration: Using Backup Compression 3:57 Encrypting Backups 2:52 Demonstration: Using Backup Encryption 6:12 Lesson 5: Ensuring Backup Reliability 1:25 Determining a Retention and Testing Policies for Backups 3:24 Options for Ensuring Backup Integrity 6:33 Demonstration: Verifying Backups 6:07 Lab: Using SQL Server Administrative Tools Module 5: Restoring SQL Server 2014 Databases – Restoring SQL Server 2014 Databases 1:56 Lesson 1: Understanding the Restore Process 1:11 Phases of the Restore Process 3:25 Types of Restores 4:15 Preparations for Restoring Backups 3:25 Discussion: Determining Required Backups to Restore 5:16 Lesson 2: Restoring Databases 0:40 Restoring a Full Database Backup 7:15 Restoring a Differential Backup 3:22 Restoring Transaction Log Backups 3:24 Demonstration: Restoring Databases 10:29 Lesson 3: Advanced Restore Scenarios 2:35 Restoring File or Filegroup Backups 6:12 Restoring an Encrypted Backup 1:51 Demonstration: Restoring an Encrypted Backup 5:46 Restoring Data Pages 12:22 Recovering System Databases 5:09 Demo - Recovering System Databases 8:25 Lesson 4: Point-in-Time Recovery 1:20 Overview of Point-in-Time Recovery 2:21 STOPAT Option 2:02 STOPATMARK Option 6:28 Performing a Point-in-Time Recovery by Using SQL Server Management Studio 1:20 Demonstration: Performing a Point-in-Time Recovery 7:42 Lab: Using SQL Server Administrative Tools Module 6: Importing and Exporting Data – Importing and Exporting Data 1:39 Lesson 1: Introduction to Transferring Data 1:14 Overview of Data Transfer 4:48 Improving the Performance of Data Transfers 7:29 Disabling and Rebuilding Indexes 7:51 Disabling and Enabling Constraints 3:01 Lesson 2: Importing and Exporting Data 1:26 The SQL Server Import and Export Wizard 3:03 Demonstration: The SQL Server Import and Export Wizard 11:07 The bp Utility 4:39 Demonstration: Using the bp Utility 10:00 The BULK INSERT Statement 5:46 Demonstration: Using the BULK INSERT Statement 4:07 The OPENROWSET Function 4:02 Demonstration: Using the OPENROWSET Function 3:37 Lesson 3: Copying or Moving a Database 1:32 Options for Copying or Moving Databases 11:32 The Copy Database Wizard 2:42 Demonstration: The Copy Database Wizard 10:38 Data-Tier Applications 3:42 Demonstration: Exporting and Importing a Data-Tier Application 6:02 Lab: Using SQL Server Administrative Tools Module 7: Monitoring SQL Server 2014 – Monitoring SQL Server 2014 1:22 Lesson 1: Introduction to Monitoring SQL Server 1:13 SQL Server Monitoring Overview 9:04 Monitoring Tools for SQL Server 9:13 Activity Monitor 5:14 Demonstration: Activity Monitor 14:00 Lesson 2: Dynamic Management Views and Functions 2:36 Overview of Dynamic Management Views and Functions 5:21 Viewing Activity by Using Dynamic Management Views 4:53 Demonstration: Querying Dynamic Management Views 10:27 Lesson 3: Performance Monitor 1:20 Introduction to Performance Monitor 3:06 SQL Server Counters 3:10 Data Collector Sets and Logs 1:43 Demonstration: Using Performance Monitor 15:12 Module 8: Tracing SQL Server Activity – Tracing SQL Server Activity 1:02 Lesson 1: Tracing SQL Server Workload Activity 1:38 SQL Server Profiler 3:17 Trace Events 7:00 Demonstration: Using SQL Server Profiler 12:04 SQL Trace 3:59 Demonstration: SQL Trace 11:28 Lesson 2: Using Traces 2:03 Replaying Traces 5:15 Demonstration: Using the Database Engine Tuning Advisor 16:23 Combining Traces with Performance Monitor Logs 1:50 Demonstration: Combining a Trace with Performance Data 4:55 Troubleshooting Concurrency Issues 3:27 Demonstration: Troubleshooting Deadlocks 6:46 Lab: Using SQL Server Administrative Tool Module 9: Managing SQL Server Security – Managing SQL Server Security 1:12 Lesson 1: Introduction to SQL Server Security 0:50 Security Concepts 4:15 SQL Server Securables 6:39 SQL Server Permissions 7:21 Lesson 2: Managing Server-Level Security 1:34 Application Security Models 4:04 SQL Server Authentication Options 2:31 Managing Logins 5:17 Managing Server-Level Roles 4:56 Managing Server-Level Permissions 2:59 Demonstration: Managing Server-Level Security 13:14 Lesson 3: Managing Database-Level Principals 2:10 Managing Database Users 5:04 Managing dbo and Guest Access 3:19 Managing Database-Level Roles 3:59 Demonstration: Managing Database Users and Roles 11:15 Managing Application Roles 6:07 Demonstration: Using an Application Role 6:16 Managing Users for a Contained Database 4:28 Demonstration: Using a Contained Database 7:53 Lesson 4: Managing Database Permissions 2:03 Database-Level Permissions 4:32 Schemas 4:49 Table and View Permissions 7:23 Executable Code Permissions 8:54 Ownership Permissions 6:27 Demonstration: Managing Permissions 9:12 Lab: Using SQL Server Administrative Tools Module 10: Auditing Data Access and Encrypting Data – Auditing Data Access and Encrypting Data 1:06 Lesson 1: Auditing Data Access in SQL Server 1:51 Discussion: Auditing Data Access 1:59 Common Criteria Auditing 2:14 SQL Trace 2:18 DML Triggers 4:22 Demonstration: Using DML Triggers for Auditing 9:58 SQL Server Audit 2:22 Lesson 2: Implementing SQL Server Audit 2:50 SQL Server Audit Overview 10:53 User-Defined Audit Actions 5:06 Managing SQL Server Audit 7:23 Demonstration: Using SQL Server Audit 12:57 Lesson 3: Encrypting Databases 1:47 Transparent Data Encryption Overview 4:19 Configuring Transparent Data Encryption 5:42 Moving Encrypted Databases 2:22 Demonstration: Implementing Transparent Data Encryption 10:03 Extensible Key Management 4:31 Lab: Using SQL Server Administrative Tool Module 11: Performing Ongoing Database Maintenance – Performing Ongoing Database Maintenance 1:35 Lesson 1: Ensuring Database Integrity 1:53 Introduction to Database Integrity 13:30 Demonstration: Using DBCC CHECKDB 11:35 Lesson 2: Maintaining Indexes 2:00 How Indexes Affect Performance 5:18 Index Fragmentation 8:09 FILLFACTOR and PAD_INDEX 5:05 Ongoing Maintenance of Indexes 6:50 Updating Statistics 3:45 Demonstration: Maintaining Indexes 12:00 Lesson 3: Automating Routine Database Maintenance 1:11 Overview of SQLServer Maintenance Plans 3:39 Demonstration: Creating a Maintenance Plan 13:33 Lab: Using SQL Server Administrative Tools Module 12: Automating SQL Server 2014 Management – Automating SQL Server 2014 Management 2:21 Lesson 1: Automating SQL Server Management 0:49 Benefits of Automating SQL Server Management 4:31 Lesson 2: Implementing SQL Server Agent Jobs 0:53 Defining Jobs, Job Step Types and Job Categories 7:45 Demonstration: Creating Jobs 21:38 Lesson 3: Managing SQL Server Agent Jobs 1:41 Viewing Job History 5:16 Demonstration: Viewing Job History 5:35 Lesson 4: Managing Job Step Security Contexts 1:02 Job Step Security Contexts 4:18 Credentials 6:18 Demonstration: Configuring Security Context 7:32 Lesson 5: Managing Jobs on Multiple Servers 1:26 Multiserver Administration Concepts 7:19 Demonstration: Configuring Multi-Server Jobs 12:16 Lab: Using SQL Server Administrative Tools Module 13: Monitoring SQL Server 2014 with Notifications and Alerts – Monitoring SQL Server 2014 with Notifications and Alerts 1:19 Lesson 1: What is in an Error? 0:47 What is an Error? 6:05 Demonstration: Viewing the SQL Server Error Log 5:02 Lesson 2: Configuring Database Mail 1:07 Overview of Database Mail 8:22 Demonstration: Configuring Database Mail 9:55 Lesson 3: Configuring Operators, Notifications and Alerts 1:28 Operator and Notifications 2:52 Demonstration: Configuring SQL Server Agent Operators 9:18 Overview of SQL Server Audit Alerts 7:34 Troubleshooting Alerts and Notifications 4:03 Demonstration: Configuring SQL Server Agent Alerts 10:45 Lab: Using SQL Server Administrative Tools View Entire Course Lesson 3: Database Management Tools and Techniques Please SIGN IN to view the full course.