Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
860 reads
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
860 reads
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
379 reads
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy...
2016-04-26
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows...
2016-04-19
195 reads
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older,...
2016-04-19
2 reads
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
529 reads
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
199 reads
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
896 reads
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
476 reads
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-03-02 (first published: 2016-02-23)
2,224 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...
Hello, I have a question regarding Availability group server architecture. A little background: We...
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...
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