List Foreign Keys referencing tables in SQL Server

How do I list foreign keys in a table in SQL? Read more →

Does AWS RDS SQL Server support Dynamic Management Views ?

Using DMVs on AWS RDS SQL Server Read more →

What is horizontal partitioning in SQL Server?

What is horizontal partitioning in SQL Server? Read more →

Reasons for Transaction Log Backup Chain breaking

There are different reasons for the SQL Server transaction log chain breaking .... Read more →

Hashicorp Vault curl for VBA

I need to connect to Hashicorp Vault via MS Access & VBA. With the equivalent of curl Read more →

Column-level encryption vs Always encrypted

Cell level encryption , Column level encryption and Always Encrypted - which one to use ? and under what circumstances? v Read more →

The simple guide to column-level encryption

SQL Server column level encryption example - although easy to setup requires some planning & management of master keys to allow movement and recoverability Read more →