Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.
Accessing Relational Databases in Go at Pluralsight
I just released my 42nd course on the learning platform Pluralsight. It was fun to build this new course Accessing Relational Databases in Go.
Hybrid Cloud Monitoring
AWS, MS Azure and GCP are extremely popular for hosting applications and databases. Let us discuss Hybrid Cloud Monitoring.Â
Real-Time Monitoring of MySQL Server
Everyone in the organization wants to know the reasons and resolution. For any DBA, they must know the real-time insight into their server.
File-Based Log Monitoring on AWS MYSQL RDS
The way the cloud platform works on Azure is very different from how it operates on Amazon MySQL RDS. Let us learn today.
MYSQL Long Running Queries
The data that used to be available freely now starts to get locked, and queries sprinting are now turning into long running queries.