Mark has worked extensively with SQL Server, primarily focused on performance optimization and internals. Besides SQL Server Mark is also proficient in the Microsoft .NET development stack with a decade of experience.
Fueled by his interest in the nitty-gritty details and feedback from an early presentation, Mark started the OrcaMDF open source project that aims to provide a completely standalone parser for SQL Server MDF files.
Mark is an active member of the Danish community, speaking avidly at local events & user groups and is recognized by Microsoft as a Microsoft Designated Information Provider. Furthermore he blogs actively at http://improve.dk.
Based on my experience in creating OrcaMDF, an open source MDF file parser, I'll go through the primary storage structures, how to parse pages, headers, internal base tables, b-tree structures as well as the supporting IAM, GAM, SGAM and PFS pages.
In this deep(!) dive session. I will walk you through the internal storage format of MDF files. I'll cover how SQL Server stores its own internal metadata, how it knows where to find your data, and how to read it once found.
|
As I write this I’m finishing the last details on a new website project I’m working on for a client. A couple of months ago I made the easy decision of going with Umbraco as the underlying CMS. I’ve had excellent experiences with Umbraco previously and the community is amazing. Umbraco was at a ...
|
|
Yesterday I presented at Community Day. As promised, you can download my slide deck here: Using Amazon S3 & CloudFront for Scalable and Secure Distribution.rar I also did a demo of OrcaMDF for the following Demo Day happening. You can find more on OrcaMDF here: Git repository Blog ...
|
|
Last Thursday I did a full-day presentation at Miracle Open World 2012 on the SQL Server storage engine and MDF file internals. As mentioned in the session, I usually don’t post my precon slidedeck and materials publicly. If you attended the session, please send me an email at mark@improve.dk and ...
|
|
As usual, I had a wonderful time at SQLBits X in London. Unfortunately I didn’t arrive until late Friday afternoon since I was flying in at the last minute from SQLConnections. I did however make it to the fabulous party and managed to get in bed early enough so I could be ready for my presentation ...
|
|
I presented my “Optimizing Storage and Performance Using Page and Row Compression” presentation today here at SQLConnections. Overall I think it went alright, even though I had to speed up a bit at the end due to lack of time – I really hope I’ll be able to get a 75 minute slot next time :) As ...
|