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.
What Breaks When You Upgrade, and How to Find It First
Prepare for a SQL Server upgrade by checking deprecated features, compatibility, collation, plans, and application behavior before moving.