How to Conduct a Database Design Review


Length: 1 hour

Modern database administrators have many responsibilities, including perhaps their most important responsibility of performance tuning. Performance tuning takes many forms. It might include tuning server settings, improving database designs, or even extensively tuning queries and query code. This becomes even more important when database workloads moved to the cloud because poor performance increases consumption of resources like CPU, memory, and IOPS.

In this session, we’ll 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 the developers to explain their code to you. Instead, you can run a set of scripts on a database that’s 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 to improve not only your personal skillset, but also potentially vastly improve your SQL Server and Azure SQL database performance.

Prerequisites: Basic proficiency with core SQL statements, like CREATE, ALTER, DROP, GRANT, SELECT, INSERT, UPDATE, and DELETE


Interested in additional SentryOne webinars? Check our webinar library.

Watch Now

Kevin Kline

Kevin Kline

Head Geek

Kline is a noted database expert and software industry veteran. At previous companies, his product designs won multiple "Best of" and "Readers' Choice" awards.

Kline was a founding board member and former president of the Professional Association for SQL Server (PASS), is an avid blogger and database columnist, author of the best-selling book, SQL in a Nutshell, and co-author of SQL Server 2012 Management and Administration, Professional SQL Server 2008 Database Design and Optimization, and Database Benchmarking: Practical Methods for Oracle & SQL Server. He is a frequent webinar host and speaker at various industry conferences and user groups and has traveled the world as part of his multi-continent roadshows.

A Microsoft SQL Server MVP since 2003, Kline is passionate about improving the quality of life for Microsoft database professionals and their customers. As a SolarWinds Head Geek, he focuses on helping customers with troubleshooting and adopting best practices for optimal database performance monitoring, on-premises and in the cloud.

Thomas LaRock

Thomas LaRock

Head Geek

LaRock has over 20 years of IT experience holding roles such as programmer, developer, analyst, and database administrator. He is a Microsoft Certified Master, VMware vExpert, and a Microsoft Data Platform MVP.

LaRock has spent much of his career focused on data and database administration, which led to his selection as a Technical Evangelist for Confio Software in 2010, where his research and experience helped create the initial versions of the software now known as SolarWinds® Database Performance Analyzer (DPA).

LaRock has served on the board of directors for the Professional Association for SQL Server (PASS), and is an avid blogger, author, and technical reviewer for numerous books about SQL Server management. He now focuses on working with customers to help resolve problems and answer questions regarding database performance tuning and virtualization. He’s made it his mission to give IT and data professionals longer weekends and bacon.

Companies with the highest demands for database performance choose SentryOne