In this blog, I will go over the benefits of Azure Front Door and how you can utilize it with a Web Application Firewall to allow your applications to scale with solid security. I will follow up with another blog on deploying Azure Front Door using a Web Application...
Welcome to our blog, which is more than just a record of our experiences. It’s a resource.
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.
Prevent Xtrabackup Failures for MySQL after Linux OS Patching
Patching the operating system is essential to keeping your server secure and performing optimally. Patching is as easy as running an apt-get update and apt-get upgrade. However, this can cause some unintended consequences. For one, MySQL server will also be upgraded...
Page Splits and How to Optimize Index Space in SQL Server
If you're noticing a significant drop in performance, as well as frequent index fragmentation, you might have an issue with page splits, especially if your fill factor is set to default on all of your indexes. What Are Page Splits? Page splits occur when there is...
SQL Server 2022 Release – What Are We Excited About?
With the release of SQL Server 2022 for mainstream, we checked in with our DBAs to see what they are most excited about in the new version. We have all been waiting patiently for this release and are really happy to see it drop for mainstream support. Parameter...
Using Replication Monitor in Legacy (Pre-2016) SQL Server Management Studio
Is SQL 2016 older than SQL 2005? Or is your outdated SQL Server Management Studio (SSMS) lying to you? Sometimes, the most interesting discoveries come from being lazy. Case in point: I was working with a few other DBAs on a client system having issues with...
Automating Log Rotation with Logrotate
Rotating MySQL logs is important because logs can take up a lot of disk space if left unmanaged. For example, an untuned database can lead to a lot of slow queries being logged. The error log can become large if it includes notes and warnings. Additionally, binlogs...
Troubleshooting FSLogix Issues In Azure Virtual Desktop
This blog is a follow-up to my other blog, Setting up FSLogix with Azure Virtual Desktop, for troubleshooting common issues I have seen when using FSLogix with AVD. I will include steps to resolve them and other troubleshooting methods you can use when you run into...
Setting up FSLogix with Azure Virtual Desktop
SUMMARY: Cloud engineers can optimize end-user performance and decrease sign-in times in an Azure Virtual Desktop (AVD) environment by implementing FSLogix Profile Containers, which store user profiles in mounted VHD(X) files backed by Azure Files storage. Successful...
The Elements of a Bash Script
Database administrators need to know databases as well as the operating system (OS) their database is running on. Bash scripting is where the two merge. For the beginner, bash scripting can be intimidating, but all have the same basic structure: a beginning, middle,...
What is NUMA: Why Does SQL Server Care?
Multi-GHz processors need maximum memory bandwidth to reach their full potential.SQL Server needs maximum memory bandwidth to reach its full potential. They need to access memory as fast and with as much throughput as possible. A bottleneck develops when processors...









