by David | Feb 22, 2024 | Best Practices, Cloud, Performance, SQL Server, Storage
IT and data professionals, I implore you – know thy platform. All of it. Not just the layer your job is tasked with. Modern public cloud (or any infrastructure for that matter) platforms means there’s more to it than just one layer. Here’s an example from just...
by David | Jan 21, 2024 | Best Practices, Cloud, Performance, SQL Server
You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance. Public cloud providers charge organizations for everything they deploy, and while a few items in the...
by David | Oct 18, 2023 | Best Practices, SQL Server
SQL Server query developers, listen up! Query execution time is not everything you should be worried about. You need to examine the parse and compilation time for each of your queries too. When you run a query, the SQL Server engine executes it. You get a runtime in...
by David | Sep 18, 2023 | Best Practices, Business, SQL Server
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective (RPO) and Recovery Time Objective (RTO), and to have these defined not in...
by David | Jul 7, 2023 | Best Practices, Business, Cloud, Performance, Professional Development, SQL Server, Storage, Tech Video, Technology, Virtualization
My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason why you can’t join me in this adventure to learn more about how to performance and...
by David | May 18, 2022 | Best Practices, SQL Server, Technology, Virtualization
We’ve been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not isolated to) the tempdb database. TLDR: We’ve now got a VMware KB...
