PowerShell Tip – Custom windows for different tasks.
G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...
2011-04-22
729 reads
G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...
2011-04-22
729 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-22
561 reads
Apparently a lot, at least according to the blooper reel today
Filed under: Blog Tagged: bloopers, Humor, syndicated
2011-04-22
742 reads
Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...
2011-04-22
697 reads
For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance.
Cache...
2011-04-21
905 reads
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
453 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
749 reads
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-21
782 reads
Day 21 SMO programming Part 2 Continue with my earlier blog where I discussed about the information about SMO. Today...
2011-04-21
487 reads
Good day SQLServerCentral!
(Note: This does not have anything to do with SQL; it’s more of a (*gulp*) regular blog…)
Thirty-three weeks. ...
2011-04-21
605 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