SQL INDONESIA

How to setup Database Mail in Microsoft SQL Server. Enable and configure Email Create Profile and Account Configure Email. USE masterGO EXEC sp_configure ‘show advanced’, 1GORECONFIGUREGO EXEC sp_configure ‘Database Mail…

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…

Storage Memory CPU – 1 socket and 8 vCPU Disk format 64KB block Cost Threshold for Parallelism Max Degree of Parallelism Instant File Initialization Power Plan High Performance Optimize for…

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