Effective permissions are what a user can do after every GRANT, DENY and REVOKE has been added together. This post follows one user through eight statements, with a role, a direct DENY and a direct GRANT, and checks the result after each step with HAS_PERMS_BY_NAME. It then shows how to take away one ability from a user who holds CONTROL. Every result comes from SQL Server 2025.
SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani
Object names in SQL Server can be up to 128 characters, but local temp tables stop at 116. Guest author Balmukund Lakhani explains this limit for Temp Objects.
Designing a Simple ETL Framework
An ETL framework in SQL Server needs a small set of configuration, run logs, restart checkpoints, and alerts that operators can trust.
SQL SERVER – Microsoft Certification – SQL Server 2012
Microsoft Certification changed for SQL Server 2012. A simple map of the new MCSA and MCSE path and of exams 70-461, 70-462 and 70-463.
XML Data Type Methods in SQL Server: query, value, exist, modify and nodes
XML data type methods are the five functions you call on an xml column or variable: query(), value(), exist(), modify() and nodes(). Each gives back a different kind of answer: xml, a typed value, 1 or 0, a changed document or rows. This post runs all five on one small table of seeds, shows two common errors, and asks SQL Server what each method returns. Every result comes from SQL Server 2025.
SQL Error Actions: What SQL Server Does After an Error
SQL error actions decide what runs after an error in SQL Server. This post shows statement termination, scope abortion, batch termination, connection termination and XACT_ABORT, with real results from three small stored procedures. It also covers what each reaction does to an open transaction and how TRY…CATCH changes the outcome.
Hierarchical Query Using a Recursive CTE: Levels, Order and Loops
A hierarchical query using a recursive CTE walks a table that points at itself, one level at a time. This post builds the levels of a small staff table with Lvl + 1, sorts the tree so each person sits under their boss, walks upward from one person and stops a loop in the data. Every result comes from SQL Server 2025.