In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the specific part of a date and/or time (year, month, day, hour, minute, second, etc.). This… Dates and Times in SQL Server: DATEPART()
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even learned something that had always bothered me but had been… T-SQL aside: replace PRINT with RAISERROR
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have disagreed with, namely that DATETIME is a terrible data type which… Dates and Times in SQL Server: the problem with DATETIME
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During the follow-up meeting, the senior DBA and I had a discussion about Virtual Log Files… Virtual Log Files: 200 or 1000?
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL Database using Transact-SQL (T-SQL). We identified that out of the options provided, SYSUTCDATETIME() is the… Dates and Times in SQL Server: more functions you should never use
Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions at SQLSaturdays and SQLBits. Thank you for providing session feedback to help me improve. Thank… A big thank you
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP is the Windows Millennium Edition of data types. It has nothing to do with date… Dates and Times in SQL Server: What about TIMESTAMP?
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data types to help you design the best possible database. You can read more about that… Dates and Times in SQL Server: T-SQL functions to get the current date and time
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.… Dates and Times in SQL Server: the science of time redux
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… Dates and Times in SQL Server: the science of time
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… Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018
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… 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… 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… Dates and Times in SQL Server: TIME
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,… T-SQL Tuesday #100: Looking Forward