How do I merge a small part of a Git repo into another repo?
At my new day job, one of the things we want to do is migrate a portion of a really large Git repository (over 20GB) which I’ll call LargeRepo, into a much smaller repository (<…
Randolph
Don’t change your default SQL Server port for security reasons
Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security reasons. In SQL Server Configuration Manager,…
The denial-of-service attack is coming from inside the house
A short post this week. While I was helping some friends recently, we experienced a curious thing where as soon as an application was started up, it was immediately followed by a denial-of-service attack that…
Checking accessibility in your day-to-day work
Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create slides with wonderful typeface choices, clear…
Database Projects 101 in Azure Data Studio (Calgary Data User Group)
On Wednesday February 23rd, 2022, the Calgary Data User Group will be hosting our first user group session of the year, featuring Warwick Rudd. The topic is an introduction to Database Projects in Azure Data…
Don’t optimize for ad hoc workloads as a best practice
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held belief systems that don’t take new…
Join me in Germany in June
I have been selected to speak at the DataGrillen conference later this year. I will be presenting my session How Does SQL Server Store That Data Type?, which I debuted during last year’s EightKB online conference. This…
A new chapter begins
In 2012 when I originally founded Born SQL, I never imagined I would find myself a five-time recipient of the Microsoft Data Platform MVP award, let alone be offered a job to work for Microsoft alongside…
SQL Server 2019 on Apple Silicon redux: it actually works
Edited on 12 January 2023: You can run a SQL Server Docker container on Apple M1 and M2 Silicon Last month I wrote a blog post suggesting that it was not possible to get SQL Server…
One year later: my look back on the PASS organization
My good friend and talented singer Rob Volk reminded me recently that I had promised to write about my involvement with PASS at the end of its life, and I remember saying out of respect that…
And that’s a wrap
It’s the final week of 2021, a year that was both twice as long and half the length of 2020. If you can, please make sure you are vaccinated and boosted. It doesn’t prevent infection,…
On the nature of constant change
Recently my spouse and I travelled to South Africa (yes, I know there’s a pandemic on) to deal with a gloomy family matter that required in-person interaction. Being an adult means dealing with things that…
You can’t run SQL Server on Apple Silicon, and it sucks
Edited on 12 January 2023: You can run a SQL Server Docker container on Apple M1 and M2 Silicon Prior to 2017, the only way to get SQL Server running on a Mac was through a…
Your next step in the cloud
Over the last nine months I’ve presented (virtually) eleven times on a variety of topics relating to SQL Server and the Microsoft Data Platform. Long-time readers will know I have some experience as a high…
Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need to audit changes to a database.…