This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a wooden shape-sorter box with a round vermilion peg resting beside a square hole on the lid

Set-ClusterParameter Error: ProbePort Does Not Exist on the Cluster Object

December 13, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, PowerShell, SQL Azure, SQL Error Messages, SQL Server Cluster

The Set-ClusterParameter error said Parameter ‘ProbePort’ does not exist on the cluster object. I hit it while setting up a probe port for an Always On listener in Azure. Two wrong values in my script were the cause, and fixing both let the script run.

Read More
An amber warning lamp standing alone on wet concrete in a dark plant room

SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault

October 16, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Azure, SQL Scripts, SQL Server, SQL Server Security

Not an Azure Key Vault after all: a Recovery Services vault that would not delete. The AzureRM script is retired, and soft delete waits 14 days.

Read More
Magnifying glass, document with red cross.

SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting

August 16, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages, SQL Scripts, SQL Server

SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting. Let us fix that in this blog.

Read More
Gouache illustration of a scoped firewall opening: a narrow side hatch opens through a gate whose other sections remain closed.

SQL SERVER – Scoped Firewall Rules Instead of Disabling the Firewall

August 3, 2018
Pinal Dave
SQL Tips and Tricks
Computer Network, PowerShell, SQL Scripts, SQL Server, SQL Server Security

A firewall rule should permit the required SQL Server or management connection narrowly. My original automation case needed remote access.

Read More
SQL Server Service Control Manager error.

SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure

July 2, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages, SQL Login, SQL Server, SQL Server Security

SQL Server running under a gMSA would not start: the service did not start due to a logon failure, yet no password had expired. Here is the real cause.

Read More
Get-DbaMaxMemory.

PowerShell – Get Maximum Memory of Server with dbatools

April 26, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Memory, SQL Scripts, SQL Server

Readers asked how to get started with dbatools. Here is a simple first step: finding the maximum memory of a server with one PowerShell command.

Read More
A reusable tool kit remains organized while one tool is inspected beside a sample joint.

PowerShell – How to Install dbatools?

April 25, 2018
Pinal Dave
SQL Tips and Tricks
DBA, PowerShell, SQL Server

dbatools installs as a PowerShell module on a Windows management machine. Rob Sewell, known as DBA with Beard, introduced me to it.

Read More
Previous 1 2 3 4 5 … 9 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com