In this post, we will go step by step into several aspects of Change Data Capture, a feature that is available on the Azure SQL Managed Instance and Microsoft SQL Server. The focus will be on the ...

A while back I asked for a change when creating DDL for SQL Server objects to use CREATE OR ALTER. This may have changed but not what I was expecting. I'm currently using dBeaver Community Edition v25 ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...