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 | Feb 23, 2023 | Best Practices
I’m thrilled to announce that the “Architecting Microsoft SQL Server on VMware vSphere” 8.0 best practices guide has been released! I’m pleased to have been able to contribute to this document. This document covers some very positive and...
by David | Nov 25, 2022 | Best Practices, Performance, SQL Server, Storage
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises and in the cloud, has some interesting trade-offs. The biggest is write latency from the hyperconverged storage platform underneath the database. We find that write...
by David | Jun 25, 2022 | Announcements, Best Practices, Cloud, Performance, SQL Server, Storage, Virtualization
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL Server virtual machine performance tuning tips with our friends at Sanity Solutions on July 21st at 10am Mountain time. Virtualized SQL Servers are the norm these days, but...