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.
SQL SERVER – Four Different Ways to Find Recovery Model for Database
Four ways to find the recovery model of a database: database properties, Object Explorer Details, sys.databases and DATABASEPROPERTYEX.
SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY
What is the difference between NORECOVERY and RECOVERY when restoring a database, and what is the right restore sequence? A plain explanation of both.
SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage
Store images as a file pointer, inside the database, or with FILESTREAM storage in SQL Server 2008? I compare the pros and cons of each method.
SQL SERVER – Standby Servers and Types of Standby Servers
What are standby servers and why do you need them? A plain look at the hot, warm and cold types and how SQL Server supports each one.
SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
Can you restore or attach database files if the .mdf or an .ndf file is missing? In one word, no. Here is why every data file is needed.
SQL SERVER – Mirrored Backup and Restore and Split File Backup
From a real project: conventional backup and restore, split file backup when a disk runs short of space, mirror file backup, and the FORMAT clause.