Presenting a precon at SQLBits
Join Mark S. Rasmussen for a full day preconference training day session at SQLBits 9 in Liverpool. Through the day I'll present the internals of the SQL Server storage engine and MDF file format.
Copying a SQL Server database file that’s in use using Volume Shadow Copy
Learn how to copy an online SQL Server data file that is in use, using the AlphaVSS Volume Shadow Copy (VSS) functionality in C#.
Getting bit by datetime rounding or why 23:59:59.999 > '23:59:59.999'
Why won't SQL Server store the datetime values you insert? Learn & understand why SQL Server will round any values of .998 or .999 to either .997 or .000 precision.
Avoiding regressions in OrcaMDF by system testing
Learn how OrcaMDF utilizes system testing to avoid regressions between commits.
Anatomy of a forwarded record – the back pointer
Learn how a forwarded record in a heap stores a back pointer that refers to the original record from where it's forwarded.
Anatomy of a forwarded record – the forwarding stub
Learn the internals of how a record gets forwarded in a heap. Specifically we'll look at the forwarding stub that is left behind, pointing at the forwarded record.
Using Fiddler to automatically download streamed MP3s
Eric Lawrence’s Fiddler has many uses. I use it every day for debugging our client/server interaction, caching behavior, etc. What many don’t realize is that Fiddler is also an excellent platform for scripting, enabling you to modify requests and responses as they go out and come back. I made a quick script to automatically download streamed MP3 files as they were played, naming them automatically from the ID3 information contained in them. Before we get started, head on over and download the FiddlerScript Editor. Parsing ID3 tags As I’m lazy, and most likely you are too, we’ll...