Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
A properly designed virtualized SQL Server instance running in a VM with Windows Server (or Linux), using vSphere is crucial to the successful implementation of enterprise applications. One main difference between designing for performance of critical databases and...
The error log is an important tool for troubleshooting. The size of the error log file can get quite large if left unattended. For starters, there are not many parameters that can be adjusted to impact its size in any way, unlike the binlog that has a few system...
This article is the first of a series of blogs which I will discuss the benefits of using Azure Virtual Desktop (AVD) and what it can do to help safely secure your remote workforce. I will first describe the key features that AVD offers and then branch out to specific...
Binary logs play an important role in replication and data recovery. In replication, source databases communicate data changes recorded in its binary logs to the replica's relay logs. They can also be used to repair a replica experiencing data drift. In a similar way,...
You can also check out the Recorded Webinar. You may see events in your error logs reporting transient connection failures between cluster nodes or AlwayOn. You may observe high Asynch_Network_IO in [sys].[dm_os_wait_stats]. And you may have even brought it to the...
There are quite a few monitoring tools out there that can benefit you in your environment, but if you want to capitalize on robust alerting and monitoring within the Azure space, then Azure Monitor is the ideal solution to use. Azure Monitor will allow your...
In this article, you will learn best practices on migrating on-premise servers and applications to Azure. The push to the cloud is expediting, and it is essential to understand best practices and how to migrate on-premise servers and applications to Microsoft Azure....
When I was learning about Microsoft SQL Server issues a DBA needs to understand, I was reading about deadlocks. At first, I was confused because it sounded like the definition of blocking, which I was already more familiar with. I re-read it a couple of times and...
The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table. The information provided by these...
MySQL 5.6 reached its end-of-life (EOL) in February 2021. If you haven't upgraded to MySQL 5.7, you are not the only one. It can be an intimidating endeavor. There are configuration, system table, server, Innodb and SQL changes to consider. And, documentation is not...