Whether you are trying to find the purpose of a SQL Server you just became responsible for, or access has been accidentally dropped, or you need to administer a vendor installed SQL instance, or a host of other reasons, from time to time you will need to get emergency sysadmin access into a SQL Server. This post talks about your options for regaining access to that rogue server.
Read More →An Introduction to Log Shipping
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post covers the basics of SQL Server log shipping.
Read More →Are Backups Valid DR?
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. In this section we talk about the basic process of backing up databases and whether this is enough to meet your requirements.
Read More →Are You High? Can You Recover?
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post deals with the concepts of RTO and RPO.
Read More →A Happy Birthday to My Daughters
I decided to do something a little different for my girls fifth birthday. So I made them this computer game. Happy Birthday Samantha and Kaylee!
Read More →How to Use TSQL to Get Database Backup History
Quick TSQL scripts for finding the dates each database on your server was backed up, or finding the backup chain of a single database.
Read More →How to Use TSQL to Monitor Index Fragmentation
The script I use by default to monitor fragmentation excludes a bunch of indexes I probably don’t care about.
Read More →