sqlrus.com // dba // bat whisperer
Failing to plan is planning to fail. When organizations first begin implementing Azure networking, the focus is often on the immediate requirements: connectivity, security, and performance for your databases and applications. While that is important, the reality is that your environment will change at some point in the future. Developers […]
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 […]
AI and ChatGPT are all the rage these days. Seems like around every corner is another break-through in how we interact with data, regardless of if that data is structured or un-structured. In my latest video, I dive into implementing a Retrieval-Augmented Generation (RAG) solution using Azure SQL Database! This […]
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 […]