How much data can you lose?

If you manage data for a business, the biggest risk you should always consider is how much of this data am I going to lose if a disaster strikes? Your manager is always going to want to have 0 data loss, that everything saved is kept no matter how big the disaster. However, they are... Continue Reading →

Types of SQL Backups

SQL Server has 3 different types of built-in backups: Full, Differential and Log. When working out how you're going to backup your database, you need to understand what the 3 different types are intended for, so you can work out what you need to do. Full A full backup is the simplest type to understand... Continue Reading →

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 →

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 →

CDC breaks after patching

I recently patched some servers from SQL 2014 SP2 CU3 all the way up to CU10. The patching went fine, everything came back online and looked to be working perfectly. However, the next day I realised that the CDC Collection Job was not running. After much googling and trying to rebuild the collection job, I... Continue Reading →

Create a website or blog at WordPress.com

Up ↑