Meziantou's blog

Deep dives and practical tips about .NET, C#, and developer tooling

  • Home
  • Books
  • Projects
  • Talks
  • Archives
  • About
  • Resume
  • Contact

Categories: SQL Server (24 posts)

2020

  • Using SQL Server HierarchyId with Entity Framework Core

2017

  • Quickly test SQL Server using Docker
  • 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
Photo of Gérald Barré

Gérald Barré

aka. meziantou

Microsoft Most Valuable Professional (MVP)

My Books

  • MSBuild In Depth
  • Roslyn In Depth
  • React from Zero

Recent posts

  • Runtime async benchmarks: .NET 10 vs .NET 11
  • .NET 11 runtime async: the runtime takes over await
  • The cost of async: a BenchmarkDotNet study on .NET 10
  • Prefer async/await over directly returning Task
  • Synchronization in async code: lock and SemaphoreSlim

Links

  • .NET resources
  • Online tools
Copyright © 2026 Gérald Barré - Use of this site constitutes acceptance of our Terms of use and Privacy policy.