Master Data Services error – Cannot read configuration file due to insufficient permissions
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,313 reads
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,313 reads
The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was...
2016-10-14
513 reads
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...
2016-10-13
774 reads
Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...
2016-10-05
516 reads
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...
2016-10-04
582 reads
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...
2016-10-12 (first published: 2016-09-28)
3,879 reads
Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS...
2016-09-14
677 reads
Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary...
2016-08-22 (first published: 2016-08-12)
2,950 reads
I’ll be giving a webinar on the new features of Integration Services 2016.
When? August 11, 2016
Where? On the MSSQLTips.com website. You...
2016-07-28
809 reads
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS,...
2016-07-27
2,873 reads
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
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...
hi we run 2019 std. we saw this week that someone hid 3 important...
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