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
Dates and Times in SQL Server: the science of time redux
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of you are students of Albert Einstein and his theory of relativity, this might seem familiar. How does a computer know what time it is? Inside the guts of every computer is a clock (called a[…]
Dates and Times in SQL Server: the science of time
Now that we have covered the various date and time data types (see the post from last time) in SQL Server and Azure SQL Database, it’s time to review what we know about time itself and how it is measured, so that we have a basic understanding of how and when to use these data[…]
Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018
I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two sessions: Back to the Future with Temporal Tables What’s New In SQL Server 2017 SQLSaturday is a volunteer-based day of free training for data professionals, and I encourage you to attend if you’re in Alberta.[…]
Dates and Times in SQL Server: DATETIMEOFFSET
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. This week, we look at the last new data type, DATETIMEOFFSET. If you’d like[…]
Dates and Times in SQL Server: DATETIME2
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. This week, we look at the DATETIME2 data type. I’m not the first person[…]
Dates and Times in SQL Server: TIME
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. What is the time? This week, we look at the TIME data type. It[…]
T-SQL Tuesday #100: Looking Forward
The future, 100 months from now: It’s Monday, 6 July 2026. It’s been quite a week since SQL Server Update 2607 was released. The entire production infrastructure has been refreshed. All devices are reporting in, and your glasses are showing green across the fleet. There’s a problem, though. One of the container hosts is reporting[…]
Dates and Times in SQL Server: DATE
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. The first one we look at this week is DATE. Whereas DATETIME uses eight[…]
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds, DATETIME. But let’s say you don’t need that kind of accuracy and are happy with a granularity to the nearest minute. Maybe you’re storing time cards and don’t think it’s[…]
Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and time data types in SQL Server, when to use them, and which functions to use for date and time calculations. This week will start with probably the best-known data type,[…]