What is the difference between EXEC and EXECUTE? None. The real difference is EXEC vs EXEC(), and I show why EXEC belongs before every stored procedure call.
SQLAuthority News – Scrum: Agile Software Development for Project Management
What I learned as a project manager about Scrum, an Agile Software Development system: the Product Owner, ScrumMaster and Team roles, and how the process runs.
SQL SERVER – Frequency of SQL Server Reboot and Restart
How often should you do a SQL Server reboot? From my experience there is no need, though our network team reboots all our servers every 15 days.
Doing Remote DBA Work Well
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.