Getting Excited: SQLBits is Coming!
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
855 reads
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
855 reads
Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...
2011-08-31
1,777 reads
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
754 reads
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,240 reads
Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun,...
2011-08-11
614 reads
The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an...
2011-06-16
759 reads
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
5,800 reads
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,095 reads
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,265 reads
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,170 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