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.
Writing Clear Error Messages in Procedures
Clear error messages in procedures identify the failed operation, useful keys, and next action without exposing sensitive data.
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.
SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT
How to convert text to integer with CAST and CONVERT, whether they fail on alpha-numeric values (yes), and how to pull only the numbers from a string.