Finding databases nobody uses requires index activity, connection samples, job searches, and owner evidence before an offline trial.
SQL SERVER – Difference between SQL Server Express and MySQL
SQL Server Express and MySQL are both free relational databases for smaller or embedded apps, yet they differ in important ways. Here is how they compare.
SQL SERVER – Find Gaps in The Sequence
How do you find gaps in a Sequence of numbers? A reader asked, and two experts, Brian and Tejas, replied with good scripts. Here are both solutions.
PERCENTILE_DISC: Return an Observed Percentile Value
PERCENTILE_DISC selects from the supplied observations. Preserve duplicates and distinguish an observed threshold from an interpolated value.
Data Mining: A Simple Introduction and a SQL Basket Example
Market-basket analysis turns purchases into measurable product relationships. Deduplicate products within each order, calculate support, confidence and lift in T-SQL, and interpret the counts before drawing conclusions from a small sample.
SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction
Backup and Restore lessons from my consulting work: conventional backups, split file backups, mirrored backups and the FORMAT clause, each with an example.
DATEADD Nanoseconds: Round to datetime2 Ticks
DATEADD nanoseconds do not provide single-nanosecond storage. Test rounding thresholds with an explicit datetime2(7) input.