Choose the best recovery model from your restore requirements, understand bulk-logged limits, and verify the backup chain and log reuse.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – How Many Line of Code Do You Have in Database?
After the first SQLSaturday in Sri Lanka, here is a question worth a script: how many lines of code do you have in your database? Here is a way to count them.
SQL SERVER – The Basics of the Execute Process Task – Notes from the Field #084
Andy Leonard explains the basics of the SSIS Execute Process Task, used to start a custom application or run an operating system command from a package.
Who Changed This Row? Auditing Data Changes
Auditing data changes requires choosing whether you need old values, new values, actor identity, or a change feed, then testing the cost.
SQL SERVER – Puzzle with Year Function
After my MONTH() contest, here is a puzzle with YEAR function: what do MONTH and YEAR return for the date 0001-1-1, and why? Take a guess first.
SQL SERVER – Know Your Backup Before Deleting Database
Dropping a database in a demo is fine, but on production be careful. Here is how to know your backup before deleting database, so you can undo mistakes.