Error Authenticating Proxy | SQL and UPNs
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let...
2014-02-10 (first published: 2014-02-04)
1,688 reads
Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let...
2014-02-10 (first published: 2014-02-04)
1,688 reads
I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can...
2013-12-24 (first published: 2013-12-18)
3,134 reads
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...
2013-12-20
6,106 reads
It was recently brought to my attention that a post with the script I talk about below could not be...
2013-11-18
488 reads
Things have been too quiet here on the blog, but there’s a reason (a few actually). This year has been...
2013-08-01
561 reads
I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013...
2013-05-22
1,175 reads
Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE...
2013-03-26
1,833 reads
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,665 reads
I blogged about this back in September of 2010, but technology changes so it’s time to revisit this again. Now...
2013-03-11
933 reads
This post is a live blog of the PASS Summit 2012 keynote from day 2 on 11/8/2012. This post is...
2012-11-08
645 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...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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
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