I like finding ways of making things easier , recently I started toying with Snippets within SQL Server Management Studio to find that I could reduce the amount of repetitive typing that i regularly do for things such as calling store procedures. I will show you what I did, there may be other ways and... Continue Reading →
The dreaded SQL server error 3013! ‘RESTORE LOG is terminating abnormally’ the bane of my life, until recently
The dreaded '3013 - RESTORE LOG is terminating abnormally' message! the bane of my life, until recently... So I find myself looking through our automated backup restore job history, and i see a bunch of the '3013' errors and I am wondering what on earth is going wrong here, this could be anything! The error... Continue Reading →
DBs in the Cloud Part 1 – Setting up and Connecting to a SQL Azure Database
Unless you've been living under a rock for the last few years I'm sure that you've all heard of that mystical world that is Azure and some of us may even know people who have visited that land but how do we get there ourselves? Well don't worry my fair database folk, there's no need... Continue Reading →