Plan rebuilding system databases with Setup when master has no usable backup, then restore logins, jobs, and configuration.
SQLAuthority News – 7th Anniversary of Blog – A Personal Note
The 7th anniversary of SQLAuthority in 2013 was a chance to remember how the blog began. Saving my own DBA solutions grew into a habit of learning and sharing.
Measuring Space Used by Tables per Filegroup in T-SQL
Measure tables per filegroup from allocation metadata, include LOB and overflow pages, and separate partition placement from growth history.
Big Data Upgraded: The 2013 Series Rewritten for Today
Big Data Upgraded is the reading path for 23 articles, most of them first written in 2013, now rewritten for today’s tools. Most new platforms now build on Spark, Parquet, open table formats and change data capture. Here is the whole set in reading order, with one line on each.
Batch vs Stream Processing: When Data Cannot Wait
Batch vs Stream Processing is a choice about how long an answer can wait. This post compares an hourly batch job with a 5-minute stream window on the same six orders, covers the cost of real time and shows how to choose.
Finding the Most Frequent Value per Group in T-SQL
Find the most frequent value in each group, choose a tie policy, and compare categorical modes with averages and numeric percentiles.
Keeping Your Own Script Library
A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.