Pages and Extents are the building blocks of every SQL Server data file. A page is 8 KB, an extent is eight pages, and a row has to fit on a page. This post shows how to count the pages a table uses and what happens when a row is too wide.
SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan
An overloaded ERP system taught me a lot. Here are my tips for SQL query optimization by analyzing the query plan of the most resource consuming queries.
Database Roles: Give Permissions to Groups, Not People
Database roles let you grant permissions to a group once, then add and remove members as jobs change. This post covers the fixed roles and the risk of db_owner, shows how to create a custom role, and checks role membership and permissions with queries.
Standard Developer vs Enterprise Developer Edition in SQL Server 2025
Choose Standard Developer or Enterprise Developer in SQL Server 2025, inspect the edition, and test against production features.
Script Table As in SSMS: CREATE, INSERT and SELECT in One Click
Script Table As is the right-click menu in SSMS that writes CREATE, SELECT, INSERT, UPDATE and DELETE statements for a table. This post shows what each option writes, what the scripts leave out, and how to run them safely.
Query Options in SSMS: Settings That Change Your Results
Query Options are the per-window settings in SSMS that change how a query runs and how its results look. This post covers results to grid, text or file, the character limits that cut long values, the SET options that change answers, and why SSMS and your application can disagree.
Commenting Out Code: Testing Safely in SSMS
Commenting Out Code is the quickest way to switch off part of a script while you test the rest. This post covers the SSMS shortcuts, testing one WHERE filter at a time, the trap of GO inside a block comment, and a safety note to leave above a DELETE.