Shop Talk: 2021-09-13

The Recording

The Panelists

  • Kevin Feasel
  • Mike Chrestensen
  • Tracy Boggiano

Notes: Questions and Topics

Open Sourcing the .NET 5 C# Language Extension

Our first topic of the night was a dive into Microsoft open sourcing the .NET 5 C# Language Extension for SQL Server. We spent a good amount of time comparing it to CLR and wondering what the future holds in that regard.

Maintaining Timestamps without Triggers

Next up, Mala couldn’t make it but she did suggest we cover this Daniel Hutmacher post. It’s a clever use of temporal tables, especially if you don’t have a crazy busy system. If you do start talking crazy busy (millions of rows updated per day, for example), I’d prefer an events architecture built around modifications getting their own records and summarizing results periodically. That way, you don’t run the risk of index fragmentation issues causing slow queries.

PASS Data Community Summit Pre-Cons

Our last major topic of the night was a discussion of PASS Data Community Summit and especially Tracy’s pre-con on Azure SQL fundamentals. If you haven’t already signed up for the Summit, the main event is free and pre-cons are quite well-priced at $200 apiece.

Leave a Reply

Your email address will not be published. Required fields are marked *