This tip was refreshed with status updates for some of the critical bugs discovered in MERGE over the years.

SQL Server will gladly tell you about missing indexes, but it may not give you the keys in the right order.

For this T-SQL Tuesday, I talk about my methods for metadata discovery in new versions of SQL Server.

GDPR is a big deal for a lot of us; in this tip I explain how you might want to deal with "forget me" requests.