Query Store Instance Dashboard
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
1,934 reads
Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...
2016-11-07
1,934 reads
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,698 reads
As an IT professional we are used to spending a lot of time learning about new technologies or how we...
2016-06-09 (first published: 2016-06-02)
4,811 reads
In the previous article in this blog series I told you my plans of expending my horizons towards the Data...
2016-06-06
1,520 reads
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,034 reads
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
674 reads
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
752 reads
You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of...
2016-03-18
678 reads
As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they...
2016-03-14
1,660 reads
Remember that blog post from April this year that I announced working on my first ever SQL Server related book...
2015-09-02
1,545 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Hello I need to get txt files from directory and send email, when I...
Hello, I have a question regarding Availability group server architecture. A little background: We...
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