SQL Server Internals - Who need SQL Server when we have Notepad?

In this session, we will explore how SQL Server actually stores the values of the data behind the scene. We will read SQL Server data file directly using simple binary editor (notepad++), and we will explore the structure of several data types.

We will focus on exploring how UTF-8 is supported in SQL Server 2019 behind the scene, and we will explore how SQL Server stores other types of data (according to the time), starting with DateTime2 which is probably one of the most common complex data type structure and moving to other data types.

Note! During the demo, we are going to show and use several undocumented tools from different versions of SQL Server. This is advance topic!

Ronen Ariely

Senior consultant and architect, data platform and application development.

Tel Aviv, Israel


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top