Born SQL https://bornsql.ca/ A blog about the Microsoft Data Platform Thu, 12 Feb 2026 03:06:59 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://bornsql.ca/wp-content/uploads/2017/08/cropped-logo_square_new-150x150.png Born SQL https://bornsql.ca/ 32 32 50220720 Git forked https://bornsql.ca/blog/git-forked/ https://bornsql.ca/blog/git-forked/#respond Thu, 12 Feb 2026 03:05:32 +0000 https://bornsql.ca/blog/git-forked/ 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… Git forked

The post Git forked appeared first on Born SQL.

]]> https://bornsql.ca/blog/git-forked/feed/ 0 19658 More fun with Git: git restore https://bornsql.ca/blog/more-fun-with-git-git-restore/ https://bornsql.ca/blog/more-fun-with-git-git-restore/#respond Tue, 09 Dec 2025 06:33:14 +0000 https://bornsql.ca/?p=19655 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… More fun with Git: git restore

The post More fun with Git: git restore appeared first on Born SQL.

]]> https://bornsql.ca/blog/more-fun-with-git-git-restore/feed/ 0 19655 Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe https://bornsql.ca/blog/run-sql-server-2025-and-sql-server-management-studio-on-macos-tahoe/ https://bornsql.ca/blog/run-sql-server-2025-and-sql-server-management-studio-on-macos-tahoe/#respond Tue, 18 Nov 2025 15:00:47 +0000 https://bornsql.ca/?p=19643 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… Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe

The post Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe appeared first on Born SQL.

]]> https://bornsql.ca/blog/run-sql-server-2025-and-sql-server-management-studio-on-macos-tahoe/feed/ 0 19643 macOS Tahoe breaks SQL Server on Docker containers on Apple silicon https://bornsql.ca/blog/macos-tahoe-breaks-sql-server-on-docker-containers-on-apple-silicon/ https://bornsql.ca/blog/macos-tahoe-breaks-sql-server-on-docker-containers-on-apple-silicon/#respond Mon, 06 Oct 2025 18:26:57 +0000 https://bornsql.ca/?p=19635 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.… macOS Tahoe breaks SQL Server on Docker containers on Apple silicon

The post macOS Tahoe breaks SQL Server on Docker containers on Apple silicon appeared first on Born SQL.

]]> https://bornsql.ca/blog/macos-tahoe-breaks-sql-server-on-docker-containers-on-apple-silicon/feed/ 0 19635 Get required permissions for DMVs https://bornsql.ca/blog/get-required-permissions-for-dmvs/ https://bornsql.ca/blog/get-required-permissions-for-dmvs/#comments Sat, 23 Aug 2025 01:06:34 +0000 https://bornsql.ca/?p=19630 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… Get required permissions for DMVs

The post Get required permissions for DMVs appeared first on Born SQL.

]]> https://bornsql.ca/blog/get-required-permissions-for-dmvs/feed/ 1 19630 SQL Server Management Studio uses the Visual Studio installer https://bornsql.ca/blog/sql-server-management-studio-uses-the-visual-studio-installer/ https://bornsql.ca/blog/sql-server-management-studio-uses-the-visual-studio-installer/#comments Thu, 14 Aug 2025 16:09:17 +0000 https://bornsql.ca/blog/sql-server-management-studio-uses-the-visual-studio-installer/ 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.

]]> https://bornsql.ca/blog/sql-server-management-studio-uses-the-visual-studio-installer/feed/ 1 19628 What’s new in SQL Server 2025 CTP 2.0 https://bornsql.ca/blog/whats-new-in-sql-server-2025-ctp-2-0/ https://bornsql.ca/blog/whats-new-in-sql-server-2025-ctp-2-0/#comments Mon, 19 May 2025 16:00:48 +0000 https://bornsql.ca/?p=19603 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… What’s new in SQL Server 2025 CTP 2.0

The post What’s new in SQL Server 2025 CTP 2.0 appeared first on Born SQL.

]]> https://bornsql.ca/blog/whats-new-in-sql-server-2025-ctp-2-0/feed/ 3 19603 The hell of Git line endings and the (not so) simple fix https://bornsql.ca/blog/the-hell-of-git-line-endings-and-the-not-so-simple-fix/ https://bornsql.ca/blog/the-hell-of-git-line-endings-and-the-not-so-simple-fix/#respond Wed, 12 Feb 2025 00:00:32 +0000 https://bornsql.ca/?p=19591 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 hell of Git line endings and the (not so) simple fix

The post The hell of Git line endings and the (not so) simple fix appeared first on Born SQL.

]]> https://bornsql.ca/blog/the-hell-of-git-line-endings-and-the-not-so-simple-fix/feed/ 0 19591 Don’t run CHKDSK while SQL Server is running https://bornsql.ca/blog/dont-run-chkdsk-while-sql-server-is-running/ https://bornsql.ca/blog/dont-run-chkdsk-while-sql-server-is-running/#comments Fri, 09 Aug 2024 16:58:14 +0000 https://bornsql.ca/?p=19588 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… Don’t run CHKDSK while SQL Server is running

The post Don’t run CHKDSK while SQL Server is running appeared first on Born SQL.

]]> https://bornsql.ca/blog/dont-run-chkdsk-while-sql-server-is-running/feed/ 2 19588 How do you restore a SQL Server 2000 database in the year 2024? https://bornsql.ca/blog/how-do-you-restore-a-sql-server-2000-database-in-the-year-2024/ https://bornsql.ca/blog/how-do-you-restore-a-sql-server-2000-database-in-the-year-2024/#respond Thu, 20 Jun 2024 02:23:44 +0000 https://bornsql.ca/?p=19570 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… How do you restore a SQL Server 2000 database in the year 2024?

The post How do you restore a SQL Server 2000 database in the year 2024? appeared first on Born SQL.

]]> https://bornsql.ca/blog/how-do-you-restore-a-sql-server-2000-database-in-the-year-2024/feed/ 0 19570 What I actually do at Microsoft https://bornsql.ca/blog/what-i-actually-do-at-microsoft/ https://bornsql.ca/blog/what-i-actually-do-at-microsoft/#respond Mon, 10 Jun 2024 17:45:43 +0000 https://bornsql.ca/?p=19562 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… What I actually do at Microsoft

The post What I actually do at Microsoft appeared first on Born SQL.

]]> https://bornsql.ca/blog/what-i-actually-do-at-microsoft/feed/ 0 19562 I can no longer recommend Liquid Web for hosting https://bornsql.ca/blog/i-can-no-longer-recommend-liquid-web-for-hosting/ https://bornsql.ca/blog/i-can-no-longer-recommend-liquid-web-for-hosting/#respond Fri, 26 Jan 2024 21:19:26 +0000 https://bornsql.ca/?p=19546 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… I can no longer recommend Liquid Web for hosting

The post I can no longer recommend Liquid Web for hosting appeared first on Born SQL.

]]> https://bornsql.ca/blog/i-can-no-longer-recommend-liquid-web-for-hosting/feed/ 0 19546 Hello Microsoft Entra ID, good bye Azure Active Directory https://bornsql.ca/blog/hello-microsoft-entra-id-good-bye-azure-active-directory/ https://bornsql.ca/blog/hello-microsoft-entra-id-good-bye-azure-active-directory/#respond Tue, 19 Dec 2023 19:57:31 +0000 https://bornsql.ca/?p=19535 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… Hello Microsoft Entra ID, good bye Azure Active Directory

The post Hello Microsoft Entra ID, good bye Azure Active Directory appeared first on Born SQL.

]]> https://bornsql.ca/blog/hello-microsoft-entra-id-good-bye-azure-active-directory/feed/ 0 19535 You should be running on SQL Server 2022 https://bornsql.ca/blog/you-should-be-running-on-sql-server-2022/ https://bornsql.ca/blog/you-should-be-running-on-sql-server-2022/#respond Tue, 05 Dec 2023 21:49:35 +0000 https://bornsql.ca/?p=19531 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… You should be running on SQL Server 2022

The post You should be running on SQL Server 2022 appeared first on Born SQL.

]]> https://bornsql.ca/blog/you-should-be-running-on-sql-server-2022/feed/ 0 19531 I don’t blog anymore, but not because I work at Microsoft https://bornsql.ca/blog/i-dont-blog-anymore-but-not-because-i-work-at-microsoft/ https://bornsql.ca/blog/i-dont-blog-anymore-but-not-because-i-work-at-microsoft/#respond Fri, 08 Sep 2023 07:45:34 +0000 https://bornsql.ca/blog/i-dont-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, 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… I don’t blog anymore, but not because I work at Microsoft

The post I don’t blog anymore, but not because I work at Microsoft appeared first on Born SQL.

]]> https://bornsql.ca/blog/i-dont-blog-anymore-but-not-because-i-work-at-microsoft/feed/ 0 19524