Use STRING_AGG for generating backup commands with copy-only backups, checksums, safe database names, and dated files for careful review.
Choosing Where to Put Data and Log Files
Choosing where data and log files live means checking storage behavior, capacity, install defaults, and a tested move procedure.
Checking Which Accounts the SQL Server Services Run As
Inventory SQL Server services and their accounts, compare virtual and managed identities, and verify permissions after a change.
SQLAuthority News – Thank You to Awarding Author SQL MVP
Thank you for all the wishes on my SQL MVP award. It belongs to every reader here. Send me your ideas and I will publish them with your name on this blog.
SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP
I am very glad to share that Microsoft has given me the Most Valuable Professional Award for SQL Server. Thank you to MVP Lead Abhishek and all my readers.
SQL SERVER – Difference Between DBMS and RDBMS
What is the difference between DBMS and RDBMS? An RDBMS adds tables with enforced relationships, plus the constraints and security a plain DBMS lacks.
Reading SQL Server Release Notes Before You Patch
Reading SQL Server Release Notes before patching helps you find known issues, fixes, behavior changes, and workload risks.