An increasing number of businesses are moving towards utilising Microsoft cloud technologies to make their data highly available to other applications, processes and people. If you are one such...
The advantages of hosting software systems in the cloud have been widely discussed, with an increasing number of businesses choosing to migrate to cloud hosts such as Amazon AWS, Microsoft Azure, or Google Cloud. The cloud offers flexibility, reliability, and scalability, allowing you to effectively support your users/customers around the clock. However,...
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...
© Koderly 2021. All rights reserved.
The Koderly® name and logo is a registered trademark of Koderly Limited.
Koderly Limited is registered in England & Wales. Company Reg. No. 4070605 / VAT No. 757 9537 70
© Koderly 2021. All rights reserved.
The Koderly® name and logo is a registered trademark of Koderly Limited.
Koderly Limited is registered in England & Wales. Company Reg. No. 4070605 / VAT No. 757 9537 70