Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
5 reads
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
5 reads
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can...
2023-09-11
186 reads
I have seen this question many a time that people have asked “The Cloud or On-Premise – is it a go or no go?”. This is something that has...
2022-03-17
3 reads
This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my friend Rakesh call me in jeopardy. One of his...
2022-02-18
15 reads
Last year, September 2020 we had organized 1st yearly event and we named it Surat Tech Talk. That event was a great success. This year, we are organizing this...
2021-12-14
I have a good news to share with you all. This year, 1st of August 2021 I have received an email that surprised me. The email reads that I...
2021-12-03
2 reads
Recently I have faced a very interesting issue. A good friend of mine and my batchmate Rakesh called me this morning. He told me that one of his customers...
2021-07-27
2 reads
I have the privilege to work on Saturday and Sunday, holding a pager during my shift hours. I get most of the blog ideas during this stint. Today’s post...
2020-11-21
2 reads
As usual, I was working on my weekend on-call and I have had an alert. Our monitoring system has reported a message printed from the error log. I was...
2020-07-14
15 reads
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported a corruption for one of his databases. The corruption...
2019-05-28
3 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...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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