Techniques that a professional database developer should master

Are you already an experienced programmer and know your way around the Microsoft SQL Server development language? Still, there are always problems with query runtimes that you cannot explain to yourself. Data is not written to database tables fast enough and you are looking for ways to optimize ETL processes? These are all things that pose new challenges for a database developer daily. This workshop for database developers closes many of these gaps and uses practical examples to explain, analyze and solve the problems. – Parameter sniffing – Non SARGable queries – Sort spills – Implicit conversion – NOLOCK / TABLOCK – Temporary tables vs. Table variables – Recursive CTEs – partitioning – scalar functions This workshop is suitable for database developers who are already beyond the basics and want to sharpen the nuances. Ideally, you already have experience with execution plans and are very familiar with the SQL Server Management Studio.