Most database administrators don’t have enough time in the day to review every database put into product by their employers. And that’s big probable because the average database design put into product, whether built in-house or bough, are not high quality. But what if we could automate the review of our database for quality?

In this session we will teach you how to conduct a database design review that yields improved storage behavior, consistent table designs, good data types choices, best practices for keys and constraints, and strong indexing. The design review is scripted and does not require that the developers explain their code to you. Instead, you can run a set of scripts on a database that is actively testing workloads to see if any anti-patterns are in play. We will also show examples of anti-patterns that are the direct result of poor database design choices.

Join us to learn this tips and techniques that improve not only your personal skillset, but also have the potential to vastly improve your SQL Server and Azure SQL database performance.