fbpx

Disaster Recovery or High Availability

Tuning Update Statement with SQL Server

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.

[...]

Do I Need to Backup System Databases?

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

What is RPO/RTO?

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

Deep Dive into Bulk Logged Recovery Model

    Full disclosure time: Bulk Logged Recovery Model is  quite confusing to me.  And as it seems, to many… [...]

Demystifying System Databases

Recently I have heard a lot of people discussing SQL Server System Databases.  The topic of system databases seems to… [...]

SQL Server Recovery Models

In my last post (A Beginner's Guide to SQL Server Backups) we discussed the basics of SQL Server Backups.  As… [...]