Why Backup SQL Server?

I'm going to start a new series on backing up SQL Server. This was inspired by @Kendra_Little in one of her Dear SQL DBA podcasts In this series I want to work through why we need backups, how to do backups, and the different types of backups that you could do and why you would... Continue Reading →

What is Your “Why”?

Andy Leonard (@AndyLeonard) has asked this month on T-SQL Tuesday "Why do you do what you do?" I have two answers to this question. On one hand I do what I do because it pays the bills. I have a full time job working for a company here in Australia and it pays the bills... Continue Reading →

Ubiquiti Amplifi Router

I have been using Linksys routers for years, since my first router, a WRT54G purchased off eBay. So when my most recent router started to die, it was time to look for a replacement and I naturally went to look at the new Linksys routers again. However, with more and more wireless devices in the house, and... Continue Reading →

Using OPTION (RECOMPILE)

This week, I was trying to improve the performance of a bit of SQL and noticed that it generated significantly different query plans depending on the parameters passed in. So I tried to work out how to make it run well for all scenarios.When SQL Server first runs a stored procedure, it works out the... Continue Reading →

Create a website or blog at WordPress.com

Up ↑