Scripts

Technical Article

5 (6)

2022-02-22 (first published: )

5,838 reads

Technical Article

SQL Server instance startup type check by SQL script

I have developed the script to check SQL Server instances startup type, sometimes we didn't know all our SQL instances startup type correctly configurated, especially we cannot distinguish the Automatic and Automatic(Delayed Start) from the direct query, the only way is querying from the registry, you can use this script in your environment to bulk […]

5 (1)

2021-12-24

1,094 reads

Technical Article

Get backup folder sizes from shared Location

Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]

5 (1)

2021-12-03

365 reads

Blogs

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Single index reorg took 2 full days or more to complete

By JasonO

I'm running an index maintenance job on 1 of my large database as the...

DB Size

By water490

Hi everyone I am doing some test development in SS19 and the file size...

Backup Directly to a GCS Bucket in SQL Server 2022

By abair34

Comments posted to this topic are about the item Backup Directly to a GCS...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers