THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

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

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

Published Friday, October 24, 2008 9:09 PM by Kalen Delaney
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Steve Dassin said:

I wonder if I speak for others in complimenting you on your diligence in keeping up with your endless gluttony of self-promotion. Many find it hard to overcome their humility and publicly advertise the size of the portion of their self-worth. We can all learn by example.

October 25, 2008 7:50 PM
 

foo said:

Steve, your comments are rude and uncalled for; are you a child stuck in a man's body?

October 28, 2008 9:46 AM
 

Tony Rogerson said:

Alas we pure independents without a company to support us can't do all that we do out in the community in terms of giving considerable amount of our free time without having financial support to pay our bills, mortgages etc... so the infrequent "I'm here doing this, come and see me..." quote to me is fine - swings both ways. I guess you will now stop your continuous plugging of RAC and that other obscure little used SQL product on the public forums which you seem to do most frequently.

November 3, 2008 3:09 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Favorite Non-technical Sites or Blogs

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement