Scripts to Update Database Values Executing scripts to update incorrect values in a database should be done with care. If a script dynamically updates a value based on a calculation it is possible that each subsequent execution of the script… Read More ›
Database
Part I – What is Idempotence?
This is part 1 of a 4 part series related to the concept of idempotency as it relates to computer science and software engineering. Idempotence: a term used in mathematics and computer science to describe a function that can be executed… Read More ›
SQL Server Map Login to User
I often find myself restoring databases from backup so that I can move a database from one server to another. The problem is that the backup has users that have permissions associated with them, but those users don’t link to… Read More ›
Shrinking a Log File in SQL Server 2008
Starting in SQL 2008 the ability to backup with no truncate options were removed. This affects the ability to shrink a log file without actually performing a backup. There is some significant risk in truncating the log file without first… Read More ›