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 – Importance of Database Schemas in SQL Server
Why database schemas matter since SQL Server 2005: a schema is now a container separate from the user who created the objects inside it.
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.
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Error 3724 stops you from dropping a database once used for replication. My simple fix: back up an empty database with the same name and force a restore.
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.