2023-02-15
1,899 reads
Vincent92
- 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
How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group
This article tracks down a problem with Availability Groups due to network bandwidth.
2022-10-21 (first published: 2022-08-09)
2,843 reads
How to Use PowerShell to Set Secure SA Passwords in Bulk
Learn how you can bulk set passwords using PowerShell for all your instances.
2022-09-16 (first published: 2022-08-17)
1,730 reads
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: […]
2022-08-06 (first published: 2022-07-27)
453 reads
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 […]
2021-12-24
1,182 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Managed Instance Link and SQL Server 2022
Comments posted to this topic are about the item Managed Instance Link and SQL...
Passing parameters to query without TVFs
Comments posted to this topic are about the item Passing parameters to query without...
Capturing Data Changes
Comments posted to this topic are about the item Capturing Data Changes
Ask SSC