Securing linked servers requires explicit login mappings, limited RPC settings, remote privilege checks, and dependency ownership.
How to Ask a SQL Question That Actually Gets Answered
Want a fast answer? Here’s how to ask a SQL question with a small script, the exact error and the expected result, so helpers can answer.
SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor
Change the color of status bar in SSMS 2008 for each server, so a query meant for development never runs on production by mistake. Step by step with images.
SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction
WAITFOR makes a T-SQL batch pause for a set time, or until a clock time, before the next statement runs. I show both uses with small examples.
SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers
In this blog post, I will discuss various topics which are related to various DBAs and Developers discussed in the recent market.
Is a Certification Worth It, and What to Study Instead
Decide whether a SQL Server certification supports your next role, then build practical study projects around recovery, security, and tuning.
SQL Server Express Limits: What the 10 GB Cap Really Means
Check SQL Server Express limits by version, separate data files from logs, and identify the memory, CPU, and scheduling limits that affect you.







