Robert Hartskeerl
Data Architect
Amsterdam, The Netherlands
Actions
Robert Hartskeerl has over two decades worth of experience developing and maintaining database solutions with SQL Server, .NET and Azure. Working for Microsoft Services has made him a true expert in troubleshooting, performance tuning, database security and high availability solutions. In 2018 he left Microsoft to focus more on building solutions. Today he has helped several customers move their workloads Azure.
Area of Expertise
Topics
Your first steps inside the storage engine
When you work with SQL Server you probably know a thing or two about indexes. The difference between clustered and non-clustered. May you have heard about b-tree structures and now a thing or two about pages and extents.
But do you really know what is inside SQL Server? How data is stored? And maybe more interesting, why data is stored this way. And how is this done with other systems like Oracle, Postgres and Mongo? And how are data types inside your application related to SQL data types.
In this session I will guide you through the world of pages and how data is stored. What is the difference between varchar and nvarchar? Or how are dates stored? And, how does this relate to collations or codepages. Your backend api might use json in UTF-8 format, yet SQL Server might use a completely different format. I will show you how this works and help you to get a little bit more understanding of the storage engine.
If you are interested in getting to know just a little bit more about how data is stored on disk this session is for you.
Help me start up my database
Have you ever been on call during weekends to find that your SQL Server won't start up after a service pack? Or came in the office in the morning and as soon as you stepped through people starting shouting at you because their application stopped working?
In this session I will walk you trough some real customer cases I worked on in the past 10 years. And specifically restore cases where the database or instance failed to come online. I will show you the error, the suspected issue according to the customer making the call and walk you through how to troubleshoot and find the actual issue.
After this session you will walk away with just that bit more knowledge to confidently restore your database or instance when needed.
This session is very demo heavy and depending on the available session length can have more or less demos. The recommended session length is 60-75 minutes. However, anything from 45-90 minutes is possible.
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