Mikael Wedham

How do you use the system view [sys].[dm_os_wait_stats] to find if you have a locking issue and where it is? This session will show you how to identify different types of locks, and understand the cause of them. You will see some scenarios where we force the common query locks LCK_M_S and LCK_M_X to get extensive waits. The ISOLATION LEVELS - READ UNCOMMITTED |READ COMMITTED | REPEATABLE READ | SNAPSHOT | SERIALIZABLE will be explained and targeted to what they solve and what issues they introduce. Finally the locking scenarios will be matched to the InMemory storage solution in SQL Server and you will see the benefits and drawbacks of that solution as well.

Have you heard the rumor that SQL Server on-premises is dead? It is in the Cloud everything should happen. I have heard it too. But evidence points to the contrary. SQL Server on-premises installations are very much alive and kicking. In this session I will give real-life scenarios where a cloud based database simply wouldn't have been accepted. Contents incluse, but are not limited to: Usability of SQL Server on-premises, Tips and tricks on improving your database coding skills in general and finally real life usage of on-premises databases

How do the wait stats show you that you have a locking issue? This session will show you how to detect and view blocking and lock waits, and understand the cause of it.

In this demo-based session we will see how the different rights, owners , credentials, and types of steps will make jobs behave in some different environments. It will give you a view of when to use different settings and also how to change the behaviour so it matches what you want to accomplish.