Founded by Data Platform MVP, Randolph West, Born SQL provides specialist SQL Server services, upgrades, on-site support and disaster recovery services in western Canada. Allow us to identify what’s hurting your database environment, implement changes with little to no downtime and keep your server running smoothly.
Data management. Simplified.
Find the SQL Server solution for your needs
Discover exactly what’s hampering your SQL Server database environment and how to fix it.
Update your SQL Server to the latest version, or any older version currently supported by Microsoft.
Recover data that may have been lost on databases from SQL Server 2005 and upwards.
Improve your SQL Server performance in two days or your get 50% of your money back.
Get the on-site or remote Database Administration solution for all your SQL Server needs.
Find out where Born SQL will be sharing knowledge or book our expertise for your event.
Sign up to our blog and get e-mail notifications for new entries
SQL Server knowledge. Shared.
Read our latest blog entries
This is the third post in the series about system-versioned ledger tables, a new feature introduced in Azure SQL Database. You can read Part 1 and Part 2 if you haven’t already. Every choice we make is a trade-off. New features have limitations, and ledger tables are no exception. Some of these limitations are perfectly
-> Continue reading System-versioned ledger tables: things you can’t do
I’ve had the privilege of presenting all over the world about temporal tables in SQL Server including the United Kingdom, Canada, and the United States. The theme of the session has always been Back to the Future, which is the greatest time travel movie ever, but I haven’t changed the talk much since I debuted
-> Continue reading Join me at SQL Trail 2021 to hear the next thing about Temporal Tables
In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates whether your database has been tampered with. Very simply, if the cryptographic hash does not match what is in the off-site digest, your database has been
-> Continue reading System-versioned ledger tables: the next step
Choosing the right typeface for your presentation (or for that matter anything you create that contains words) is fraught. In a previous post I wrote about the difference between serif and sans-serif. I mentioned font families, line spacing, and kerning. I also discussed why it’s important for a font to differentiate between characters that look
-> Continue reading Accessibility in font choice
As long-time readers of this blog know, I’m a big fan of temporal tables, also known as system-versioned temporal tables. Until recently, temporal tables were synonymous with system-versioned tables, but all that changed a short while ago with the introduction — in Azure SQL Database — of system-versioned ledger tables. This new series of posts
-> Continue reading Introducing system-versioned ledger tables
Right off the top here, I must note that the term “dead man’s switch” is archaic, so for the rest of this post I’ll refer to it as “operator presence control,” or OPC. The concept of an OPC is quite old and usually relates to machinery. Let’s use the example of a train. If the
-> Continue reading Why you need a Dead Man’s Switch
I have previously written about accessibility in video captions, presentation slides, and disabilities, and I thought I should expand on the latter topic as it relates to typefaces, or what we call “fonts.” To be precise, a typeface is a type design, and a font is a subset of a typeface. Unless you work in
-> Continue reading Let’s talk about typefaces
During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10 million rows, which isn’t that remarkable; another table in the same database has almost 500 million rows. The remarkable thing — because you read the subject
-> Continue reading Think twice about storing JSON in your SQL Server database
I may be completely off base here, but I’ve noticed a correlation between folks who use Amazon Web Services and their understanding that once you scale up a service during a busy business period, you can always scale back down again once the busy period is over. Perhaps that understanding is missing from the Azure
-> Continue reading Scaling down in the cloud
This coming Friday the 13th (August 2021) is the first ever Dativerse virtual conference, hosted by our DataGrillen friends William and Benjamin. According to their site: We try to elevate those that are usually underrepresented at conferences due to their race, gender, sexual orientation, location or any other reason. We aim to create a safe
-> Continue reading Join me on 13 August 2021 for Dativerse