You are out doing your scheduled sweeps of the environment and you notice a huge I/O consumer is one of your update procedures. Your initial thought may be to panic because how can you test data that is changing? You have several methods to tuning queries that adjust data that allow data to revert between […]

The post Tuning Basics – Updating an Update appeared first on dbWonderKid.

How did we get here? There are many ways that a database can crash and need to recover. Maybe you find yourself here from something more severe like hardware failure, perhaps it was only a reboot and when things started to come back you see databases stuck in an “In Recovery” state. I personally have […]

The post Advanced Database Recovery appeared first on dbWonderKid.

In my SQL Server Recovery Models blog, I touched a bit on my experience with recovery using Tail Log Backup. … [...]

Great question!      Before I answer this right off, ask yourself these questions: “Do I want to lose access… [...]

Time is money!      Your boss keeps talking about RPO (Recovery Point Objective)  and RTO (Recovery Time Objective).  Do… [...]

Corruption.  We know it is everywhere.  It is surely a hot-button issue in the news.  If you haven’t given much… [...]