Securables and principals are the two nouns of SQL Server security, and a permission joins them. This post gives a user named Tom access to a Finance table, then uses GRANT, DENY and REVOKE and reads the permission list after each step. It ends with one grant on a whole schema. Every result comes from SQL Server 2025.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties
Part 3 of my FileTables series for SQL Server 2012: queries to tell files from folders and find root paths, path locators and relative paths.
Finding the Worst Query in Five Minutes With Query Store
Find the worst query with Query Store totals, compare CPU and duration over the last day, inspect plans, and choose the first tuning target.
JSON_PATH_EXISTS and Typed ISJSON in SQL Server 2022
Validate payloads with JSON_PATH_EXISTS and typed ISJSON in SQL Server 2022, distinguish null from missing, and enforce a clear contract.
SQL SERVER Cheatsheet – Released for SQL Server 2012 Edition
The SQL SERVER Cheatsheet is updated for SQL Server 2012, now with SSMS shortcuts, Columnstore Index, and the datetime, ranking and analytic functions.
Building an Org Chart Query With hierarchyid
Build an org chart with hierarchyid, query descendants and levels, move a team safely, and compare it with recursive queries.
Storing Durations and Summing Time Past 24 Hours
Use whole seconds for summing time beyond 24 hours, aggregate safely, format unlimited hours, and convert legacy time values.