Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.
Doing Remote DBA Work Well
Remote DBA work succeeds with controlled access, current runbooks, agreed change windows, and communication that makes every action visible.
Refactoring a Long Stored Procedure Into Readable Steps
Learn refactoring a long stored procedure with output baselines, named temp tables, dead-code removal, and two-way EXCEPT checks before release.
The SQL Basics Almost Everybody Skips
Revisit SQL basics that change query results: NULL logic, logical processing order, grouped filters, and the difference between two common counts.
The Dynamic Management Views Worth Knowing by Heart
Use dynamic management views to inspect active requests, waits, cached queries, index activity, and file space without guessing at server health.
Orphaned Users After a Restore, and How to Fix Them
Find orphaned users after a SQL Server restore, compare user and login SIDs, and repair the intended mapping with ALTER USER.







