Σεμινάρια >> Σεμινάρια Πληροφορικής >> Σεμινάρια SQL Server - Powerbuilder >> SQL Server 2008 Internals and Query Tuning

Seminar SQL Server 2008 Internals and Query Tuning

Ελαχιστοποίηση

 Course Outline and Description

This is an advanced 5-day course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2008 and cover features specific to that version, but most of the information is relevant to SQL Server 2005 as well.
This 5-day intensive seminar was developed by one of the world's leading experts in SQL Server internals. Topics to be covered include the following:

  • SQL Server Architecture and Metadata
  • Physical Storage Structures
  • Index Design and Tuning
  • Query Processing and Query Plans
  • Optimization and Recompilation
  • Concurrency Control: Locking, Blocking and Row Level Versioning
  • Query Tips and Techniques
  • Troubleshooting Tools

The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. A reference CD including all of the demonstration scripts as well as dozens of whitepapers and useful tools will be distributed at the end of the week.


About the Author

The author of the course is Kalen Delaney, author of the bestselling books SQL Server 2008 Internals, Inside SQL Server 2005: The Storage Engine and Inside SQL Server 2005: Query Tuning and Optimization. Kalen has been a columnist at SQL Server Magazine since the first issue, as well as writing for MSDN and TechNet Magazines. Kalen's courses and seminars on SQL Server Internals have successfully delivered at internal Microsoft training events and as on-site courses for premier Microsoft partners around the world. Kalen is considered as a top expert in SQL Server and has been working with SQL Server for 23 years. More information about Kalen is available at her web site:


http://sqlserverinternals.com

Who is it For?

This course is suitable for developers/administrators that want to find out more on  Microsoft SQL Server 2005/2008 internals.
 
Seminar Dates and Venue

The seminar will take place from 2nd of May until 6th of May.
We will announce the venue of the course very soon.The venue will be in the center of Athens and easily accessible by public transportation.

 Prerequisities for attending

 Everyone attending must have a good working knowledge of SQL Server.

Course Structure and Details

  
DAY 1


Module 1: SQL Server Architecture and Metadata


Architecture Overview
Metadata Overview
Dynamic Management Views
Memory Management
Process Management
The Resource Governor
SQL Server 2005 Configuration Tools
 
Module 2:  File and Table Structures


Tools for Examining Physical Structures
Database Files and Space Allocation
Table and Page Structures
Large Datatype Storage
Sparse Columns
Data Compression

DAY 2

Module 3: Logging and Recovery


Structure of The Transaction Log
Management of the Transaction Log
Recovery and Recovery Models
 
Module 4: Index Structures and Partitions


Heaps and B-Trees
Clustered Indexes
Nonclustered Indexes
Fragmentation
Rebuilding Indexes
Partitioning Overview
Metadata for Partitioning

DAY 3


Module 5: Query Processing and Query Plans

SHOWPLAN
Query Plan Elements
Types of Joins
Aggregation
Sorting
UNION
Data Modification

Module 6: Optimization and Recompilation


Optimization Overview
SQL Server’s Query Optimizer
Plan Management and Reuse
Causes of Recompilation
Forcing Recompilation
Optimizer Metadata
XML Plans 

DAY 4

Module 7: Concurrency Control


Optimistic and Pessimistic Concurrency
ANSI SQL Isolation Levels
Pessimistic Concurrency Control with Locking
Aspects of Locking
Locking Resources
Controlling Locking
Locking Metadata
Optimistic Concurrency Control with Row Versioning
Snapshot Isolation
Snapshot Isolation Metadata
Database Snapshots 
 
Module 8: Index Tuning


Covering Indexes
Included Columns
Filtered Indexes
General Indexing Strategies 


DAY 5


Module 9: Query Tuning

Query Improvements
Search Arguments
Constants and Variables
Query Hints and Plan Guides
 
Module 10: Tracing and Troubleshooting


Verifying Database Consistency with DBCC
Maintenance Suggestions
Tracing and Troubleshooting Tools

Course Instructor

 

 

Maciej Pilecki is a SQL Server Most Valuable Professional (MVP), Microsoft Certified Trainer and Consultant with Project Botticelli.Maciej is  also holder of the  very prestigious MCM certification which is the highest  Microsoft technical certification and very few people on the world hold this certification. He has many years of international experience in Microsoft SQL Server database development, optimization and troubleshooting. He spends most of his time travelling around the world either advising his many clients on how to improve performance and reliability of their databases, or sharing the lessons learned with conference and user group audiences worldwide, where he is a popular and highly rated speaker. His favourite topics are the internals of the SQL Server database engine, including SQLOS, Storage Engine and Query Optimizer and Performance Tuning. In his consulting work, Maciej specializes in high availability, scalability, performance tuning and migrations between database platforms. There is never a case too difficult for him to solve as he builds scalable and performing databases for his clients.
Maciej likes skiing with his son and trekking in the mountains in his spare time. He has recently climbed Lobuche East – a 21,000 foot/6100 meters mountain in the Everest region of the Himalayas. He is already planning his next trip to this beautiful region.

Catering - Coffee Break

There will be coffee breaks and lunch with beverages for the duration of the course.



 

Text/HTML

Ελαχιστοποίηση

 

 Σχετικά Σεμινάρια

SQL Server 2008 Internals and Query Tuning  ||  SQL Server 2008 Administration-Νέα χαρακτηριστικά  ||  SQL Server 2008 Administration   ||  SQL Server 2008 Reporting Services   ||  SQL Server Programming   ||  Εισαγωγή στον Microsoft SQL Server 2005   ||  Αξιοποιήστε τα δεδομένα της επιχείρησής σας   ||  Εισαγωγή στα Integration Services  ||  PowerBuilder Programming Επίπεδο Ι (Basic)  ||  PowerBuilder Programming Advanced (Επίπεδο ΙΙ)  ||  Microsoft® Access Fundamentals  ||  Προγραμματισμός με την Microsoft Access(Επίπεδο I)  ||  Microsoft Access Επίπεδο I

Εκδηλώστε Ενδιαφέρον

Ελαχιστοποίηση

Πληροφορίες

Ελαχιστοποίηση

Επικοινωνία

Ελαχιστοποίηση

  Q-Training  Αθήνα: Εκπαιδευτικό Κέντρο: Καλλιρρόης 85, 117 45, Νέος Κόσμος (100μ από Metro Fix), Κεντρικά Γραφεία: Ηρακλέους 11, 117 43, Νέος Κόσμος Τηλ. Κέντρο: 210 9244468  Fax. 210 9244510 e-mail: info@q-training.gr   Θεσσαλονίκη: Τηλ. 23920 92542, Fax. 23920 92543, Ιωάννινα: Πλατεία Ομήρου 12, Τηλ. 2651067888 Σύρος: Αντώνιος Βουτσίνος, Φολεγάνδρου 17, Τηλ. 2281086844

Αρχική | Προγραμματισμένα Σεμινάρια | Δομή Site