It is interesting to see in SQL Server that same error message is raised due to multiple reasons. One such error is 9002. In this blog, we would quickly learn about the cause of error 9002: The transaction log for database ‘SQLDB’ is full due to ‘DATABASE_MIRRORING’
SQL SERVER – Observation: ROWLOCK Hint and Slow Performance
During my recent Comprehensive Database Performance Health Check Developer showed me a slow query which used ROWLOCK hint. The common understanding is that with the help of ROWLOCK hint SQL Server only locks a single row which eventually leads to performance but in their case, it was actually very much opposite. Let us see this scenario with a simple example.
Fun Video – Real World Performance Solutions by Bert
Today, I am very happy to share a fun video about class Real World Performance Solutions. I was very fortunate that I got the opportunity to build this video with Bert Wagner. He is truly a talented SQL Server expert and amazingly creative with the videos. I have never seen in my life anyone so versatile with creative with educational videos.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
During my recent engagement of Comprehensive Database Performance Health Check, Sr. DBA asked if it is possible to run SQL Server on multiple TCP Ports. The answer is Yes, it is very much possible.
SQL SERVER – Quick Introduction to Startup Procedures
In today’s blog we are going to talk about the SQL Server feature which actually exists for a quite a while but interestingly enough it is not known much. Let us have a quick introduction to startup procedures.
How Old Version of SQL Server Running on Server? – Interview Question of the Week #183
Question: How Old Version of SQL Server Running on Server?
SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable
During my consultancy engagement, my client’s DBA team was installing SQL Server and getting an error. Since they know my work style, I got pulled into fixing that issue. In this blog, we would learn how to fix SQL installation error: Validation for setting ‘AGTSVCACCOUNT’ failed. Error message: The RPC server is unavailable.
SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid
I was helping a client to install SQL Server using script/automation (without using UI). They wanted to do command-line install rather than hitting next, next, fill values in the UI as they have to deploy more than 100 servers with SQL installed on it. In this blog we would learn about how to fix SQL Setup installation error – “The specified value ‘Install’ for ACTION is invalid.”
SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata
Recently one of my old clients contacted me and informed that they are having an issue with database backup on the secondary replica. In this blog we would learn about how to fix error 3636 – An error occurred while processing BackupMetadata.
SQL SERVER – Backup to URL – Script to Perform Stripped Backup using Shared Access Signature (SAS)
Here are my previous blogs about Backup to URL, I have share scripts to take backup using Access Keys and SAS Token. One of my blog readers wanted to take stripped backup to Azure Blob. In this blog, I am sharing the script to perform a stripped backup using shared access signature (SAS Token)