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
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?
Welcome to the Azure Data Community, empowered by Microsoft
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this year and its video library & brand names were bought by Red Gate Software Ltd, it left the SQL Server Family (#SQLFamily) in a quandary. On the one hand, the big PASS Summit will be revived and all archive videos will be
-> Continue reading Welcome to the Azure Data Community, empowered by Microsoft
Calgary Data User Group – 24 February 2021 at 5pm MST
This Wednesday, from 5pm to 7pm Mountain Standard Time, the Calgary Data User Group is presenting two sessions for your virtual attendance. 15 minutes: A lightning talk on Kubernetes (by Mohammad Darab) 60 minutes: New features in Management Studio (by Taiob Ali) To RSVP, visit us on Meetup.com.
How does the buffer pool handle low memory conditions?
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you always give SQL Server as much RAM as you can afford, because it’s going to use it. But what happens when SQL Server runs out of
-> Continue reading How does the buffer pool handle low memory conditions?
Professionalism in the age of COVID-19
Some years ago, I wrote about what it means to be “professional” (and that it doesn’t mean having to wear a suit and tie). Recently a conversation broke out on Twitter about what it means in the information security (InfoSec) field. The vast majority of InfoSec people in the conversation railed against the premise that
-> Continue reading Professionalism in the age of COVID-19