sqlrus.com // dba // bat whisperer
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize to help solve problems, such as performance tuning, configuration, and many others. Some are third party tools, some are free, and some are provided by the vendor themselves. Regardless of […]
Sometimes you know that a problem occurred, but the tools are not giving you the right information. If you ever look at the Cluster Failover Manager for a Windows Cluster, sometimes that can happen. The user interface won’t show you any errors, but you KNOW there was an issue. This […]
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 […]
More and more I am impressed on the Azure Portal. Microsoft continues to make enhancements to the user interface (UI) and add in new features. One of these new features that I’ve recently become aware of is the ability to easily switch accounts. As a consultant, I work with clients […]
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 […]
With the hurricane bearing down on the east coast of the United States last week, making sure you have a good disaster recovery plan in place should have been a top priority for you. If you happen to be using Azure SQL DB, adding geo-replication is a simple and easy […]
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on the east coast of the United States. Some areas have mandatory evacuation and I have seen reports of 80’ plus foot waves so this hurricane is not a joke. Another […]