Skip to content

Dates and Times in SQL Server: DATEADD()

  • by

We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we look at one of my favourite T-SQL functions when it… 

PASS Summit Speaker Idol 2018

  • by

This scheduled post is coming to you from Seattle, where the PASS Summit 2018 has just kicked off. Because it is a scheduled post, I have no idea what announcements from the convention will be… 

SQL Server logo

Fix SQL Server with one click

  • by

(This post was updated on 5 February 2022.) Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration is not recommended for production environments, and… 

What is a DBA anyway?

  • by

Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked what a database is. One of the major announcements at Ignite last month was that… 

Microsoft Azure logo

Azure means hybrid now

  • by

On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to make life a lot more interesting for many people all over the world. There’s a… 

Dates and Times in SQL Server: AT TIME ZONE

  • by

Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the hint AT TIME ZONE. In Azure SQL Database, the regional settings of the database are… 

Relational databases aren’t the problem

  • by

Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is no doubt biased. It might go into technical detail. Parts of it may be wrong.…