SQLBits 2020

When Anti-Patterns Become Best Practices

SQL Server has long had a series of development anti-practices like using scalar functions and table valued functions that are vastly improved in modern versions of the database engine. Learn what's fixed.

SQL Server has always had a number of anti-patterns that didn't make any sense to application developers. Why shouldn't I be able to use scalar function? Or why can't I put a large number of rows in a table variable? SQL Server 2019 and Azure SQL Database have eliminated a number of these anti-patterns. In this session you will learn about how these changes can improve your application performance, and change your application development patterns. You will also learn about potential gaps where your application may not benefit from the changes to the database engine.

Speaker

Joey D'Antoni's Sessions

When to Wave Off Landing Data in PaaS Services

You Can't Govern Data You Don't Understand

How Do I Reduce My Cloud Bill?

Stop Doing Stupid $%^--How Not to Secure Your Environment

Choosing the Right Data Store--An Overview of Azure Data Platform Choices

Automagic Tuning in SQL Server

Dealing with Bad Networks - The Availability Conundrum

Deep Inside Azure SQL High Availability

Understanding Azure Active Directory for Data Professionals

When Anti-Patterns Become Best Practices

Getting Started with Learning Azure

Azure Managed Instances—Your Bridge to the Cloud

Building a Data Delivery Solution in the Cloud

Graphs Are Everywhere - Graph DB Support in SQL vNext

Who Am I? Managing Identities in Azure