Writing three books in 2011 grew from years of answering questions and writing every day. This personal account looks back at emails, research, blogging and workbooks at home.
SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow
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.