Don’t run CHKDSK while SQL Server is running
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running.… Read More »Don’t run CHKDSK while SQL Server is running
How do you restore a SQL Server 2000 database in the year 2024?
A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to… Read More »How do you restore a SQL Server 2000 database in the year 2024?
What I actually do at Microsoft
I started working at Microsoft in January 2022. I enjoy it. I even wrote a stream-of-consciousness post about it last year. A significant part of… Read More »What I actually do at Microsoft
I can no longer recommend Liquid Web for hosting
EDIT: 2024-04-30 I have closed my hosting company, and this site now lives on a Hetzner server in Germany. Original post continues below. I’ve had… Read More »I can no longer recommend Liquid Web for hosting
Hello Microsoft Entra ID, good bye Azure Active Directory
A couple of months ago where I work, a major product started undergoing a rebrand. I don’t pretend to understand marketing folks, but a change… Read More »Hello Microsoft Entra ID, good bye Azure Active Directory
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to talk about which version of SQL Server you should be on,… Read More »You should be running on SQL Server 2022
I don’t blog anymore, but not because I work at Microsoft
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
Connecting to SQL Server Database Engine, simplified
One of the advantages of being on the Database Docs team at Microsoft is that I get to work with amazing people, which means we… Read More »Connecting to SQL Server Database Engine, simplified
On being a woman and a data professional
This is a list of links, in no particular order, that you should read in no particular order. But read all of the words at… Read More »On being a woman and a data professional
Patch your SQL Server instance today
On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR… Read More »Patch your SQL Server instance today
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions.… Read More »Deadline for Microsoft MVP contributions is 20 March 2023
You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta… Read More »You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Max server memory recommendations are just a suggestion
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
Data is not immutable
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the… Read More »Data is not immutable
Winding down
Normally I write these posts on a Friday evening. Sometimes it’s later than that, but always before Monday so that my editor can give it… Read More »Winding down