A blog about the Microsoft Data Platform
Forgive me for the title. Mentally I m 12. When I started my current day job, I certainly didn t expect to write this many blog posts about Git. I don t fancy myself an expert by any means. Today I entered a new realm. Here s what I know about Git forks: Git is a fully distributed source The post Git forked appeared first on Born SQL .
The setup My day job involves babysitting a lot of Git repositories hosted on GitHub. The vast majority of the commits, merges, and squashes I run on a daily basis involve short-lived branches, and I rebase and squash them all the time. It s cool. It s even cooler when you can run git reflog to undo The post More fun with Git: git restore appeared first on Born SQL .
Short version (Edit 2025-11-26: If you still want to use containers, Anthony Nocentino has the answer for you here: https://www.nocentino.com/posts/2025-11-26-sql-server-2025-docker-desktop-avx-issue/) You want to get this running as fast as possible. Do these four steps, and then check the compatibility section later in this post. Step 1: Install Parallels Desktop That annual license fee is worth…
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer with SQL Server 2025 RC 1 running in a Docker container. I know it was Tahoe, because it worked the day before I upgraded, and then it didn t work the next day. I m not alone, according to the mssql-docker GitHub repository. The post macOS Tahoe breaks SQL Server on Docker containers on Apple silicon appeared first on…
Part of my job at work is to update Transact-SQL reference content. System dynamic management views (DMVs) have permissions that are managed in the SQL Server Database Engine source code, so it s a little tricky to figure out the required permissions for a specific DMV. This blog post provides a stored procedure that uses sys.fn_builtin_permissions The post Get required permissions for DMVs…
Yes, SSMS 21 uses the Visual Studio installer. No, you don’t need to download it every time. No, you don’t need a Visual Studio license to use it. The post SQL Server Management Studio uses the Visual Studio installer appeared first on Born SQL .
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0) was announced, I was a few months in at the SQL Docs team, and had very little to do with that release. Three years later, the team is slightly larger (we re called Data Docs now), and I was much more involved The post What s new in SQL Server 2025 CTP 2.0 appeared first on Born SQL .
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 distributed version control system (DVCS) by the name of Git. Written over a weekend by the creator of Linux himself, The post The hell of Git line endings and the (not so) simple fix appeared first on Born SQL .
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 MySQL MariaDB SQLite Oracle DB2 This also includes development and test environments. If you have any of these database systems The post Don t run CHKDSK while SQL Server is running appeared…
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 Server 2022). How do I do that? If this was my problem to solve, I would: Install SQL Server 2008 The post How do you restore a SQL Server 2000 database in the year 2024? appeared first on Born…
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 customer feedback issues about documentation. It doesn t quite consume half of my time every month, but it might. Feedback Recently The post What I actually do at Microsoft appeared first on Born SQL .
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, regarding the web server that hosts this blog post you re reading right now. My disappointment is compounded by the fact The post I can no longer recommend Liquid Web for hosting appeared…
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, Azure Active Directory (Azure AD for short, and never AAD) is now known as Microsoft Entra ID. You can find out more The post Hello Microsoft Entra ID, good bye Azure Active Directory appeared…
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 should I be on? You should be running your production environment on SQL Server 2022 with the latest cumulative update The post You should be running on SQL Server 2022 appeared first on Born SQL .
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 later, poked and prodded from both ends while administered fentanyl. I’m in my mid-40s, and my father died when he The post I don’t blog anymore, but not because I work at Microsoft appeared first on Born SQL .