What we're about
Upcoming events (2)
We have all heard the stories. Horror story after horror story being regaled from database administrators all over the world of waiting for hours or sometimes days for a rollback operation to complete. DBA's hoping beyond hope that the rollback finishes soon before someone else gets the notion to reboot the server.
Thankfully, with the release of SQL Server 2019, comes the one feature that will save us all from hearing about future horror stories. Accelerated Database Recovery or also known as "ADR". This great enhancement in SQL Server, which changes the way that we view transaction rollback, will undoubtedly prove invaluable in your arsenals of tricks!
Buckle up. We're gonna go deep into the guts of ADR in this session.
You are -
• A total nerd to who likes to know how things work
• Are not afraid to dive deeper into the internals of SQL Server
• Are not afraid of tools like profiler, extended events, or debugger tools
You will learn -
• How to enable it
• What the components are
• How ADR works under the hood
• When you wouldn't want to implement it
Don't be the protagonist in a rollback horror story! Learn ADR and save the day! After all, the time you save might be your own!
John Morehouse is currently a Principal Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, 2016 Idera Ace, Friend of Red Gate, Sentry One PAC member & Community Ambassador. John has a passion around speaking, teaching technical topics and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at conferences whenever possible. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, http://sqlrus.com.
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.
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.