How to setup Database Mail in Microsoft SQL Server. USE masterGO EXEC sp_configure ‘show advanced’, 1GORECONFIGUREGO EXEC sp_configure ‘Database Mail XPs’, 1GO RECONFIGURE WITH OVERRIDEGO Open SQL Server Management Studio…

As a production DBA, I wanted to make sure all production sql servers are backup properly.And it’s amazing to me that when I assigned to Audit production Microsoft SQL Servers…

I am continuing my IT learning journey and have successfully set up two nodes for Microsoft SQL Server 2016 clustering on Azure. There are several preparations that must be completed,…

I’m working and supporting Microsoft SQL Server 2019 and 2022 AlwaysOn and ran into issues like Databases showed not healthy data synchronization stateDatabase on AG group showed “Not Synchronizing”The warnings message “Data synchronization state of some availability database is not healthy” In the SQL Server Management Studio for Secondary availability…

How To fix the suspended data movement in MS SQL Server 2016 AlwaysOn Availability Group (AG) Right click the user database Select Resume Data Movement

How to simulate a suspended data movement in SQL Server 2016 AlwaysOn Availability Group (AG) Select one of the user database. First right clicked the user database –> under Available…

I was assigned to assist the GIS Department in accessing a production SQL Server database. This production database will provide real-time mapping for field engineers. However, there were concerns regarding…

I am actively working to improve my skills and knowledge as a Database Administrator (DBA) with a focus on Microsoft SQL Server AlwaysOn technology using the new Windows Server 2022…

I found a solid article that discussed a common SQL wait type that provided by several SQL MVPs https://logicalread.com/common-sql-server-wait-types/#.WiF8YnmWyUk