SQL Server – Transparent Data Encryption is Standard!

SQL Server Database Services Icon

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 Server 2008, but until now, it’s been for those lucky guys with Enterprise-deep pockets.   You can read about TDE here in one of my earlier blogs (which […]

SQL Server – Plan Cache Bloat

SQL Server Database Services Icon

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 not identical. Let’s look at an example. Before we begin, let’s ditch the plan cache as this will help highlight the impact of our code. DON’T […]