Did You Know? More online seminars!

Kalen Delaney — Thu, 22 Apr 2010 23:20:00 GMT

I am in Tucson again, having just recorded two more online workshops to be broadcast by SSWUG. We haven't set the dates yet, but we are thinking about offering a special package deal for the two of them. The topics really are related and I think they would work well together.

They are both on aspects of Query Processing. The first was on how to interpret Query Plans and is an introduction to the topic. However, it only includes a discussion of how SQL Server actually processes your queries. For example, what exactly does a Hash Join or Stream Aggregation mean? The second was on Caching and Recompiling, basically discussing how SQL Server stores and reuses the plans once it creates them. And, how to tell if reusing or recompiling the best option.

I'll post more details and links once they are available.

Also, I just realized I had never announced the winners of the drawing from my previous seminar.

Lorna M. won a copy of my SQL Server 2008 Internals book, and
Bob L. won a copy of SQL Server MVP Deep Dives

More books will be given away at future seminars!

~Kalen

Did You Know? You Can Win a Copy of My Next Book!

Kalen Delaney — Sat, 25 Oct 2008 03:09:00 GMT

November is conference month for me, and I'll be giving away vouchers for signed copies of my new book, to be mailed to the winners as soon as I receive my author copies.

I'll be giving away one each day of my seminars in London and Seattle!

The London seminars, for SQLKnowHow, are taking place the week of November 3-7, so I'll actually be out of the country the day of the US national elections. I haven't figured out if that is good news or bad news yet; I guess it depends on who wins.

Monday, November 3 is SQL Server Data Storage Formats: Internals, Performance and Best Practices. This will be the first delivery of the seminar I'll be presenting for my preconference session at PASS.

This seminar will describe all the different formats available for storing data, including the new filestream data, compressed data and sparse data columns in SQL Server 2008. We’ll look at the metadata to determine exactly what is being stored and where, and discuss best practices for choosing the particular type of storage format.

Tuesday, November 4 is SQL Server Concurrency Control: Locking, Blocking and Row Versioning

In this seminar I'll look at the concurrency enhancements made in SQL Server 2005 based on row-level versioning which implements optimistic concurrency. We’ll compare concurrency management with row versioning to concurrency management with locking and blocking. We'll look at the metadata that stores information about your transactions, and look at tools for troubleshooting concurrency problems. We will also look at the locking enhancements added to SQL Server 2008.

Wednesday - Friday, November5-7 is SQL Server Data Internals and Tuning

This seminar is a 3-day version of my 5-day SQL Server Internals and Tuning class that I have delivered all over the world. The seminar 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 and some is relevant to SQL Server 2000. Topics to be covered include the following:

SQL Server Storage Metadata
Tools for exploring storage structures
Physical Storage Structures
Index Design and Tuning
Query Processing and Query Plans
Optimization and Recompilation
Query Tuning Tips and Techniques

So for each of these 5 days, I'll be giving away a book a day, plus other giveaways as well.

Then later in November, on 18 November, I'll be giving a preconference session at PASS, in Seattle. In addition to vouchers for my new book, I'll have a couple of copies of my SQL Server 2005 books to give away.

So hopefully I'll see many of you soon!

~Kalen

Search results matching tags 'Books' and 'seminars'

Did You Know? More online seminars!

Did You Know? You Can Win a Copy of My Next Book!