Shaun Austin

We’re continuing to cover methods for speeding up your SQL Server database backup and restore processes. There’s one rule that must apply for all these techniques – code changes...

In our next blog post about speeding up your SQL Server database backup and restore processes, we’re going to focus on moving tables into their own filegroups. If you...

Are there ways of segmenting the data in SQL Server, so that you only backup and restore the data you care about? The simple answer; yes. We’re going to...

If you’ve stumbled on this blog, then the likelihood is that SQL Server performance is pretty critical to your business. Whether you’re chiefly responsible for your organisation’s IT strategy,...

“When storing an email address in a SQL Server table, is it more performant to store it as a hashed value rather than plain text?” This question was asked...

Last year, Microsoft announced that Transparent Data Encryption (TDE) would be part of SQL Server 2019 Standard edition. This was BIG news – TDE has been around since SQL...

Plan Cache bloat is generally bad – it wastes CPU, it wastes memory. Plan Cache bloat happens when SQL Server stores multiple query plans for seemingly identical queries….except they’re...

SQL Server … GDPR … one of these is my favourite thing to blog about … the other is GDPR. Fortunately, this blog isn’t about GDPR! It’s about SQL...

I’m British, and we’re used to waiting in line for things, but why is my SQL Server waiting? This is a question that comes up a lot, and is a lesson...