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...

During my 13-year career, I’ve been involved in some pretty obscure software issues. One particular nightmare that springs to mind involved SQL Server Reporting Services 2014 (SSRS), which had...

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...