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

SQLServerCentral Article

Docker Advice for SQL Server in Production

Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server remains the gold standard. However, there are still certain scenarios—or even specific environments—where deploying SQL Server in containerized setups using the Docker engine becomes necessary. In this article, I will offer practical tips based on my hands-on […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-10-27

5,599 reads

SQLServerCentral Article

Add a Second NIC for an Availability Group to Separate Network Traffic

Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface card for both network traffic of database connections from application servers and database mirroring between AOAG […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2025-09-01 (first published: )

6,422 reads

SQLServerCentral Article

How to setup multi-subnets Azure SQL VM AG group based WSFC (Windows Server 2019)

In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step,  it is a detailed supplement to the Microsoft official articles and it is a beginner's guide for people who have no experience to do that, please read this article closely with Mircosoft's guide: […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2022-08-06 (first published: )

2,141 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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2021-12-24

1,613 reads

Blogs

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates

By

This week I was at PASS Data Community Summit in Seattle, and I attended...

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

Read the latest Blogs

Forums

Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Server-level Roles

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance

Tracking Inserted, Updated, and Deleted Rows with SQL Server OUTPUT

By Imran2629

Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...

Visit the forum

Question of the Day

Server-level Roles

In SQL Server 2025, can I alter a fixed server role?

See possible answers