Another important art is choosing a good, unique primary key for every table. ... I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple.

SQL Server disaster recovery has two key metrics: recovery point objective (RPO) and recovery time objective (RTO). These metrics are essential components of the service level agreement (SLA).