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 will teach you how to conduct a Transact-SQL code review that avoids a variety of very common anti-patterns that are frequently used by junior developers who don’t know much about SQL Server. We will also share a collection of scripted checks to run against your SQL Server / Azure SQL database to reveal issues lurking within your application’s stored procedures, user-defined functions, and triggers. The design review is scripted and does not require that the developers explain their code to you. A portion of the scripted checks are best when run against a database at rest. But other scripts within the library are best run in an active database to see if the workloads exposes any anti-patterns are in flight.
Join us to learn theses tips and techniques that improve not only your personal skillset and that of the teams you support, but also have the potential to 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.