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,… Don’t change your default SQL Server port for security reasons
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… The denial-of-service attack is coming from inside the house
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… Checking accessibility in your day-to-day work
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… Database Projects 101 in Azure Data Studio (Calgary Data User Group)
(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… Don’t optimize for ad hoc workloads as a best practice
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… Join me in Germany in June
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… A new chapter begins
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… SQL Server 2019 on Apple Silicon redux: it actually works
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… One year later: my look back on the PASS organization
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,… And that’s a wrap
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… On the nature of constant change
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… You can’t run SQL Server on Apple Silicon, and it sucks
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… Your next step in the cloud
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.… Be careful with table updates
This is one of those shameless plugs I’m allowed to do from time to time to promote my user group here in Calgary. Tonight, starting 5pm Mountain time, Bob Pusateri (blog | Twitter) will be… Calgary Data User Group: Big Data Clusters with Bob Pusateri