My year end brain teaser in two parts: find the hidden tiger in a picture, and explain why a disabled login’s user shows no red arrow.
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
A reader’s database backup got much smaller with no code change. The reason was the compressed backup setting at the server level. Here is the story.
SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012
Target Recovery Time is a new database option in SQL Server 2012. Set it above 0 and SQL Server uses indirect checkpoints to limit recovery time.
SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped
Error 15138: the database principal owns a schema in the database and cannot be dropped. Move the schema to another user first, then drop the user.
Counting Users, Roles and Orphans in Every Database
Audit counting users across databases, include roles and schema ownership, and distinguish orphaned SQL users from contained identities.
SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column
An interview riddle: create two columns but give a datatype only once, and copy data without UPDATE. A computed column solves it simply.
SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore
A quick script for point in time recovery: set up and back up a database, restore it to a point in time, then clean up. Three simple steps.