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...
by David | Apr 26, 2022 | Best Practices, Performance
Have you ever wondered why Windows Server doesn’t show disk performance metrics in Task Manager, but your Windows 10/11 OS does? It’s a really silly difference. Let’s fix that. Open PowerShell or the command prompt with administrative permissions....
by David | Jul 29, 2021 | Best Practices, Cloud, Performance, SQL Server, Storage, Technology
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel 9 where I discuss setting up Linux storage appropriate for on-demand disk expansion for your production SQL Server on Linux workloads. I’ve been working with...
by David | Jul 8, 2021 | Best Practices, Performance, SQL Server, Storage, Technology
Do you have quite large MDF files on your database? By large, I mean hundreds of gigabytes (or larger). Have you ever noticed that your SQL Server disk stall metrics for these data files are much higher than the storage latency metrics exhibited on the underlying...
by David | Jun 15, 2021 | Announcements, Best Practices, Cloud, Events, Performance, Professional Development, SQL Server, Technology, User Groups
(Things come out of nowhere with only moments of warning, if at all!) Disasters big and small happen, and as data professionals, you should be prepared for the worst! I’m thrilled to announce that we’re launching the Microsoft Data Platform Continuity...
by David | May 10, 2021 | SQL Server, Technology
This past week I had a great Client ask an even greater question, and it got me thinking. The question is straightforward (albeit nerdy, which I love). “We’ve enabled RCSI, and we still get serializable connections from our apps. What gives?” Well,...