sqlrus.com // dba // bat whisperer
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the table! This update marks a significant evolution in the managed database space, offering improved performance, enhanced storage capabilities, and streamlined scaling […]
Did you know that you can deploy native VMWare virtual machines into Azure? Yeah, I didn’t either until earlier this month. Expanding VMWare If you are running VMware current in your on-premises, this solution would allow you to create a VMware cluster using dedicated Azure resources. These resources are based […]
Recently I needed to determine how much storage space each database on a logical server was consuming. I was doing some DR testing and I need to give the client a rough estimate on how much each database was going to cost. You can do this through the Azure portal […]
Unequivocally, yes on-premises SQL Server Instances are still relevant. While I’m a firm believer that the cloud is not a fad and is not going away, it’s just an extension of a tool that we are already familiar with. The Microsoft marketing slogan is “It’s just SQL” and for the […]
Azure SQL offers up a world of benefits that can be captured by consumers if implemented correctly. It will not solve all your problems, but it can solve quite a few of them. When speaking to clients I often run into misconceptions as to what Azure SQL can really do. […]
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a new ability that has recently surface within the Azure eco-system to help manage fail-overs. Let’s jump to it. High availability is […]
Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For an overview of the business benefits of using data infrastructure services in the cloud, download “Future-Proof Your Data Infrastructure with Azure: […]
Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to accomplish this to get SQL Server performance data One of these methods is using HammerDB, which is a free tool that […]