Restore to a point in time

This week I had to restore to a point in time for an entire instance. The instance had approx 25 databases on it, and all of them had to be replaced to get the information we needed. As this was on a SQL Availability Group, we are backing up the logs every 15 minutes....

read more

K. Fisher’s Homework – Create db

In December the topic of the month for #Tsql2sday was to talk about our learning goals for 2018. One of the goals I put forth was to get better at SQL development. As part of that goal, I also realized I have to get more familiar with Visual Studios. So to help with...

read more
Getting whipped by GetDate()

Getting whipped by GetDate()

I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using getdate. Pretty straight forward right? Well originally the job consisted of 6 different statements like so: delete from table1 where...

read more

Check for corruption

If you work, or have worked, in a shop with lots of SQL servers then you either have, or will, experience an issue with storage. Like for instance you're storage controllers go down, knocking down your SQL instances. As we all know, this is a good way to corrupt...

read more

Disable login and kill user SPIDs

Recently came across a situation where reporting logins were interfering with nightly jobs due to blocking. After a number of attempts of trying to resolve the blocking, it was decided that a stored procedure that disabled the login and killed the user sessions was...

read more
Garland MacNeill

Garland MacNeill

DBA

Garland is a husband, father, DBA, hiker, camper, motorcyclist, and just some guy living deep in the woods. 

Archives