Making Start-Demo work with multi-line commands without a backtick
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
520 reads
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
520 reads
What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...
2016-07-20
985 reads
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...
2016-07-14 (first published: 2016-07-03)
3,049 reads
The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of...
2016-06-30
989 reads
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
604 reads
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
777 reads
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
646 reads
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,640 reads
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name...
2016-03-11 (first published: 2016-03-03)
1,211 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-08 (first published: 2016-01-31)
1,735 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