Working with TSQL, Transactions and Performance Tuning

Teaching the Maintaining SQL Server 2005 class tonight.
Week 5 – Working with TSQL, Transactions and Performance Tuning
Here is the slide deck for the class tonight.  DBA_Essentials_Class05_TSQL_TXN_and_Perf.pdf

Creating Stored Procedures, Functions, and Triggers

Teaching the Maintaining SQL Server 2005 class tonight.

Week 4 – Creating Stored Procedures, Functions, and Triggers

Here is the slide deck for the class tonight. DBA_Essentials_Class04_Stored_Procedures_Functions.pdf

Creating Tables – Data Integrity, and XML

Teaching the Maintaining SQL Server 2005 class tonight.

Week 3 – Creating Tables – Data Integrity, and XML

Here is the slide deck for the class tonight.  DBA_Essentials_Class03_Creating_Tables_Data_Integrity.pdf

Database Design, Normalization, Analyzing Capacity Needs, Service Broker

Teaching the Maintaining SQL Server 2005 class tonight.

Week 2 – Database Design, Normalization, Analyzing Capacity Needs, Service Broker

Here is the slide deck for the class tonight.   DBA_Essentials_Class02_Design_Capacity.pdf