Return of the .NET - NYC
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,227 reads
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,227 reads
Upcoming this Saturday 12/12/2015, SQL Saturday #465, taking place in the more modest Providence, Rhode Island venue, comes a great...
2015-12-11
1,277 reads
You better watch out, you better not cry, gonna find out who's naught and nice - TSQL Tuesday #73 is coming...
2015-12-08
2,360 reads
Saturday, December 5, 2015: SQLSaturday#470 is on track to be an extraordinary event in DC this Saturday, with a fantastic...
2015-12-02
1,154 reads
Well I’m not
a data modeler, nor do I play one in the corporate world. But it is TSQLTuesday No. 72,...
2015-11-10
2,443 reads
As of October
1, 2015, I am no longer a Microsoft SQL Server MVP. Countless of my colleagues met the same...
2015-10-27
1,737 reads
It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...
2015-10-23 (first published: 2015-10-19)
4,195 reads
Following up on my previous blog
on introducing the “Social DBA”, I spoke about the concept of leveraging
social networking to excel
in...
2015-10-08
1,537 reads
Are you a Social DBA?
No I don’t mean that you are a DBA and attend a myriad of merry mixers,...
2015-10-06 (first published: 2015-09-28)
2,475 reads
Welcome to the 21st century! 20th
century habits die hard! What am I
talking about today? I’m talking about the virtuous virtue...
2015-10-06
1,484 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Carisol 350mg is the main ingredient. Its powerful formulation, which includes the active ingredient...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
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