|
|
Title |
Duration |
|
|
|
|
00:18:12 |
|
|
|
Installing and Configuring SQL Server 2008 Part 1
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?
|
00:50:14 |
|
|
|
Installing and Configuring SQL Server 2008 Part 2
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.
|
00:51:48 |
|
|
|
Managing the SQL Server Agent Service
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.
|
00:41:54 |
|
|
|
Managing SQL Server Agent Jobs
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.
|
00:43:49 |
|
|
|
Administering SQL Server Agent Alerts
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.
|
00:44:56 |
|
|
|
Implementing Policy-Based Management
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.
|
00:47:44 |
|
|
|
Managing SQL Server 2008 Security Part 1
In the first of three videos on SQL Server 2008 security, we'll cover authentication, managing logins and server roles, and managing users and database roles. These are areas you'll need to know for certification and for real-world application. Tim will explore each topic and clarify issues that can trip up even seasoned pros.
|
00:52:06 |
|
|
|
Managing SQL Server 2008 Security Part 2
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.
|
00:53:15 |
|
|
|
Managing SQL Server 2008 Security Part 3
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.
|
00:47:07 |
|
|
|
Administering SQL Server 2008 Disaster Recovery Part 1
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.
|
00:45:11 |
|
|
|
|
00:42:25 |
|
|
|
Administering SQL Server 2008 Disaster Recovery Part 3
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.
|
00:41:20 |
|
|
|
Administering SQL Server 2008 Disaster Recovery Part 4
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.
|
00:47:09 |
|
|
|
Importing and Exporting Data
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.
|
00:51:02 |
|
|
|
Implementing Data Partitions
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.
|
00:26:13 |
|
|
|
Managing Indexes and Collations
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.
|
00:47:19 |
|
|
|
Monitoring and Troubleshooting SQL Server 2008 Part 1
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.
|
00:45:41 |
|
|
|
Monitoring and Troubleshooting SQL Server 2008 Part 2
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.
|
00:52:07 |
|
|
|
Optimizing SQL Server 2008 Performance Part 1
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.
|
00:44:14 |
|
|
|
Optimizing SQL Server 2008 Performance Part 2
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.
|
00:47:30 |
|
|
|
Implementing High Availability Part 1
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).
|
00:38:30 |
|
|
|
|
00:54:06 |
