Join me for Optimizing Database Performance—SQL Best Practices, a Webcast on LinkedIn
We started the webcast series Optimizing Database Performance with a bang last month on LinkedIn on Feb 26 at 10:00 a.m., U.S. CT. Our next session in the series covers the important topic of SQL coding best practices.
A Gentle Introduction
Episode one featured the solid foundations needed for good database design. It covered building and maintaining an application using a relational database management system, such as Microsoft SQL Server. One of the things I always try to deliver in my sessions is a strong narrative. I use many analogies and animations to explain how relational databases process user requests without confusing you with complex jargon and obscure details.
During our 45-minute session, we'll review essential database behaviors which directly impact the success of SQL statements. This includes: SQL execution plans—your key to diagnosing and improving poorly performing SQL statements; interactions within a relational database—how the query optimizer acts differently for read-only operations (Ex. SELECT statements) and read-write operations (Ex. INSERT, UPDATE, DELETE, and MERGE statements).
Finally, we'll look at the most common performance pitfalls when writing SQL statements and suggest strategies to avoid them. We will cover anti-patterns—how computations and function calls, like the WHERE clause, can prevent a search argument from using a perfectly good index, how SELECT * can cause performance issues, and how wildcard usage has performance implications. We’ll also discuss using some key patterns and anti-patterns in stored procedures and user-defined functions.
I will always point you to deeper resources such as whitepapers, articles, and blogs detailing the various technical aspects I cover, so you can get the inside scoop if you want more. Sometimes it is much more.
Register and Share Today
So, please take a moment to register for the webcast. If you’ve enjoyed these sessions in the past, drop me a note @kekline or comment on our LinkedIn registration page that you want more database learning.
I’ll see you on Wednesday, March 26, 10 – 10:45 a.m. CT.
Bring your questions, tell a friend, and share the post.
Top Comments