sqlrus.com // dba // bat whisperer
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 […]
In a previous post, I discussed the public preview of Azure SQL Database Serverless. This is a newer product released from Microsoft for the Azure ecosystem. Moving to this new product is really easy to do and I thought that I’d show you how. Moving the Database From the screen […]
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 […]
If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state, you aren’t alone. Thankfully, Azure provides a number of tools to aid in your experience in the cloud when it comes to “reboot darkness”. Boot diagnostics allows you to see […]
In a previous post, I talked about some of the available storage options that can be used to back up your databases directly to the cloud. Doing this is a really good way to get your backups off-site and replicated in a single motion, depending on the region and redundancy […]
Azure offers a lot of features that enable IT professionals to really enhance their environment. One feature that I really like about Azure is storage accounts. Since disk is relatively cheap, this continues to hold true in the cloud. For less than $100 per month, you could get up to […]
As a database administrator, I am very conscious of how data is being backed up. Up until SQL Server 2012, you were limited to backing up your databases to a physical device. That device could be a tape, local disk, or network storage. After successfully creating a backup, if you’re […]