SQL Server, What's In My Buffer Cache?

• by Gavin Draper

• Gavin Draper's SQL Server Blog

When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...

2019-03-06 (first published: 2019-02-19)

2,120 reads

SQL Server Script To Check Your Backup RPO Status

• by Gavin Draper

• Gavin Draper's SQL Server Blog

I recently wanted a script to tell me that for every database on a given server
What levels of backups I...

2019-02-28 (first published: 2019-02-13)

2,745 reads

How To Check How Far Behind Your SQL Server Log Shipping Secondary Is

• by Gavin Draper

• Gavin Draper's SQL Server Blog

Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...

2019-02-21 (first published: 2019-01-31)

2,672 reads

Odd Behavior With LOB/Overflow Data

• by Gavin Draper

• Gavin Draper's SQL Server Blog

In writing some sample demos around LOB and Row-Overflow data I found a couple of oddities in the way reads...

2019-02-20

138 reads

How to Encrypt and Restore Your SQL Server Database Backups

• by Gavin Draper

• Gavin Draper's SQL Server Blog

We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...

2019-02-19 (first published: 2019-01-28)

3,156 reads

SQL Server, What Waits Happened In The Last X Seconds

• by Gavin Draper

• Gavin Draper's SQL Server Blog

There are plenty of scripts out there that can show you the waits that are occurring on your server, however,...

2019-02-18

140 reads

Why You Shouldn't Use SELECT * In Production Systems (EVER!)

• by Gavin Draper

• Gavin Draper's SQL Server Blog

OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...

2019-02-11 (first published: 2019-01-23)

5,865 reads

Backing Up and Restoring Your On-Premise Databases To and From the Cloud

• by Gavin Draper

• Gavin Draper's SQL Server Blog

I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now,...

2019-01-30

170 reads

Dodging Deadlocks With Indexes

• by Gavin Draper

• Gavin Draper's SQL Server Blog

A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index....

2019-01-23 (first published: 2019-01-14)

2,747 reads

Leveling Up Your TSQL

• by Gavin Draper

• Gavin Draper's SQL Server Blog

I thought I’d use this post to round up some of my other posts into a list of often overlooked/unknown...

2019-01-22

228 reads