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 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 presenting an hour-long session about Big Data Clusters, a very interesting feature that was introduced with SQL Server 2019. From
-> Continue reading Calgary Data User Group: Big Data Clusters with Bob Pusateri
There’s a lot going on in the world today. It feels like there’s too much for us to think about. Speaking for myself, I’m worried about the environment first and foremost, followed closely by folks who refuse to wear masks that cover their noses and mouths, and finally by the apparent erosion of human rights.
-> Continue reading Days of future past
A customer I’ve been working with for a while now has a monolithic ASP.NET MVC web application which we are porting to .NET Core 3.1 (and then almost immediately to .NET 6). One of our biggest changes was getting rid of Entity Framework and replacing it with Dapper, because performance is a feature. To deflect
-> Continue reading Table Valued Parameters and Dapper in .NET Core
SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one. Building on a lot of work in the Azure SQL space, SQL Server 2022 looks to include some cool features including (but not limited to): failover to Managed Instance (and back again) enhancements to intelligent query processing (including
-> Continue reading SQL Server 2022 announced
After writing several posts about a neat feature in Azure SQL called system-versioned ledger tables, it reminded me about something I’ve wanted to say for a number of years now, outside of snarky tweets. Here goes: You don’t need a blockchain. In the vast majority of use cases, you need a properly audited relational database
-> Continue reading You don’t need a blockchain
2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next week, but I was also selected to speak at the upcoming GroupBy conference on Tuesday October 26, 2021. Yes, that’s also next week! Some facts about next week’s talks: Yes,
-> Continue reading Join me next week at my first GroupBy session
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