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.
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...
When performing health checks on a database, I look at how many users are granted SUPER privileges. If you're reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to...
I recently faced an interesting challenge. I was working to replace (rebuild) a view with updated DDL, but when executing the CREATE OR REPLACE VIEW statement, Db2 returned error code SQL0551N. This error means that the user ID doesn't have authority to perform the...