Thursday 30 June 2022
This event has finished.
Started 18:15 PM
Finished 19:45 PM
Organized by SQLPort
Venue: Unknown venue
About this eventRealiza-se no dia 30 de Junho de 2022, o 133º Encontro da comunidade SQLPort, que tem como objectivo a partilha de experiências e conhecimento entre os profissionais e entusiastas de Microsoft Data Platform em Portugal.
O evento sera realizado online.
18:30 “Finding and Fixing T-SQL Anti-Patterns with ScriptDOM” - Mala Mahadevan (DBA/DB Engineer at ChannelAdvisor, co-lead #DPWIT and #TriPASSUG)
19:30 Q & A
Quality code is free of things we call ‘anti-patterns’ - nolock hints, using SELECT \*, queries without table aliases and so on.
We may also need to enforce certains standards: naming conventions, ending statements with semicolons, indenting code the right way etc. 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? But suppose we had an automated utility that could do this for us? Even better, if we could integrate it in 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 us for this highly interactive and 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.
Mala Mahadevan is a senior database professional with over 20 years of experience working with data, primarily in SQL Server and related technologies. She has been volunteering with SQL Server community for the past 15 years and is also a recipient of the PASSion award for being an outstanding volunteer. She is a featured blogger on sqlservercentral.com and also blogs frequently at curiousaboutdata.com. She is active on twitter as @sqlmal.
This page last updated Sunday 19 June 2022 at 23:06.
Problems? Report an error or inappropriate listing here.
Information displayed here is provided in good faith but we are not responsible for the content of any listing. Sometimes events can be cancelled or changed at short notice. Please check with the venue or organizer before you travel!