Hosted by dotnet and featuring Erik Ejlskov Jensen, this On .NET Live episode demonstrates how to boost SQL Server development using modern .NET tools, NuGet packages, and static analysis.

Supercharge Your SQL Development with Modern .NET

Featuring: Erik Ejlskov Jensen, Katie Savage, David Pine
Host: dotnet

Overview

This On .NET Live session showcases how .NET can be used on any platform to elevate your SQL Server development. The talk covers enabling build validation, incorporating static code analysis, and utilizing other advanced development practices through .NET build SDKs, NuGet packages, and .NET global tools.

Agenda and Key Chapters

  • 00:00 Countdown
  • 03:15 Welcome to On .NET Live
  • 03:45 Introduction to Erik
  • 04:15 Overview of Today’s Stream
  • 06:30 Discussion of Common Challenges in SQL Development
  • 09:34 Development Process Insights
  • 11:06 Overview of Tooling
  • 11:42 Live Demo: Integrating .NET Tools in SQL Development
  • 50:15 Deep Dive Into sqlpackage Elements
  • 51:06 Exploration of Erik’s .NET Tools
  • 59:59 Call to Action
  • 01:01:47 Q&A Session
  • 01:04:02 Wrap-up

Demo Highlights

The session features a practical demonstration of integrating .NET tools within SQL development workflows. Key elements include:

  • Using .NET build SDKs for multi-platform compatibility
  • Incorporating NuGet packages for added functionality
  • Leveraging .NET global tools for streamlined development
  • Static code analysis to catch issues early
  • Build validation to ensure code quality

Tooling and Resources

  • sqlpackage elements: Discussion on how they fit into modern .NET workflows.
  • Erik’s Tools: Overview and demonstration of specific tools built by Erik to assist SQL Server developers using .NET.

Further Reading & Links

Q&A

A live Q&A session addresses viewer questions regarding .NET tooling in SQL development, setup, and best practices.

Connect

This session provides a comprehensive guide to modernizing SQL Server development through .NET, with expert discussions, practical demos, and actionable advice for developers interested in cross-platform and automated database development workflows.