Blog Home Page - Page 195 of 830 - SQL Authority with Pinal Dave

Jul24

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.

Jul23

SQL SERVER – Quick Introduction to Startup Procedures

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure, Starting SQL

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.

Jul22

How Old Version of SQL Server Running on Server? – Interview Question of the Week #183

Pinal Dave

SQL Interview Questions and Answers

SQL Patch, SQL Scripts, SQL Server

No Comments

Question: How Old Version of SQL Server Running on Server?

Jul21

SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable

Pinal Dave

SQL

Computer Network, SQL Error Messages, SQL Server, SQL Server Installation

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.

Jul20

SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server

No Comments

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.”

Jul19

SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata

Pinal Dave

SQL

SQL Backup, SQL Error Messages, SQL Server

No Comments

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.

Jul18

SQL SERVER – Backup to URL – Script to Perform Stripped Backup using Shared Access Signature (SAS)

Pinal Dave

SQL

SQL Backup, SQL Error Messages, SQL Scripts, SQL Server

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)

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?

SQL SERVER – Quick Introduction to Startup Procedures

How Old Version of SQL Server Running on Server? – Interview Question of the Week #183

SQL SERVER – Install 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

SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata

SQL SERVER – Backup to URL – Script to Perform Stripped Backup using Shared Access Signature (SAS)

SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision

SQL SERVER – Stored Procedure and Transactions

SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days

SQL SERVER – Generate Database Script for SQL Azure

SQL SERVER – Convert IN to EXISTS – Performance Talk

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2