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
dbSnitch
Discover exactly what’s hampering your SQL Server database environment and how to fix it.
Upgrade Wizard
Update your SQL Server to the latest version, or any older version currently supported by Microsoft.
Disaster Recovery
Recover data that may have been lost on databases from SQL Server 2005 and upwards.
2-Day Tune-Up
Improve your SQL Server performance in two days or your get 50% of your money back.
DBA
Get the on-site or remote Database Administration solution for all your SQL Server needs.
Speaking
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
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking. There’s also a high likelihood that you live in the United States. The technology industry seems to be thick with this stereotype, but as I mentioned in a series of posts about gatekeeping, if we only listen to (or read) white
-> Continue reading It’s 2021, so why are you reading this?
A blog post about writing blog posts
I recently wrote about how I teach, in response to a T-SQL Tuesday post from 2010. This is a continuation of that theme, suggested by my own editor. Thanks, Pete. “Tricks to get your mojo on.” Describing your rituals and tricks to get you into a writing frame of mind, or a developing frame of
-> Continue reading A blog post about writing blog posts
Security update for all supported versions of SQL Server (CVE-2021-1636)
Microsoft announced updates today for all supported versions of SQL Server, for a privilege escalation vulnerability that leverages Extended Events. For security reasons no further details have been provided, but you can expect more information in the near future, now that this update is public. From the knowledge base article: Data can be sent over a
-> Continue reading Security update for all supported versions of SQL Server (CVE-2021-1636)
T-SQL Tuesday Retrospective #008: Gettin’ Schooled
To view posts about previous T-SQL Tuesday entries, please use this tag. The late, great, Robert Davis invited us on Independence Day 2010 to write about Gettin’ Schooled: We return to our days of youth to take a fresh look at learning. How do you learn? How do you teach? What are you learning or
-> Continue reading T-SQL Tuesday Retrospective #008: Gettin’ Schooled
2020 was certainly a year on the calendar
According to my blog post schedule, this is the final post of the year. It’s nothing more than a coincidence, but making it through the worst year in living memory could also be considered a sign. While it’s true that calendars are arbitrary, Western tradition says this is the end of one more cycle, so let’s
-> Continue reading 2020 was certainly a year on the calendar
Goodbye PASS
“It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of belief, it was the epoch of incredulity, it was the season of light, it was the season of darkness, it was the spring of hope, it
-> Continue reading Goodbye PASS
Announcing the Calgary Data User Group
In 2018 I started a new user group called the Calgary Data User Group, and hosted one session called “The Ethics of Machine Learning.” It was well-attended and its format of a discussion group (as opposed to a regular slide show with demos) was well-received. At the end of 2019, the founder of the Calgary
-> Continue reading Announcing the Calgary Data User Group
T-SQL Tuesday Retrospective #007: Summertime in the SQL
This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our favourite hot new feature in SQL Server 2008 or 2008 R2. For me, this would be the introduction of the DATE, TIME, and DATETIME2 data types
-> Continue reading T-SQL Tuesday Retrospective #007: Summertime in the SQL
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB data, so now you know what this week’s post is about. Let’s go over some definitions and complain a little, because that’s how cranky data professionals
-> Continue reading T-SQL Tuesday Retrospective #006: What about blob?
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning. This week it’s the fifth entry, and on April 5th, 2010, Aaron Nelson invited us to write about reporting. You can visit the previous entries here: T-SQL Tuesday #001 – Date/Time Tricks T-SQL Tuesday #002 – A Puzzling Situation T-SQL Tuesday
-> Continue reading T-SQL Tuesday Retrospective #005: Reporting