Code Analyze your SQL scripts in Visual Studio and elsewhere | Data Exposed: MVP Edition

Maybe you already take advantage of the C# code analyzers built into the .NET SDK, that help you improve code consistency, quality, security and avoid common mistakes and potential bugs. But did you know that it is also possible to run analyzer rules against your SQL Server T-SQL object definitions (DDL) and stored procedures (DML)? By storing all your T-SQL scripts under source control in a Visual Studio Database Project (.sqlproj) or in a MSBuild.SDK.Sqlproj project, you can take advantage of this little known feature. Learn more in this episode of Data Exposed, MVP Edition with Anna Hoffman and Erik Ejlskov.
0:00 Introduction
2:38 Demo
✔️ Resources:
Analyzing Database Code to Improve Code Quality | Microsoft Learn: learn.microsoft.com/previous-...)
Transact-SQL Design Issues | Microsoft Learn: learn.microsoft.com/previous-...)
Transact-SQL Naming Issues | Microsoft Learn: learn.microsoft.com/previous-...)
Transact-SQL Performance Issues | Microsoft Learn:learn.microsoft.com/previous-...)
How to: Code analyze your SQL Server T-SQL scripts in Visual Studio | ErikEJ's blog: erikej.github.io/dacfx/codean...
NuGet Gallery | Packages matching erikej.dacfx: www.nuget.org/packages?q=erik...
About Erik Ejlskov Jensen:
Erik Ejlskov is a Developer Technologies MVP (former Data Platform) and a Principal Consultant for Delegate A/S, where he helps customers create cloud solutions. He maintains a number of opensource libraries and tools on GitHub that help developers to be productive with .NET and the Azure Data Platform, including the popular "EF Core Power Tools" and "SQLite Toolbox" Visual Studio extensions
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: aka.ms/mvpprogram
📌 Let's connect:
Twitter: Anna Hoffman, / analyticanna
Twitter: AzureSQL, aka.ms/azuresqltw
🔴 To watch other MVP Edition episodes, see our playlist: aka.ms/dataexposedmvps
To check out even more Data Exposed episodes, see our playlist: aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #SQLServer

[@devopsbyrajaas]

This is a useful tool for us