Skip to content

Randolph

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.… 

messy paint

Why you should not use SELECT *

  • by

A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we shouldn’t use SELECT *, which was both amusing and accurate. Amusing, because a number of…