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…
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
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…
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,…
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…
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…
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,…
Why nested views are bad
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you tend to use all over the place (a very common…
Help the fight against cancer
Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community, Tom was a well-known raconteur who wrote around a hundred stories, many of which were…
Speaking at SQLSaturday 725 in Victoria
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It is beautiful there, and I wouldn’t mind retiring there someday. Those of you who listen…
Speaking at SQLBits next month
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London, on Saturday 24 February 2018. My session is called Back to the future with Temporal…
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM) resulting in a series of vulnerabilities in operating systems and…
The cloud is not just someone else’s computer
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether we like it or not, the cloud is more than just a bunch of 1s…
Welcome to 2018
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of my favourite topics: dates and times. On that note, if you are reading this in…