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
T-SQL Tuesday Retrospective #014: Resolutions
At the end of 2010, Sean McCown (blog | Twitter) invited us to talk about resolutions: Things like getting certified, or perfecting a process, or taking management classes, etc are all things that are commonly found in your yearly goals at work. So if you’re going to make some kind of resolution to do something,
-> Continue reading T-SQL Tuesday Retrospective #014: Resolutions
Ambling through undocumented DBCC commands may result in boredom
There comes a time when we heed a certain call. The call is to avoid dangerous undocumented DBCC commands in SQL Server, especially those that bypass built-in protections. I’m looking directly at you DBCC WRITEPAGE. Besides, Paul Randal (blog | Twitter) has written strongly and authoritatively on the topic, striking fear in the hearts of everyone
-> Continue reading Ambling through undocumented DBCC commands may result in boredom
Calgary Data User Group with Deborah Melkin and Andy Yun
Next week on Wednesday is the Calgary Data User Group’s second event for 2021, and the second event as a member of Microsoft’s new Azure Data Community. Since last year February we have been offering two sessions per event, with the opportunity for a lightning session (15 minutes) as well as the regular-length session (60
-> Continue reading Calgary Data User Group with Deborah Melkin and Andy Yun
T-SQL Tuesday Retrospective #013: What the business wants
Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010 comes the question “What issues have you had in interacting with the business to get your job done?” However a little digging showed that the business didn’t really understand the technology. They were asking for a result, and [the DBA] took them
-> Continue reading T-SQL Tuesday Retrospective #013: What the business wants
Upcoming speaking engagements
The last time I presented a session was at the final PASS Summit in November 2020, so it is time to get back on the virtual conference trail again. Columbus Ohio User Group, 8 April 2021 (Columbus OH, USA) For the Columbus group, I will present Managing and monitoring SQL Server on Linux from the
-> Continue reading Upcoming speaking engagements
Zeroing out a transaction log file does not use zeroes
I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not since SQL Server 2014 at any rate. As you can see from this post, the stamping of the transaction log since SQL Server 2016 is done
-> Continue reading Zeroing out a transaction log file does not use zeroes
What is a community advisory board anyway?
For those of us who have been involved in the Microsoft Data Platform community for a few years, the events of the last few months have been dramatic, culminating in the end of the Professional Association for SQL Server (PASS), which closed down in January 2021. As I wrote previously, this left local user groups
-> Continue reading What is a community advisory board anyway?
T-SQL Tuesday Retrospective #012: Why DBA skills are necessary
This is my ongoing series of answering T-SQL Tuesday posts far too late to be of any use. Click here if you want to read previous entries. Paul Randal asked us in November 2010 why DBA skills are necessary. As a reminder, DBA stands for Database Administrator, and this unleashes a discussion outside of the
-> Continue reading T-SQL Tuesday Retrospective #012: Why DBA skills are necessary
T-SQL Tuesday Retrospective #011: Misconceptions
(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve been labouring under when it comes to SQL Server: The possibilities for writing up a post on this topic invloving SQL Server are enormous even if you are a novice
-> Continue reading T-SQL Tuesday Retrospective #011: Misconceptions
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from recommended to completely avoided. Since the release of SQL Server 2016, several options that were recommended post-install have been rolled into the default installation options and no longer need to be done, and similar changes were made with SQL Server 2017.
-> Continue reading Which configuration changes in SQL Server require a restart?