We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
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,...
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...
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 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 attention of your Network folks, only to be sent...
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...