TechEd 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.
- Storage alignment – Have you heard about 512 Vs 512E? Does this affect SQL Server?
- 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.
- Checkpoint Changes – There are some interesting changes to the process of Checkpoints inside SQL Server and we will discuss these internal changes.
- 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 :).
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.
[...] this was the toughest session for me to prepare – trust me. I wrote a teaser on what to expect from the session before. As the name suggests it is tough to talk about the internals (as theory) with almost no demo’s [...]
Vinod sir, it will be great if you can share your scripts on the securing SQL server session.
[...] Reference to Author’s Post on the topic: http://blogs.extremeexperts.com/2012/03/08/teched-india-2012-sql-server-internals/ [...]
[...] about TechEd 2012. Pinal and Vinod posted summary of about various sessions [here and here]. Vinod and Amit also posted about their own sessions. I liked Manas post which has link to various [...]
[...] 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. [...]