Last year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip,… Read More »I don’t blog anymore, but not because I work at Microsoft
Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan… Read More »Max server memory recommendations are just a suggestion
This is my ongoing series of answering T-SQL Tuesday posts far too late to be of any use. Click here if you want to read… Read More »T-SQL Tuesday Retrospective #012: Why DBA skills are necessary
Microsoft announced updates today for all supported versions of SQL Server, for a privilege escalation vulnerability that leverages Extended Events. For security reasons no further details… Read More »Security update for all supported versions of SQL Server (CVE-2021-1636)
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a… Read More »Read the error message
Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little beefier. There were ten virtual machines on the SuperMicro server, nine… Read More »Managing virtual machine drives on ESXi
I was thinking about a comment I made to my intern last week. She has been studiously attending to all the different things I do… Read More »How to read documentation
As regular readers of this blog will know, I’m a big fan of AzCopy, especially now that it has a sync option to keep local… Read More »Using AzCopy with Batch Files and Task Scheduler
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I… Read More »Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
I have been selected to present a second session for the PASS Summit in November this year. I wrote a few weeks ago about the… Read More »The importance of backups
In 2016 I created the Max Server Memory Matrix as a guide for configuring the maximum amount of memory that should be assigned to SQL Server,… Read More »Better SQL Server memory defaults in 2019
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to… Read More »Better SQL Server CPU defaults in 2019
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. |￣￣￣￣￣￣￣||… Read More »What is a container anyway?
There was an interesting conversation on Twitter recently, between Grant Fritchey (blog | twitter), Kenneth Fisher (blog | twitter), Anthony E. Nocentino (blog | twitter),… Read More »Containers and data: you gotta keep ’em separated
Time for another short blog post, and this one combines two topics I am very passionate about: security, and SQL Server performance. Let’s start by… Read More »My IT department installed an antivirus with SQL Server