Use naming conventions for readable SQL Server tables, columns, keys and indexes, then find exceptions and plan safe renames with sp_rename.
SQL SERVER – Identifying Guest User using Policy Based Management
Can a policy catch a guest user left enabled in user databases? Here is a quick tutorial on identifying guest user access with Policy Based Management.
Moving Data Out of SQL Server in Open Formats
Move SQL Server data into open formats such as CSV, JSON, and Parquet while preserving types, NULLs, encoding, and readable files.
SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database
I advise disabling the guest user in user databases, but it should stay enabled in the MSDB Database. Here is why, and how to enable it again if it was turned off.
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’
Error 15434: could not drop login ‘test’ because the user is logged in. A reader ran my demo on production; here is my Force Removing User fix, no restart needed.
Translating Oracle CONNECT BY Queries to Recursive CTEs
Translate CONNECT BY into recursive CTEs with root selection, depth, paths, sibling ordering, cycle checks, and a recursion limit.
SQL SERVER – Solution Part 2 – A Quick Puzzle on SQL JOIN and NULL – SQL Brain Teaser
Part 2 of the solution to my puzzle on SQL Join and NULL. Readers still email me answers every day, so here are more of the good ones they sent.