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,687 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,687 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
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
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
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...
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?
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
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