After installing SSMS 17.2, I was unable to connect to SSIS on my machine. The error said the specified service does not exist, which was misleading.
SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated
SCOM warned that SQL Server cannot use Kerberos because the Service Principal Name (SPN) is missing. Here is how I checked and fixed the SPNs for a client.
SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero
This Zero puzzle asks for the shortest SQL Server code within three restrictions. I want the exact code and character count.
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
DATEDIFF returns INT and overflows with Msg 535 on large ranges. SQL Server 2016 adds DATEDIFF_BIG, which returns BIGINT. Here is a simple example.
Asking a SQL Question That Gets Answered: The Reproducible Script
Write a reproducible script with minimal tables, synthetic rows, the failing query, expected results, and the exact SQL Server version.
SQL Server Management Studio – New Feature – Object Explorer Query Tracking
Object Explorer Query Tracking exposed SSMS queries while expanding nodes in the historical release. I used its Output window for investigation.
How to Allow Only Alphabets in Column? – Interview Question #136
Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.