Episode
Code Analyze your SQL scripts in Visual Studio and elsewhere | Data Exposed: MVP Edition
with Anna Hoffman, Erik Ejlskov Jensen
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 Jensen.
Chapters
Recommended resources
- Analyzing Database Code to Improve Code Quality | Microsoft Learn
- Transact-SQL Design Issues | Microsoft Learn
- Transact-SQL Naming Issues | Microsoft Learn
- Transact-SQL Performance Issues | Microsoft Learn
- How to: Code analyze your SQL Server T-SQL scripts in Visual Studio | ErikEJ's blog
- NuGet Gallery | Packages matching erikej.dacfx
Related episodes
- Data Exposed | Microsoft Learn
- To watch other MVP Edition episodes, see our Data Exposed MVP playlist on YouTube
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
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 Jensen.
Chapters
Recommended resources
- Analyzing Database Code to Improve Code Quality | Microsoft Learn
- Transact-SQL Design Issues | Microsoft Learn
- Transact-SQL Naming Issues | Microsoft Learn
- Transact-SQL Performance Issues | Microsoft Learn
- How to: Code analyze your SQL Server T-SQL scripts in Visual Studio | ErikEJ's blog
- NuGet Gallery | Packages matching erikej.dacfx
Related episodes
- Data Exposed | Microsoft Learn
- To watch other MVP Edition episodes, see our Data Exposed MVP playlist on YouTube
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
Have feedback? Submit an issue here.