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
Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I might be wrong about the beans), there is a good chance that you will find yourself using it. Not only can ADR dramatically improve recovery time with database restores, but
-> Continue reading Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
How to really store a password in a database
Recently I wrote: Don’t store passwords in a database. I stand by this statement. I expected a lot of flak because I didn’t explain myself. This post goes into a bit of an explanation of my position, as well as how to go about storing something in a database that can be used for authenticating
-> Continue reading How to really store a password in a database
Gatekeeping and why language matters
This is the second in a series of posts about gatekeeping in Information Technology and other fields. Negative terminology The language we use matters. In the first post I wrote that a number of words we use by convention need to be phased out, especially if they have negative connotations. I used Michele’s example of
-> Continue reading Gatekeeping and why language matters
How to store a password in a database
Hello, and welcome to today’s class on storing passwords in a database. Don’t store passwords in a database. Thanks for attending. Photo by James Sutton on Unsplash.
The importance of backups
I have been selected to present a second session for the PASS Summit in November this year. I wrote a few weeks ago about the Linux Learning Path and being a part of that, so I was certainly not expecting this. My second topic is about backing up, testing, and restoring SQL Server backups if
-> Continue reading The importance of backups
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will I be the last — to say that the terminology we use in the technology sphere is problematic. Language and gender bias Let’s look at several tweets collected in the
-> Continue reading All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
Better SQL Server memory defaults in 2019
In 2016 I created the Max Server Memory Matrix as a guide for configuring the maximum amount of memory that should be assigned to SQL Server, using an algorithm developed by Jonathan Kehayias. SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has
-> Continue reading Better SQL Server memory defaults in 2019
Better SQL Server CPU defaults in 2019
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to SQL Server Setup, on the Windows version. On the Database Engine Configuration screen are two new tabs, called MaxDOP and Memory. These are both new configuration options for SQL Server
-> Continue reading Better SQL Server CPU defaults in 2019
The third time’s the charm
Thank you to Microsoft for awarding me a Microsoft Data Platform MVP for the third time in a row. Unlike previous posts on this topic, I have very little to say except “thank you.” It’s been an interesting year, and I’m grateful to everyone I’ve had the privilege to work with and speak to. Onward!
SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You really should be upgrading to SQL Server 2017 at the very least, with some serious consideration to the unreleased SQL Server 2019. My reasoning for suggesting
-> Continue reading SQL Server 2008 and 2008 R2 is end of life on 9 July 2019