Balmukund Lakhani turns his popular SQL Bangalore UG session into a guest post: the story of the -m startup parameter and a lesser known way to use it.
Rebuilding One Partition Online Instead of the Whole Index
A big partitioned table does not need a full index rebuild every night. Here is how to rebuild one partition safely.
Enforcing Object Naming Rules With a DDL Trigger
Enforce procedure and index names with a DDL trigger, inspect EVENTDATA, audit rejected attempts, and list existing violations.
SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage
Six years after my first post, a follow up on QUOTED_IDENTIFIER ON/OFF with a quick example of double quotes in identifiers and a real world question.
Building a Portfolio as a Data Professional
A data professional portfolio should show a few complete projects, clear write-ups, and runnable code that explains decisions and tradeoffs.
SQL SERVER – SQL in Sixty Seconds – Need Your Opinion
Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.
SQL SERVER – Script to Update a Specific Column in Entire Database
A reader added a ModifiedDate column to every table and left it NULL. Here is a script to update a specific column in the entire database at once.
The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice
Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.
Connecting to SQL Server From Home Without Exposing Port 1433
Keep port 1433 off the public internet by checking external reachability and using VPN, a jump host, Bastion, and trusted encryption.
TABLESAMPLE Samples Pages, Not Rows: Sampling a Large Table Right
Compare TABLESAMPLE page sampling with NEWID sorting and CHECKSUM filters by row count, reads, spread, and repeatability.










