I wrote a stream-of-consciousness post a few months ago about what I do in my day job at Microsoft, working in the Database Docs team. Basically we spend most of our day in an obscure… The hell of Git line endings and the (not so) simple fix
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. This includes, but is not limited to: SQL Server PostgreSQL… Don’t run CHKDSK while SQL Server is running
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 restore to a supported version of SQL Server (preferably SQL… How do you restore a SQL Server 2000 database in the year 2024?
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 our job in the Database Docs team, is to resolve… What I actually do at Microsoft
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 a really disappointing experience with the Liquid Web sales team,… I can no longer recommend Liquid Web for hosting
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 this big needed to be well-coordinated. As of this writing,… Hello Microsoft Entra ID, good bye Azure Active Directory
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, now that we’re at the end of 2023. Which version… You should be running on SQL Server 2022
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, put through a CT scanner, and a couple of weeks… I don’t blog anymore, but not because I work at Microsoft
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 can respond quickly to customer issues. Recently, a Microsoft customer… Connecting to SQL Server Database Engine, simplified
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 the end of these links. This is just ten minutes’… On being a woman and a data professional
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 is an out-of-band update that usually includes bug fixes and/or… Patch your SQL Server instance today
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. For 2023, the deadline has been brought forward to 20… Deadline for Microsoft MVP contributions is 20 March 2023
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 support today for Apple’s Rosetta 2 x86 emulation layer, which… You can run a SQL Server Docker container on Apple M1 and M2 Silicon
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 Kehayias. The chart has lived at bornsql.ca/memory for a while. There’s… Max server memory recommendations are just a suggestion
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the hardiest data storage designed to last for a thousand years,… Data is not immutable