Archive for March 8th, 2012

TechEd India 2012: SQL Server Internals March 8th, 2012

Vinod Kumar

SQLInternalsTechEd India 2012 is one event I wait in anticipation every year and the challenge to myself is to give audiences (like you) something really unique. In this constant struggle to feature, educate and exploring technology, I am so thrilled every year to give this unique perspective. Till last year, I preferred to talk around the “SQL Server – Disaster recovery” scenarios – with backup, without backup, with DBCC commands etc. Those were wonderful experiences and I still know for the three years you have associated me with that trend. This TechEd, I plan to start the next trend of sharing – “Peeling SQL Server like an Onion: Internals Demystified”. Yes, this is the topic I plan to talk at the SQL Server Administration track on Day 3 (March 23rd).

What to expect in this session?

Personally, I don’t plan to give away so easily what all you will find in this session. But I can assure you some wonderful insights and working of SQL Server 2012 in this session.

  1. Storage alignment – Have you heard about 512 Vs 512E? Does this affect SQL Server?
  2. Security Changes – though there is a session around Contained Databases, that will talk about the indepth details of security. Here I will bring you to light some of the other security changes inside SQL Server 2012.
  3. Checkpoint Changes – There are some interesting changes to the process of Checkpoints inside SQL Server and we will discuss these internal changes.
  4. Memory Changes – This is the meat of the topic. There are tons of interesting changes to the multi-page allocator, VAS changes etc that will get discussed.

And not to forget you will get tons of demo and almost the session flow is out here (not all :)). But wait for surprises at the session something not to be missed too.

I am also open to hearing from you too if you plan to attend my session and want some content to be included. Feel free to send me a note :).

Continue reading...