Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
228 reads
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
228 reads
This scheduled post is coming to you from Seattle, where the PASS Summit 2018 has just kicked off. Because it...
2018-11-07
187 reads
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
495 reads
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL...
2018-10-24
222 reads
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
290 reads
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....
2018-10-10
312 reads
Some time ago we started a new series here, called Database Fundamentals. The very first post in that series asked...
2018-10-03
280 reads
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
339 reads
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
222 reads
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
268 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers