-
Video 1: Introduction and Overview|04:12
Review the table of contents for this series of nuggets, and introduction to the SQL Server 2008 tools.
-
Video 2: SQL Server 2008 Functional Concepts and Architecture|32:28
Terminology; the purpose of SQL Server; the T-SQL language; Data Definition Language vs. Data Manipulation Language; and how databases work; How data is stored in pages, how filestreams and blobs work; other data types; the function of the transaction log; how database indexes work; and how database triggers work.
-
Video 3: SQL Server 2008 Physical Concepts and Architecture|25:08
CPU, memory, and storage concerns; SQL Server services; database physical architecture; database file placement strategies.
-
Video 4: Planning a SQL Server 2008 Installation|28:32
Planning for instances; planning for storage; planning for security; planning for availability.
-
Video 5: Installing SQL Server 2008|18:00
Preparing for the installation; performing the installation; verifying the installation; and launching SQL Server management tools.
-
Video 6: Creating and Using a Database|25:31
Creating a database; database options; creating a table; executing a query; managing the database file.
-
Video 7: Migrating, Consolidating, and Upgrading|27:53
Generation migration and consolidation concerns; instance configuration options; database configuration options; SQL Server version upgrades.
-
Video 8: SQL Server Instance Security|15:05
Instance-level authentication; instance-level security, including service accounts, endpoint security, TCP ports and SSL certificates, etc.
-
Video 9: SQL Server Database Security|30:01
Database and object security; ownership chains; designing security policies and audit plans; SQL Server encryption options, including Transparent Data Encryption (TDE).
-
Video 10: High Availability Overview|24:50
Goals of high availability; hardware; failover clustering; database mirroring; replication; and log shipping.
-
Video 11: Backing up SQL Server|17:41
Selecting a recovery model; backup compression options; selecting a backup type; scheduling backups; file and filegroup backup schemes; verifying backups; mirrored backups.
-
Video 12: Restoring SQL Server|38:17
Page, file, filegroup, and online restores; orphaned users; rebuilding a complete instance; encryption and recovery; recovery paths and forks; point-in-time and mark recovery; testing your recovery plan.
-
Video 13: Database Mirroring and Clustering|33:10
Mirroring: High performance, high protection, high availability; differences between mirroring and clustering; setting up mirroring; how clustering works; setting up clustering (differences from regular setup).
-
Video 14: Monitoring SQL Server|22:41
Monitoring options (system monitor, event logs, management views, WMI, remote monitoring, and triggers); data collectors; event notifications.
-
Video 15: SQL Server Performance Optimization|18:56
Dedicated Administrator Connection (DAC); locking and blocking, deadlocks, index utilization; Database Tuning Advisor.
-
Video 16: Maintaining SQL Server|29:49
Database maintenance plan; rebuilding and reorganizing indexes; how the Query Optimizer works; maintaining the Query Optimizer (statistics).
-
Video 17: Managing SQL Server|22:02
Managing resource utilization (Resource Governor and Query Governor); policy-based management; data compression strategies; automating SQL Server management (PowerShell, Agent, DDL triggers, etc).
-
Video 18: Using SQL Server Agent|16:40
Creating and managing jobs, proxies, multi-server administration, scheduling jobs.
-
Video 19: Distributing Data with SQL Server Integration Services|17:18
Introducing SSIS, SSIS package security options, scheduling SSIS packages, deploying SSIS packages.
-
Video 20: Linked Servers and Replication|28:58
Linked servers and connection strings; introducing replication, replication types; understanding replication conflicts; health monitoring for replication; horizontal and virtual partitioning in replication.
-
Video 21: Series Overview|18:12
Understanding this Series. Tackling the 70-642 Exam
-
Video 22: Installing and Configuring SQL Server 2008 Part 1|50:14
In this nugget we gain our initial "sea legs" with the Microsoft SQL Server 2008 product. We cover the SQL Server 2008 installation process, service configuration, and answer the perennial question of every new (and sometimes seasoned) DBA? 'What exactly is an instance, and how is one configured?
-
Video 23: Installing and Configuring SQL Server 2008 Part 2|51:48
In this nugget we take a fresh install of SQL Server 2008 and manage that installation. We cover adding and removing product features, implementing Database Mail functionality, and enabling full-text indexing support for the Database Engine.
-
Video 24: Managing the SQL Server Agent Service|41:54
In this nugget we undertake a detailed consideration of the SQL Server Agent, which represents the automation engine in SQL Server 2008. We cover the theoretical underpinnings of Agent, how to create operators, and how to manage operators for maximum administrative efficiency.
-
Video 25: Managing SQL Server Agent Jobs|43:49
In this nugget we continue our journey through the wild and wooly world of SQL Server Agent. We cover the creation and management of SQL Server Agent jobs, and we learn how tightly integrated Agent is with the SQL Server Integration Services (SSIS) engine.
-
Video 26: Administering SQL Server Agent Alerts|44:56
In this nugget we complete our meditation on SQL Server Agent, although this service will reappear several times throughout the remainder of this nugget series. We cover creating and administering SQL Server Agent alerts, and we learn how to centrally manage Agent jobs by leveraging the Master/Target (MSX/TSX) Agent architecture in SQL Server 2008.
-
Video 27: Implementing Policy-Based Management|47:44
In this nugget we introduce of the most compelling new features in SQL Server 2008: Policy-Based Management. We cover the basics of this new feature, how to create policies, and how to centralize policy management across multiple SQL Server 2008 instances.
-
Video 28: Managing SQL Server 2008 Security Part 1|52:06
In this nugget we introduce of the most compelling new features in SQL Server 2008: Policy-Based Management. We cover the basics of this new feature, how to create policies, and how to centralize policy management across multiple SQL Server 2008 instances.
-
Video 29: Managing SQL Server 2008 Security Part 2|53:15
In this nugget we continue our "haunted hayride" through the mystical, magical world of SQL Server security. We cover such technologies as the logon trigger, the use of schema to assign object permissions, and the controversial tactic of enabling cross-database ownership chaining.
-
Video 30: Managing SQL Server 2008 Security Part 3|47:07
In this nugget we complete our SQL Server 2008 security triptych. We cover how to audit a SQL Server 2008 instance and how to implement Transparent Data Encryption, or TDE. TDE is another much-anticipated new feature in SQL Server 2008, and is an extremely impressive technology.
-
Video 31: Administering SQL Server 2008 Disaster Recovery Part 1|45:11
In this nugget we take on a subject that receives wide coverage on the 70-432 exam: disaster recovery. We cover the creation and configuration of databases, data files, transaction logs, and filegroups. We also learn how to set database options, configure database recovery models (this is another topic we revisit several times in upcoming nuggets), and attach/detach databases from the database engine.
-
Video 32: Administering SQL Server 2008 Disaster Recovery Part 2|42:25
In this nugget we undertake the process of database backup in SQL Server 2008. We cover backup architecture, database backup, transaction log backup, data file backup, and filegroup backup.
-
Video 33: Administering SQL Server 2008 Disaster Recovery Part 3|41:20
In this nugget we examine the other side of the backup equation: data restoration. We cover the architectural and theoretical fundamentals of SQL Server 2008 restore and recovery. We then learn how to perform online and offline database restores.
-
Video 34: Administering SQL Server 2008 Disaster Recovery Part 4|47:09
In this nugget we finish up our treatment of SQL Server disaster recovery. We cover database snapshots, ensuring database integrity, and we reintroduce maintenance plans (which we originally discussed in our nuggets on SQL Server Agent), this time applying them to disaster recovery.
-
Video 35: Importing and Exporting Data|51:02
In this nugget we learn a crucial job function for most SQL Server DBAs: data import and export. We cover the mechanics of data import and data export, and then review the major import/export tools included in SQL Server 2008: the bcp utility, the BULK INSERT statement, the OPENROWSET function, the Import and Export Wizard, and the SSIS Import/Export tools.
-
Video 36: Implementing Data Partitions|26:13
In this nugget we learn a crucial job function for most SQL Server DBAs: data import and export. We cover the mechanics of data import and data export, and then review the major import/export tools included in SQL Server 2008: the bcp utility, the BULK INSERT statement, the OPENROWSET function, the Import and Export Wizard, and the SSIS Import/Export tools.
-
Video 37: Managing Indexes and Collations|47:19
In this nugget we turn our attention to what is perhaps the most important element to high-performance querying: indexes. We cover index architecture, index types (including the often-confused difference between clustered and non-clustered indexes), creating indexes, optimizing indexes, and, as a special bonus, a brief consideration on administering collations in SQL Server 2008.
-
Video 38: Monitoring and Troubleshooting SQL Server 2008 Part 1|45:41
In this nugget we will learn how to monitor and troubleshoot SQL Server 2008. We cover how transactions work (the ACID model, etc.), the SQL Server locking architecture, how to use Activity Monitor to diagnose and resolve concurrency problems, and using transaction-oriented DMVs.
-
Video 39: Monitoring and Troubleshooting SQL Server 2008 Part 2|52:07
In this nugget we carry over our discussion of monitoring and troubleshooting SQL Server 2008. We cover how to locate SQL Server 2008 event and error information. We also learn how to profile and monitor SQL Server 2008 by using tools such as SQL Server Profiler, the Performance Studio, System Monitor, and the Reliability and Performance Monitor.
-
Video 40: Optimizing SQL Server 2008 Performance Part 1|44:14
In this nugget we examine a couple ways in which we can dramatically improve the performance of our SQL Server Database Engine. We cover the Resource Governor, a brand-new feature in SQL Server 2008 that allows us to throttle and prioritize CPU and memory resources among SQL Server processes. We also learn how to tune databases using the DTA utility.
-
Video 41: Optimizing SQL Server 2008 Performance Part 2|47:30
In this nugget we conclude our two-part mini-series on optimizing SQL Server 2008 performance. We cover using the brand-new Data Collection feature (called “Performance Studio” in pre-RTM), and the Windows Server 2008 Reliability and Performance Monitor tool.
-
Video 42: Implementing High Availability Part 1|38:30
In this nugget we examine another big 70-432 subject: high availability. We cover the basics of high availability services, configuring database mirroring (which protects a single database), and implementing failover clustering (which protects the entire SQL Server instance).
-
Video 43: Implementing High Availability Part 2|54:06
Implementing Log Shipping. Implementing Replication