RETAINDAYS sets backup expiration for overwrite checks, without deleting the file. I keep SQL expiration separate from Windows file cleanup.
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to create primary key without ANY index? SQL Server builds a clustered or nonclustered index for every primary key, so here is the answer.
Reading a Benchmark Somebody Else Published
Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.
SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)
This shortest code puzzle asks for 1000000000 without writing that literal or using arithmetic operators. The earlier zero puzzle brought roughly 700 valid answers.
How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142
SQL Server logins follow Windows password rules by default. If a login has it turned off, here is a simple script to Enforce Password Policy again.
SQL SERVER – How to Enable Backup Compression On by Default
Tired of typing WITH COMPRESSION on every backup? Here is how to Enable Backup Compression on by default for the whole SQL Server instance.