Happy New Year!
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
1 reads
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
1 reads
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays...
2019-12-27
48 reads
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-27 (first published: 2019-12-13)
301 reads
Some of the most eagerly anticipated features now available in SQL Server 2019 relate to expanded data virtualization capabilities. Data virtualization enables you to bring all your data together...
2019-12-20
46 reads
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-13
14 reads
A few weeks ago I attended the annual PASS Summit conference in beautiful Seattle, Washington. This is an event that I look forward to every year. Being able to...
2019-12-06
1 reads
Yesterday was Thanksgiving for those of us living in the United States. If you celebrate this particular holiday, I hope that it was a day full of love and...
2019-11-29
Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019,...
2019-11-22
4 reads
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
424 reads
Hiring consultants is like buying a new washing machine. In other words, you get what you pay for some times. A couple of months ago, my washer and dryer...
2019-11-15
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...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
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