Vincent92

Hello, I'm Vincent, a DBA from a well-known American Chemical Enterprise, I'm skilled at SQL Server database management, and have much experience in using PowerShell scripts, T-SQL scripts to doing automatically 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), elastic job for Azure SQL Database. Currently, I am focusing on Azure DevOps and Azure automation, I have some good practice on that and I keep learning on that. Also, I have some experience with Power BI, Power Automate, Power VA, and Microsoft Bot framework, I am also responsible for our company Chat Bots development.
  • 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

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

902 reads

Blogs

Attach All SQL Datafiles in a Directory

By

Have you ever had the need to attach a large number of database in...

Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose

By

In this blog post, I’ve implemented two example environments for using SQL Server 2022’s...

Daily Coping 12 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

TSQL using Python for market basket analysis ModuleNotFoundError: apyori

By sqlnorth

Apologies if this is the wrong forum as its really python but need to...

loading data

By yemjalpawan

for suppose, my colleague is loading data in a table at same time i...

How could I have written this script better?

By JaybeeSQL

Hi all, I'm looking to sharpen my SQL/Programming skills, below is a sproc I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers