A short T-SQL script that finds where your SQL Server Data File folder is on disk, using master.sys.master_files. Handy when you forget where the files live.
Storage Settings That Matter for SQL Server
Storage settings That Matter for SQL Server include latency, file placement, allocation unit size, and file growth; learn what to verify.
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
A Microsoft white paper on data compression in SQL Server 2008: strategy, capacity planning, best practices, and the trade-off of I/O savings for CPU.
Storing Files in the Database or on Disk
Storing files in the database requires tradeoffs in transactions, backup size, and access; compare varbinary, FILESTREAM, FileTable, and paths.
Finding Databases Nobody Uses
Finding databases nobody uses requires index activity, connection samples, job searches, and owner evidence before an offline trial.
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.
SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.