Categories: Database (38 posts)

2025

• Detect missing migrations in Entity Framework Core
• Using Snapshot Testing to validate EF Core schema

2021

• Strongly-typed Ids using C# Source Generators

2020

• Using SQL Server HierarchyId with Entity Framework Core

2017

• Interpolated strings: advanced usages
• Quickly test SQL Server using Docker
• Testing EF Core in Memory using SQLite
• Entity Framework Core: History / Audit table
• Entity Framework Core: Specifying data type length and precision
• Entity Framework Core: View the model as text
• Entity Framework Core: Soft Delete using Query Filters
• Entity Framework Core: Generate tracking columns
• Entity Framework Core: Naming Convention
• Quickly insert millions of rows in SQL Server in .NET

2016

• SQL Server 2016 SP1 - Licensing changes
• What's new in SQL Server 2016: Always encrypted
• What's new in SQL Server 2016: Temporal Tables
• What's new in SQL Server 2016: Live Query Statistics
• What's new in SQL Server 2016: Stretch Database
• What's new in SQL Server 2016: Row-Level Security
• What's new in SQL Server 2016: Dynamic Data Masking
• Exploring the SQL Server Database Project in Visual Studio
• Deploying a SQL Server Database with Data-Tier Application (dacpac)
• Comparing execution plans with SQL Server
• What's new in SQL Server 2016: JSON

2015

• SQL Geography, Google Maps & Geolocalisation
• SQL Server - Change Data Capture (CDC)
• SQL - Export the contents of a table
• Recursive queries with SQL Server
• Identifying missing indexes with SQL Server
• SQL Server - Discovering the HierarchyId data type
• Find a guid in a SQL Server database

2014

• Run a SQL batch containing "GO" in C#
• Test the connection to a SQL Server database
• How to run a scheduled task

2012

• SQL injections

2011

• How to retrieve SQL generated from a LINQ to Entities query
• Backup your MySQL database from php