How Do You Query Maintenance Plan Package Metadata?
Hello Dear Reader! Since I’ve joined Pragmatic Works I’ve learned a lot, seen a lot, and assisted in interviewing a...
2013-01-23 (first published: 2013-01-21)
4,973 reads
Hello Dear Reader! Since I’ve joined Pragmatic Works I’ve learned a lot, seen a lot, and assisted in interviewing a...
2013-01-23 (first published: 2013-01-21)
4,973 reads
I'm on a Book!
Hello Dear Reader, early last year I was asked if I would like to contribute to a...
2013-01-22
901 reads
Hello Dear Reader. Every now and then professionally you get to be a part of something really cool. Back in...
2013-01-15
801 reads
Hello Dear Reader! I've been working on Setting up a Virtual Lab in using Virtual Box on my work laptop....
2012-12-21
1,461 reads
Hello Dear Reader! Today in beautiful Orlando FL at the Loews Royal Pacific Resort the Live 360 Conferencekicks off. Live...
2012-12-11
878 reads
Hello Dear Reader! Today is the Big day for me here at the PASS Summit 2012. I'll be presenting the...
2012-11-09
909 reads
Hello Dear Reader! I'm sitting in the Keynote now writting up a summary of the event. More to come!
2012-11-07
580 reads
http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...
2012-10-26
1,063 reads
When I used to work in an office I had a stack of flash cards and occasionally I'd grab a...
2012-10-25
812 reads
Hello Dear Reader, I wanted to say a quick Thank You to the PASS DBA Virtual Chapter for having me...
2012-10-25
538 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...
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