sqlrus.com // dba // bat whisperer
Microsoft continues to expand the Azure ecosystem rapidly. One of the most recent delivered improvements was Azure SQL Database Serverless option. The new serverless model, which is currently in public preview, provides a compute tier for a single database that scales dynamically with the workload. This new compute tier […]
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x 108 m/s) other than getting as close to your cloud resources as possible. I believe that Microsoft does a great job […]
I have a client that resides in the Azure data platform arena, focusing mainly on Platform as a Service (PaaS) and Azure SQL DB. They have a decent landscape of Azure resources and currently utilize failover groups within SQL DB to facilitate high availability. Under the covers, failover groups are […]
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using Ola Hallengren’s Maintenance Solution which simplified things since each back up had it’s own specific directory. Powershell has the flexibility to […]
As the saying goes, time flies when you are having fun. We are already on the 2nd half of June in 2019 and if you were not aware, extended support for Microsoft SQL Server 2008 SP4 and 2008 R2 SP3 ends on July, 9th, 2019. Previous service packs for each […]
On occasion you have to find means to get around an issue. Recently at a client I discovered that an unknown SQL Server that wasn’t being properly cared for. This particular instance wasn’t taking backups and it was deemed as a critical production server. You can begin to see the […]
Anytime that you a large environment, gathering metrics in any form can be daunting and cumbersome. Using scripting languages can usually greatly improve the efficiency of this process as well as be more accurate. Whether it’s VMWare, SQL Server, or some other platform, it would behoove you to see what […]