Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
899 reads
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
899 reads
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,248 reads
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,265 reads
Finally a REAL keyboard for my iPad!
I can’t tell you how long I’ve wanted a real keyboard that my iPad...
2012-11-28
1,274 reads
Again, frustration.
After almost breaking my arm patting myself on the back getting past my last SAP BW issue I found that...
2012-11-19
1,173 reads
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,724 reads
Here In A Flash!
Its been a crazy last few years in the flash storage space. Things really started taking off...
2012-11-07 (first published: 2012-11-05)
2,719 reads
Why do some things have to be so hard?
I have been asking myself that question for the better part of...
2012-11-01 (first published: 2012-10-30)
3,450 reads
Shared Consolidated Storage Systems – A Brief History
Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes...
2012-10-30 (first published: 2012-10-26)
2,481 reads
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,005 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