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)
SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)
As I mentioned in my earlier blog, backup to URL is one of the common methods used in SQL Server performs a backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using Shared Access Signature also called as SAS token.
SQL SERVER – Msg 3292: A Failure Occurred While Attempting to Execute Backup or Restore With a URL Device Specified
In my recent project with a customer, they wanted to configure SQL backups to Azure Blob Storage. When we were trying to take a backup, we were facing error. In this blog we would learn how to fix error message 3292 – A failure occurred while attempting to execute Backup or Restore with a URL device specified.
How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182
This blog is not specific to SQL Server, but I have recently seen hex error codes in SQL Server ERRORLOG and it took me little time to get the meaning of it. In this blog, we would learn about how to convert a hex windows error codes to meaningful error messages.
SQL SERVER – Execution Plan Ignores Tabs, Spaces and Comments
Just another day I was delivering my training SQL Server Performance Tuning Practical Workshop, I noticed that organizations had many stored procedures but none of the SP had any comments. When I asked them why their Stored Procedures does not have comments, their point was that they believed because of the comments, the size of the execution plan increases. Not True, when SQL Server builds an execution plan, it ignores tabs, spaces, and all the comments.