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
SQL SERVER - Empty Startup Parameter in SQL Cluster on One Node

SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node

February 27, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster

Many problems lead to the same symptom. Here is another reason for an empty startup parameter in SQL Cluster, when it was not a registry permission issue.

Read More
SQL SERVER - Backup to URL error: Operating system error 50(The request is not supported.)

SQL SERVER – Backup to URL error: Operating system error 50(The request is not supported.)

December 2, 2017
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages, SQL Server, Windows

Backing up a database to Azure gave me a backup to URL error: Operating system error 50, the request is not supported. Here is the cause and the fix.

Read More
SQL SERVER - Unable to Get Listener Properties Using PowerShell - An Error Occurred Opening Resource

SQL SERVER – Unable to Get Listener Properties Using PowerShell – An Error Occurred Opening Resource

September 9, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, PowerShell, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster

A client could not change listener properties with PowerShell and got “An error occurred opening resource”. Here is the T-SQL query I shared and what fixed it.

Read More
Intact archive cases are set aside for inspection while the retained collection remains secure.

SQL SERVER – Previewing Old Azure Backup Blobs Before Removal with PowerShell

June 19, 2017
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Azure, SQL Data Storage, SQL Scripts, SQL Server

Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.

Read More
Database backup process.

SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage

February 17, 2017
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Azure, SQL Backup and Restore, SQL DateTime, SQL Scripts, SQL Server

My backups to Azure kept piling up. Here is the PowerShell script I wrote to remove old SQL database backup files from Azure Storage automatically.

Read More
Smo related info for sql server.

SQL Server – PowerShell Script – Getting Properties and Details

December 22, 2016
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Server

A retail client runs 1500+ databases with fewer than 10 DBAs, so automation matters. Here is a PowerShell script to get SQL Server properties and details.

Read More
SQL SERVER - How to Get List of SQL Server Instances Installed on a Machine?

SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?

November 12, 2016
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts, SQL Server

There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.

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

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