quote:

---

Originally posted by Kristen

"This guy (?) has just arrived and looks like he knows a thing or two.

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=27972

Kristen

---

quote:

---

Christine A. Toth


On these 21 CD's you can learn all you would ever possibly need to know to adminster this latest version of SQL Server. The instuctor explains difficult concepts in a way that's easy to understand. Best SQL Server guide available!

---

quote:

---

CD-ROM 1 - OVERVIEW (2 hours 32 minutes)
1. Introduction and Welcome Notes
2. Your First SQL 2005 Email Report to the CEO
3. 2005 the Sequel to 2000
4. What is New in SQL Server 2005
5. History of Relational Database Technology and SQL
6. DBA Career Opportunity
7. Women as SQL Server 2005 DBA-s
8. SQL Server 2005 for VB, Java, C++ and Web Developers
9. The Advantages of the SQL Language
10. Microsoft's New Business Intelligence Platform
11. Ten Guidelines for DBA & Developer Excellence
12. Cutting Edge Technologies in SQL Server 2005

---

quote:

---

So Kalman, is Christine A. your wife or a relative of yours?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

---

quote:

---

Originally posted by Peso

You mean this topic?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81945

You mean that is not covered on his 21 discs?

quote:

---

CD-ROM 1 - OVERVIEW (2 hours 32 minutes)
1. Introduction and Welcome Notes
2. Your First SQL 2005 Email Report to the CEO
3. 2005 the Sequel to 2000
4. What is New in SQL Server 2005
5. History of Relational Database Technology and SQL
6. DBA Career Opportunity
7. Women as SQL Server 2005 DBA-s
8. SQL Server 2005 for VB, Java, C++ and Web Developers
9. The Advantages of the SQL Language
10. Microsoft's New Business Intelligence Platform
11. Ten Guidelines for DBA & Developer Excellence
12. Cutting Edge Technologies in SQL Server 2005

---

Peter Larsson
Helsingborg, Sweden

---

quote:

---

CD-ROM 1 - OVERVIEW (2 hours 32 minutes)
1. Introduction and Welcome Notes
2. Your First SQL 2005 Email Report to the CEO
3. 2005 the Sequel to 2000
4. What is New in SQL Server 2005
5. History of Relational Database Technology and SQL
6. DBA Career Opportunity
7. Women as SQL Server 2005 DBA-s
8. SQL Server 2005 for VB, Java, C++ and Web Developers
9. The Advantages of the SQL Language
10. Microsoft's New Business Intelligence Platform
11. Ten Guidelines for DBA & Developer Excellence
12. Cutting Edge Technologies in SQL Server 2005

CD-ROM 2 - MANAGEMENT TOOLS (3 hours 2 minutes)
1. Editions of SQL Server 2005
2. Installing & Configuring SQL Server 2005
3. Default and Named Server Instances
4. SQL Server 2005 Program Group
5. Configuration Manager
6. Management Studio - SSMS
7. SSIS Import and Export Wizard
8. Query Editor
9. Query Designer
10. SQL Profiler
11. SQLCMD Command Prompt Utility
12. Books Online - BOL
13. Database Tuning Advisor
14. Business Intelligence Development Studio
15. Analysis Services - SSAS
16. Reporting Services - SSRS
17. Notification Services - SSNS
18. Real-Time Event Notifications

CD-ROM 3 - ENTERPRISE SECURITY (2 hours 32 minutes)
1. Principals, Securables and Permissions
2. Metadata Visibility by Principals
3. Setting up Logins with Management Studio
4. Setting up Logins, DB Users, Roles with Statements
5. Fixed Server Roles
6. Additional Login and Role Statements
7. DB User and Role Management by MS
8. Creating Security Accounts in the Enterprise
9. SCHEMAs and Security Hierarchy
10. CREATE CERTIFICATE, Encryption and Decryption
11. 3DES Encryption of Credit Card and Bank Data
12. User Password Encryption in Applications
13. Corporate Email Encryption

CD-ROM 4 - DATABASE BACKUP (3 hours 5 minutes)
1. Site Server Architecture and Deployment
2. Database Backup Encryption
3. RAID Storage Description
4. Storage Offers from Major Computer Manufacturers
5. Database Backup Using Management Studio
6. Database Backup Using Scripts
7. Advanced Details on RAID Storage
8. Advanced Backup Options Using Query Editor
9. Advanced Backup Options Using MS
10. Creating a Database Maintenance Plan
11. The bcp Utility
12. Configuring Database Mail
13. Backup Success or Failure Email Notification
14. 7 Keys to DBA Success

CD-ROM 5 - DATABASE RESTORE (2 hours 23 minutes)
1. Disaster Recovery Planning
2. Backup Set Verify with RESTORE VERIFYONLY
3. Database Restore Using Management Studio
4. Restore Database Using Scripts
5. Recovery of Databases at Startup
6. Copy Database Using Restore
7. Rebuilding the Master Database
8. Media Sets and Families
9. Initializing and Password Protecting Media
10. Overwrite or Append to Media
11. BULK INSERT Examples
12. Openrowset, Opendatasource and Openquery

CD-ROM 6 - PERMISSIONING (2 hours 35 minutes)
1. Builtin and Implied Permissions
2. Permissions Hierarchy
3. CREATE SCHEMA with AUTHORIZATION
4. System Administrator(sa) Permissions
5. Non-sa Server Roles Permissions
6. Fixed Database Role Permissions
7. Object Ownership Within the Database
8. Managing Permissions
9. Statement Permissioning in Management Studio
10. Object Ownership Chains
11. ALTER SCHEMA and ALTER AUTHORIZATION
12. Permissioning Strategy
13. Server Registration Export and Import

CD-ROM 7 - DATABASE INFRASTRUCTURE (2 hours 42 minutes)
1. Create Database by Management Studio
2. Accounting Database Setup and Initialization
3. Create Database by Statement Execution
4. Checking DB Properties by MS
5. Checking DB Properties by sp_helpdb
6. Create Database with Filegroups
7. Alter Database with Management Studio
8. Alter Database with Query Editor
9. Advanced Details on Create Database
10. Remove or Rename Database
11. Creating Database Snapshots for Reporting
12. Moving Databases between Different Servers
13. Very Large Databases - VLDB
14. Database Console Commands - DBCC

CD-ROM 8 - SAMPLE DATABASES (3 hours 5 minutes)
1. Diagram of AdventureWorks Database
2. Primary Key and Foreign Key: RDBMS Basics
3. 1NF, 2NF & 3NF Normal Forms in AdventureWorks
4. AdventureWorks Sample Database Overview
5. AdventureWorks Business Scenarios
6. AdventureWorks Data Dictionary
7. Creating Database Diagrams
8. Pubs Sample Database Overview
9. Northwind Sample Database Overview
10. More on Pubs from the Query Editor
11. More on Northwind from the Query Editor
12. Advanced Review of the Pubs Database
13. Advanced Review of the Northwind Database
14. Accounting DB Review: GL, AP, AR & Inventory

CD-ROM 9 - DATABASE DESIGN (3 hours 5 minutes)
1. Logical Data Modelling
2. Data Types for Table Columns
3. Creating Tables by Statements
4. Advanced Create Table Examples
5. Create Special Tables and Copy Tables
6. Observing Table Behaviour
7. Creating Tables by Management Studio
8. Primary Key and Foreign Key Constraints
9. ALTER TABLE and Changing Tables by MS
10. Partitioned Table, Partition Function and Scheme
11. Code, Translate and Lookup Table Design
12. Normalization, NULLs and Debated Design Issues
13. Database Design and Programming Standards

CD-ROM 10 - THE SELECT STATEMENT (3 hours 7 minutes)
1. Inner Join, Self Join, Outer Join and Cross Join
2. Simple SELECT Queries
3. SELECT Examples Featuring ORDER BY
4. SELECT with Nested and Correlated Subqueries
5. SELECT with UNION, COMPUTE, ROLLUP and CUBE
6. SELECT with String, Date and Math Functions
7. SELECT with CHECKSUM and Statistical Functions
8. Dynamic SQL
9. SELECT with GROUP BY Clause
10. SELECT with PIVOT and UNPIVOT
11. Recursive Queries
12. ROW_NUMBER, RANK, DENSE_RANK and NTILE
13. TOP, TABLESAMPLE, INTERSECT and EXCEPT
14. Crosstab Query with CTE and PIVOT
15. Multidimensional Cross Tabulation
16. Business Intelligence Dashboards

CD-ROM 11 - MODIFY DATA (3 hours 10 minutes)
1. INSERT Statement with VALUES Using QE
2. INSERT.....SELECT Statement
3. INSERT.....EXEC Statement
4. DELETE Statement Examples
5. UPDATE Statement Examples
6. UPSERT: Combination of UPDATE and INSERT
7. Modifying Data with Cursors and Subqueries
8. Logged and Nonlogged Operations
9. Common Table Expression - CTE
10. The OUTPUT Clause
11. INSERT with CTE and OUTPUT
12. UPDATE with CTE and OVER(PARTITION BY...)
13. Deleting Duplicate Rows with CTE
14. Updating Binary Mask and CSV List Columns

CD-ROM 12 - DATA INTEGRITY (3 hours 3 minutes)
1. Data Integrity Implementation in AdventureWorks
2. Surrogate Key Architecture
3. Data Integrity Templates
4. Stored Procedure vs. Ad-hoc SQL Script
5. Entity, Domain and Referential Database Integrity
6. Entity Integrity Definition Using Management Studio
7. Scripting Tables and Related Objects Using MS
8. Domain Integrity Constraints Using Query Editor
9. Referential Integrity Explanation and Constraints
10. User Defined Data Integrity Objects
11. Business Rules Enforcement with Triggers
12. Visio Logical Database Diagram
13. Database Design with Visio
14. Database Diagram Design and Export
15. Comparing and Synchronizing Databases

CD-ROM 13 - PROGRAMMABILITY (3 hours 4 minutes)
1. Simple Stored Procedures
2. Stored Procedures with OUTPUT Parameters
3. Stored Procedures in AdventureWorks Database
4. CREATE TRIGGER Examples
5. Triggers with DELETED and INSERTED Tables
6. INSTEAD OF Triggers and AFTER Triggers
7. DDL (Data Definition Language) Triggers
8. Views Definition and Examples
9. CREATE FUNCTION Examples
10. User Defined Function with Assembly
11. Temporary Tables, Optimization and tempdb
12. EXECUTE AS for Execution Context Definition
13. Multiple, Nested and Correlated CTE-s
14. Debugging Stored Procedures and CTE-s

CD-ROM 14 - TRANSACT-SQL (3 hours 1 minute)
1. TRANSACT-SQL, Batch, and Scripts
2. BEGIN, COMMIT, ROLLBACK TRANSACTION
3. TRY, CATCH for Exception Handling
4. Locks, Isolation Levels and Deadlocks
5. Snapshot Isolation for OLTP Concurrency
6. PROGRAMMING STATEMENTS in Transact-SQL
7. User Defined and System Stored Procedures
8. Linked Servers and 4-part Addressing
9. CROSS APPLY and OUTER APPLY Operators
10. DBA Script Generator Using Query Editor
11. Undocumented T-SQL Features
12. Dynamic PIVOT and Crosstab Scripts

CD-ROM 15 - SSIS IN THE ENTERPRISE (3 hours 8 minutes)
1. Overview of Integration Services
2. Enterprise-Level SSIS Application Examples
3. SSIS Import Wizard
4. Importing Data from Multiple Flat Files
5. SSIS Export Wizard
6. Building Simple SSIS Projects
7. Filtering Errors in Data: Ignore or Redirect
8. Advanced Integration Services
9. Loop Containers: For Each File Enumerator
10. SSIS Package Examples
11. Conditional Split & OnError Event Handler
12. Importing XML Data with SSIS Wizard
13. Importing XML Content with SSIS
14. Dynamic SSIS Package: Variables & Expressions
15. Scheduling SSIS Package for Execution
16. Upgrading DTS Packages to SSIS
17. Database to Database Transfer

CD-ROM 16 - SQL SERVER AGENT (2 hours 50 minutes)
1. Automating Administrative Tasks
2. SQL Agent Roles: Operator, Reader and User
3. Overview of Job Scheduling in Windows Environment
4. Properties of Jobs, Defining Jobs Using Management Studio
5. Setting up Multi Steps Jobs with Success and Failure Options
6. Creating Jobs Using Scripts
7. Database Mail Setup for Notifications
8. Configuring Operators Using MS
9. Configuring Alerts Using MS
10. Configuring Proxies Using MS
11. Trouble Shooting SQL Server Agent
12. Automating Night Processing
13. Database Maintenance Plan Jobs

CD-ROM 17 - REPLICATION (2 hours 40 minutes)
1. Log Shipping for Disaster Recovery
2. Live Demonstration of Log Shipping
3. Configuring Log Shipping from Primary to Standby
4. Failover to Standby DB in Case of Disaster
5. Snapshot, Transactional and Merge Replication Overview
6. Live Demonstration of Transactional Replication
7. Configuring Publishers, Subscribers and Distributors
8. Replication Agents and Monitors
9. Setting up Distributor Publisher Using Scripts
10. Examining the Distributor Database
11. Disable Publishing and Distribution
12. Peer-to-Peer Transactional Replication
13. Database Mirroring for Failover Redundancy

CD-ROM 18 - MANAGEMENT STUDIO (2 hours 55 minutes)
1. Dynamic UI, Docking, Auto Hiding Windows
2. Query Editor
3. Server and Database Dashboards
4. Summary Page Reports
5. Advanced Template Explorer and Design
6. Solution Explorer Projects to Store Scripts
7. Management Studio Top Menubar Walk Through
8. Object Explorer
9. Toolbar and Server Right Click Menu
10. SQL Server 2005 Properties
11. Databases Right Click Menu
12. Database Properties Panel
13. SQL Server Agent, Activity Monitor and Logs
14. Replication, Security, and Support Services

CD-ROM 19 - PERFORMANCE TUNING (3 hours 4 minutes)
1. Ten Step Performance Tuning Bootcamp
2. Dynamic Management Views and Functions
3. Deadlock Visualization and Avoidance
4. Correlating Perfmon Chart with Profiler Trace
5. 24/7 Monitoring of Production Databases
6. Windows Performance Monitor
7. Setting up Trace Using SQL Profiler
8. Examining the Content of a Saved Trace
9. Examining Trace Table in Query Editor
10. sp_who, sp_lock and sp_monitor Commands in QE
11. Review of the Options Available in SQL Profiler
12. Index Design and Maintenance Using DBCC
13. Index Defragmentation and Reindexing with Fill Factor
14. Index-Related Dynamic Management Views & Functions
15. Database Tuning Advisor
16. Horizontal and Vertical Partitioning

CD-ROM 20 - EXTRA TOPICS (3 hours 2 minutes)
1. Sending Email Messages with Results of Queries
2. Formatting Queries/Sprocs for HTML Email
3. Configuring SQL Reports for Email Distribution
4. SQL Server Configuration Manager
5. SQL Server 2005 Surface Area Configuration
6. Command Prompt Utilities
7. XML Overview, FOR XML clause in SELECT
8. OPENXML Examples
9. Xquery - XML Query Language
10. Advanced Xquery Examples
11. Primary and Secondary XML Indexes
12. Example for Application Programming using CLR
13. Creating Indexed Views
14. Full-text Indexing, Full-text Search
15. Project Setup in Management Studio
16. Upgrading and Migrating to SQL Server 2005
17. Service Packs and Downloads at Microsoft.com

CD-ROM 21 - HOW TO (3 hours 3 minutes)
1. How To Resolve Performance Bottlenecks
2. How To Use XML Bulk Load for Large Datasets
3. How To Create an Index with Included Columns
4. How To Filter Invalid Data with TRY-CATCH
5. How To Setup Event Notification for Logins
6. How To Debug Sprocs with Visual Studio 2005
7. How To Use the SQLCMD Utility
8. How To Connect as Dedicated Administrator
9. How To Maintain DB-s in 24/7 Web Environment
10. How To Monitor CPU Busy, Disk Reads and Writes
11. How To Configure an ODBC Datasource
12. How To Use Windows Event Viewer
13. How To Configure Linked and Remote Servers
14. How To Administer from Command Prompt
15. How To Export Table into XML File
16. How To Import XML File into Table

Bonus CD
1. DBA Survival Scripts
2. Developer Survival Scripts
3. Database Designer Survival Scripts
4. Sample Scripts Used in Videos
5. Ten Step Performance Tuning Bootcamp Scripts
6. Table Space Usage Stored Procedure
7. Database Compare Script
8. Directory Tree with CTE Script
9. Calendar Generator Function
10. Export Table Data as INSERTS Sproc
11. SQL Server 2005 Audit Script
12. Accounting Table Definitions Script
13. Complex CTE-s Scripts
14. Application User Password Encryption Sprocs
15. Email Encryption Sprocs

---

quote:

---

In the permissions tape he actually had an error, tried to figure it out, then moved on without an explanation or fixing the problem.

---