Vincent92

Hello, I'm Vincent, a DBA from a well-known International company, I'm skilled at SQL Server database management, and have much experience in using PowerShell scripts, and T-SQL scripts to do automatic operation and management of Database, including Instances deployment, daily operation (backup/monitoring/jobs/auditing), Trouble-shooting, AOAG, DB tuning and performance management, Server-Instance-Database lifecycle management, Database migration, Database DevOps (Azure DevOps), the elastic job for Azure SQL Database. Currently, I am focusing on Azure DevOps and Azure automation, I have some good practice in that and I keep learning about that. Also, I have some experience with Power BI, Power Automate, Power VA, and Microsoft Bot framework.

Interests: Coding, Travelling, Cooking
Skills: PowerShell, T-SQL, SQL Server, AOAG, Azure SQL DB, DB DevOps, Windows Server, Power BI, Power VA, Bot Framework, Power Automate, Linux, VMware

SQL Server instance startup type check by SQL script

by Vincent92

SQLServerCentral

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2021-12-24

1,554 reads

Discuss

Blogs

SWAG Saves the Day

By Steve Jones

PASS Summit East is in one week. I was on the road last week...

Read the latest Blogs

Forums

Visit the forum

Vincent92

SQL Server instance startup type check by SQL script

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

BCA KCP Hayam Wuruk Tlpn/wa:085373737551

BCA KCP Duri Raya Tlpn/wa:085373737551

BCA KCP Mangga Besar Tlpn/wa:085373737551

Question of the Day

Increase Deadlock Detection