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.
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video.
Tracking Changes in MySQL Configuration
The next logical place to check what has changed is the configuration. Let us learn about Tracking Changes in MySQL Configuration.
Challenges Monitoring MySQL Performance
MySQL is one of the most popular relational database management systems (RDBMS). Challenges Monitoring MySQL Performance