The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.
Recovering a Deleted Agent Job From an msdb Backup
Someone deleted the wrong Agent job. Here is how to get it back from an msdb backup without touching the live msdb.
SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7
Are redundant indexes good or bad? This final wrap of my seven part series recaps every part and its demo, so start here if you missed any.
SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007
Want to know about a problem before your users do? Mike Walsh explains SQL Server alerts, why they matter for server health and how to use them.
Free Tools Worth Having on a SQL Server
Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.
Generating Unique, Hard-to-Guess Voucher Codes in T-SQL
Random-looking codes can still be guessed. Build 20 voucher codes from random bytes, check them, and make redemption single-use.
BASE64_ENCODE and BASE64_DECODE in SQL Server 2025
Use BASE64_ENCODE in SQL Server 2025, decode binary and text safely, compare URL-safe output, and replace older XML encoding expressions.