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 :).

Tags: , , , , , , , , , ,

This entry was posted on Thursday, March 8th, 2012 at 22:11 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “TechEd India 2012: SQL Server Internals”

  1. San Aryan says:

    Vinod sir, it will be great if you can share your scripts on the securing SQL server session.

  2. […] Peeling SQL Server like an Onion: Internals Demystified – Vinod Kumar has been writing about this extensively on his other blog post. In recent conversation he suggested that he will be creating very exclusive content for this presentation. I know Vinod for long time and have worked with him along many community activities. I am going to pay special attention to the details. I know Vinod has few give-away planned now for attending the session now only if he shares with us. […]

Leave a Reply