SQL Rally – Kevin Kline Microsoft SQL Server Internals & Architecture

In session @ SQL Rally Nordic, attending Kevin Kline’s session about Microsoft SQL Server Internals & Architecture.

Going through the engine in two ways, reads and writes.

ACID properties of Transactions – introduce some methods to clean up data after, say a deletion of an order.

Each one of these introduces an overhead in the relational database, due to the ACID properties.

If we decide to not have ACID operations in database, we have a really fast database engine, early in the days og MYSql there was no ACID properties. Neither in the NoSQL and facebook databsae engine have ACID, there is no need for these characteristics when we’re not handling money, when it comes to images and video’s there is no need for the assurance of the transactions.

Kevin walks us through the SQL enginge for a SELECT from a user:

  • TDS
  • Protocol Layer (SNI)
  • Relational Engine
    • CMD PArser
    • Optimiser
    • Query Executor


Microsoft Exam 70-457/58 Passed

Amidst all the talk about the death of MCM certification from Microsoft, i’ve 

been reading and catching up on my SQL 2012 knowledge.

So that I could transition my current MCITP 2008 Business Intelligence to SQL server 2012 MCSE, I took the 70-457 exam last friday and passed with well over 800 points.

This morning I took the 70-458 exam and passed that as well, this time the administration of SQL server bumped the overall score down a little, but I passed.

Now in 14 days time I’ll have the last one, the 70-460 exam and after that i’ll med certified SQL Server 2012 MCSE ;O)

Great way to start my friday, and the weekend.

Exam prep for SQL server 2012 MCSA

Microsoft have just launched their youtube channel with exam prep videos for Microsoft SQL Server 2012 MCSA.

There are videos for the following exams:

  • 70-461 – Quering Microsoft SQL server 2012
  • 70-462 – Administering Microsoft SQL server 2012
  • 70-463 – Implementing a Data Warehouse with Microsoft SQL server 2012

They are all about 1 hour and 15 minutes long, so grab a coffee mug and a notepad og Onenote, and prepare yourself for your next exam.