Set up a dedicated development database from approved schema scripts and clean seed data, with repeatable rebuilds and drift checks.
Extracting the Folder and File Name From a Full Path in T-SQL
Split a path at the last backslash and handle the odd inputs. Bare names, empty values, trailing spaces and NULL all behave.
Interview Question of the Week #028 – Few SQL Best Practices
Apply SQL best practices through ten reasoned rules for data meaning, predicates, parameters, indexes, ordering, and workload measurement.
Pre-Flight Checks at the Top of a Script With THROW
Learn pre-flight checks with practical SQL Server examples, clear checks, and the limits you need before changing application data.
SQL SERVER – 3 Common Mistakes of Agile Development – Notes from the Field #074
Agile builds software in small, time boxed steps. In Notes from the Field #074, Stuart Ainsworth shares stories about 3 common mistakes of Agile Development.
Reading a Workload Capture Without a Tool
Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.
Database Maintenance Checklist: Daily, Weekly and Monthly
A database maintenance checklist keeps the dull checks from slipping. This post lists what to check daily, weekly and monthly in SQL Server, with one small read-only query for backups, errors, free space, CHECKDB, statistics, growth, logins and patch level.