padlock and chain

Security update for all supported versions of SQL Server (CVE-2021-1636)

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 have been provided, but you can expect more information in the near future, now that this update is public. From the knowledge base article: Data can be sent over a
-> Continue reading Security update for all supported versions of SQL Server (CVE-2021-1636)

A Windows error message

Read the error message

This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had to walk away from to restore my mental health. I learned a great many things from my boss (and yes, we are still friends). I learned
-> Continue reading Read the error message

A blue desktop vice

Managing virtual machine drives on ESXi

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 which were allocated 127 GB of thin-provisioned storage, and one VM with 256 GB of thin-provisioned storage. Thin provisioning — as the name implies — lets the guest operating system
-> Continue reading Managing virtual machine drives on ESXi

Using AzCopy with Batch Files and Task Scheduler

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 data synchronized with blob storage. In a recent release of the tool, Microsoft introduced a new switch to ensure that old files are only flushed from the destination when using
-> Continue reading Using AzCopy with Batch Files and Task Scheduler

Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store

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 might be wrong about the beans), there is a good chance that you will find yourself using it. Not only can ADR dramatically improve recovery time with database restores, but
-> Continue reading Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store

PASS logo

The importance of backups

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 Linux Learning Path and being a part of that, so I was certainly not expecting this. My second topic is about backing up, testing, and restoring SQL Server backups if
-> Continue reading The importance of backups

Better SQL Server memory defaults in 2019

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, using an algorithm developed by Jonathan Kehayias. SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has
-> Continue reading Better SQL Server memory defaults in 2019

Better SQL Server CPU 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 SQL Server Setup, on the Windows version. On the Database Engine Configuration screen are two new tabs, called MaxDOP and Memory. These are both new configuration options for SQL Server
-> Continue reading Better SQL Server CPU defaults in 2019

What is a container anyway?

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. | ̄ ̄ ̄ ̄ ̄ ̄ ̄|| CONTAINERS || ARE NOT | | VIRTUAL || MACHINES || _________| (__/) || (•ㅅ•) || /   づ — Ian Coldwater 📦💥 (@IanColdwater) June 9, 2019 I felt like this
-> Continue reading What is a container anyway?