A weekly routine for SQL Server Administration checks recovery, failures, capacity, integrity, security, and pending changes in a practical order.
Giving an Application Account Only What It Needs
Apply least privilege SQL Server access with separate runtime and deployment roles, narrow permissions, and tests of allowed and denied actions.
What Is the Transaction Log and Why Does It Keep Growing?
The transaction log records every change before it reaches the data file. Why it grows, what log_reuse_wait_desc is telling you, how the recovery model decides everything, and the one fair reason to shrink it.
Introduction to JOINs in SQL Server: INNER, OUTER and CROSS JOIN
This introduction to JOINs shows INNER, LEFT, RIGHT, FULL and CROSS JOIN with Venn diagrams and real results from two small tables. It also covers finding rows with no match and three traps that catch people. I first wrote it for members of the Gandhinagar SQL Server User Group.
Reading the SQL Server Support Lifecycle
Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.
What Is a Database Backup? Full, Differential, Log
A database backup comes in three kinds and they work together. Measured sizes for full, differential and log, why the recovery model decides everything, and the restore order that cannot be improvised.
SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones
Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.







