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?
- 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.