Two ways to get a median, one tiny demo, and the traps in NULLs, even counts and empty tables. Then measure on your own server.
SQL SERVER – Implementing IF … THEN in SQL SERVER with CASE Statements
Moving IF … ELSE logic from .NET code into a stored procedure? Here is how to rewrite it using CASE statements, with examples for SQL Server 2008 and 2012.
MYSQL – Detecting Current Version of MySQL Server Installation
How do you find the current version of MySQL Server installed on your machine? Run one simple SHOW VARIABLES command from the command prompt or MySQL Workbench.
Rebuilding System Databases With Setup When master Is Lost
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.










