Remote DBA work succeeds with controlled access, current runbooks, agreed change windows, and communication that makes every action visible.
SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan
Actual Execution Plan or Estimated Execution Plan? I always use the actual plan because it is accurate. Shortcuts: CTRL+M for actual, CTRL+L for estimated.
SQL SERVER – What is SQL? How to pronounce SQL?
What is SQL and how do you pronounce SQL? It stands for Structured Query Language, and it is said as S.Q.L. (ess-cue-ell), not sequel.
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
Notes from my database architecture meeting in New York and New Jersey: backup routines, index optimization and the maintenance tasks we discussed.
Why SQL Server Has Cumulative Updates, Not Service Packs
Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.
Index Maintenance on Modern Storage
Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQLAuthority News – Birthday of SQL Authority Author
Today is the birthday of the SQL Authority Author, and my thought of the day is a simple one that I truly believe: family is everything.