Workshop description
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.
This workshop is most hands on with prepared labs for the participants. All demos and hands on will be handled wit a BIG database (17 GB) and not with only a few records.
Length of the workshop
Full day (8 hours)
Key takeaways
You will learn to identify common development problems and how to avoid them
You will benefit from better development styles and better performance results for basic development practices to speed up your application(s)
Form of the workshop
Practice (exercises for attendees)
What attendees need to prepare?
SQL Server >= 2016 SP1 Standard Edition
SQL Server Management Studio
Demo database ERPDemo (link)
https://www.db-berater.de/downloads/ERP_DEMO_2012.BAK
Level
300