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!