Security and compliance
Ensure data security and compliance with data masking, monitoring, and change traceability
Posts by
Louis Davidson
I am a SQL Server professional with over 30 years of experience in data modeling, SQL Server coding and internals, and ETL. I’ve been part of the SQL Server community for many years, as a speaker and writer, and have an equally long-standing enthusiasm for Dollywood and DisneyWorld, as a self-confessed roller coaster addict.
SQL Prompt AI Versus Smart Quotes
Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform
Reusing Query Results in SSMS
Sharing SQL Code Snippets with Coworkers, The World and Yourself
SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies
Using SQL Prompt Code Snippets for Repetitive Tasks
Finding Correlated Rows Using EXISTS or COUNT
EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates. Read more