Changing the name of a SQL Mail Profile
T-SQL
Ensure your SQL Server Audit isn’t changed without a notification being raised
Showing how the DELETE CASCADE clause works and why you might not want to be tempted by it
Safeguard your rollback by storing the changes to data as they happen, not as a seperate step.
Even the most experienced can learn the ‘basics’. Updating data via a CTE – I’ve learned something new.
Duplicating an AG to another environment, for migration purposes.
Introduction Ownership chaining is one process that SQL Server uses to allow stored procedures access to tables where the user might not have permission. It has issues with stored procedures that have dynamic sql – EXECUTE AS is one solution.
Whilst reading up on SQL Server 2016 JSON functionality I have seen many examples of extracting data from a JSON array. However, I wanted to work out how to extract data from an array within an array – for example, an array of customer data where each customer has an array of order details.
Background For a long time, web developers have been able to store session information. SQL Server has CONTEXT_INFO, which is a very poor implementation of a session variable. However, with SQL Server 2016 there is now a far more flexible SESSION_CONTEXT feature available.
Whilst reading an article on Quora I saw mention of TABLESAMPLE. I had never heard of it and upon investigation it piqued my interest.
Notes on SQL 