What you'll learn from Mala Mahadevan's session | PASS Data Community Summit

Показать описание

Quality code is free of things we call 'anti-patterns' - nolock hints, using SELECT * where not needed, queries without table aliases, and so on. We may also need to enforce certain standards: naming conventions, ending statements with semicolons, indenting code the right way, using TRY...CATCH, BEGIN...END blocks, and so on. Furthermore, we may need to apply specific configurations on database objects, such as to create tables on certain filegroups or use specific settings for indexes. All of this may be easy with a small database and a small volume of code to handle, but what happens when we need to deal with a large volume of code? What if we inherit something full of these anti-patterns, and we just don't have time to go through all of it manually and fix it? Suppose we had an automated utility that could do this for us? Even better, if we could integrate it into our Azure DevOps pipelines? ScriptDOM is a lesser-known free tool from SQL Server DacFx which has the ability to help with finding programmatic and stylistic errors (a.k.a linting) in T-SQL code. It can even fix some of these errors! In this session, we will learn about what it is, how we can harness its power to read code and tell us what it finds, and actually fix some of those anti-patterns. Join me for this demo-packed session for great insights on how to improve the quality of your code. Basic knowledge of T-SQL and Powershell is recommended to get the most out of this session.

PASS Data Community Summit is the go-to conference for data professionals to connect, share, and learn with peers and industry leaders.