@BornSQL

Official Twitter account for Born SQL, which is a blog by a Canadian called Randolph West.

 Calgary, Alberta
bornsql.ca
Joined October 2015
  • Tweets271
  • Following25
  • Followers170
99Media
What three things do you want from a database monitoring tool?
1
82
Comments are disabled on bornsql.ca permanently. Existing comments will continue to show.
1
If I did it right, we’ve moved to a new host, changed the theme, and the website should load more quickly than before. bornsql.ca
Max server memory recommendations are just a suggestion bornsql.ca/blog/max-server-m…

Max server memory recommendations are just a suggestion - Born SQL

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 https://bornsql.ca/s/mem...

bornsql.ca
1
Data is not immutable bornsql.ca/blog/data-is-not-…

Data is not immutable - Born SQL

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, etched...

bornsql.ca
1
Winding down bornsql.ca/blog/winding-down…

Winding down - Born SQL

Normally I write these posts on a Friday evening. Sometimes it’s later than that, but always before Monday so that my editor can give it some attention before I publish. On Friday though, I spent...

bornsql.ca
1
2
Just one more thing, an essay on troubleshooting bornsql.ca/blog/just-one-mor…

Just one more thing, an essay on troubleshooting - Born SQL

Over the weekend I watched — for the first time in my life — an episode of the long-running ABC and NBC police show Columbo, starring Peter Falk. I originally knew him from the film The Princess...

bornsql.ca
Choco upgrade, y’all bornsql.ca/blog/choco-upgrad…

Choco upgrade, y'all - Born SQL

Chocolatey is a package manager for Windows, like the built-in package managers on Linux, and third-party ones on macOS like Homebrew and MacPorts. The idea is this: when you’re setting up a machine,...

bornsql.ca
1
If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES? bornsql.ca/blog/if-i-cant-us…

If I can't use PWDENCRYPT, how am I supposed to use HASHBYTES? - Born SQL

For this week, here is a short post about reinventing the wheel. An interesting conversation happened on Twitter where Dave Dustin asked: “Does anybody have an example of using HASHBYTES() to replace...

bornsql.ca
On bias bornsql.ca/blog/on-bias/

On bias - Born SQL

Last week saw the second month of my employment at Microsoft. I admit that I’m enjoying my job, and I can’t deny that the reduced amount of time I’ve spent on social media has helped. Last week also...

bornsql.ca
4
1
3
A new book is on its way bornsql.ca/blog/a-new-book-i…

A new book is on its way - Born SQL

I am thrilled to announce that Microsoft Press (Pearson) has agreed to let us do another Inside Out book this year. This news is so fresh I haven’t even gotten the advance yet! The working title is...

bornsql.ca
1
1
You can’t secure your network with spite bornsql.ca/blog/you-cant-sec…

You can't secure your network with spite - Born SQL

I wrote a post a couple weeks ago about not changing port 1433 for security reasons. I received this comment, which is not visible on that page because it warrants a lengthy response. I have redacted...

bornsql.ca
How do I merge a small part of a Git repo into another repo? bornsql.ca/blog/how-do-i-mer…

How do I merge a small part of a Git repo into another repo? - Born SQL

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 (< 2GB) which I’ll call...

bornsql.ca
2
2
Today’s deleted sarcastic comment was that I didn’t reply to someone on how to run the SQL Server 2019 service as root on a Docker container. That’s because, “annoyed”, you shouldn’t do it. I’m not going to help you make your environment less secure. Especially in 2022.
1
more replies
I was able to find this information on Microsoft’s Docs (“Run the non-root container as the root user”). Do people not know how to use a search engine, and expect all this information to be provided to them without lifting a proverbial finger? It takes longer to comment!
1
There’s a bunch of good reasons why you shouldn’t do stuff as the root user or Windows administrator. Learn those reasons.
Got a comment saying my most recent blog post was click bait and a waste of time. I deleted it because it’s my website. If you don’t like it, write your own.
2
8
I will not engage people in bad faith.
Don’t change your default SQL Server port for security reasons bornsql.ca/blog/dont-change-…

Don't change your default SQL Server port for security reasons - Born SQL

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 Configura...

bornsql.ca
1
1
2
Load more