Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
Planning for Data Growth
Planning for data growth uses backup and file trends, workload events, storage lead times, and a dated request for more capacity.
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.
Trace Flags Worth Knowing About
Review trace flags worth knowing about in current SQL Server, distinguish session, global, and startup scope, and verify each flag’s support.
Checking IDENTITY Columns Before They Run Out of Numbers
Check IDENTITY columns for their current value, type limit and remaining range, including descending increments, before inserts fail.
Reviewing a Table Change Script Before It Locks Production
Review a table change script for schema locks, data rewrites, supported online options, backfill batches, and a tested rollback.
Contained Databases and Contained Users
Understand contained users in SQL Server databases, how they travel with a database, and the security trade-offs of partial containment.