While trying to start SQL Service for a named instance, I got an error message related to event id 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name).
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.
A very old client of mine yesterday pinged me with this question about error related to QUOTED_IDENTIFIER.
SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost
It is very common for people to move database now a day to the cloud. The very first question I often hear from them is – How to Improve Application Performance on Cloud While Reducing Bandwidth Cost?
My Journey to CrossFit Level 1 Trainer (CF-L1) Credential
Yes, it is true! I Earned CrossFit Level 1 Trainer (CF-L1) Credential. Let us see my journey to CrossFit rookie to expert.
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
While playing with my SQL Server startup parameter, I made some mistakes and came to a situation where SQL Server was not getting started. In this blog post, let us learn about error 17113.
SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version
I was consulting a client for migration from SQL 2014 to SQL 2016. They were using methodology discussed in books online here. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?redirectedfrom=MSDN&view=sql-server-ver15 (Upgrading AlwaysOn Availability Group Replica Instances). Let us learn about how to fix error 946.
How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110
Question: How to Keep Certain Records on Top While Ordering Data?