sqlrus.com // dba // bat whisperer
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 […]
I will be the first to admit that I am what one might call a “SQL Head”. In other words, I’m a nerd that likes to dig into the internal workings of SQL Server, sometimes down to the bits and bytes. The tools to facilitate this archaeology have slowly been […]
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system it resides on. This was echoed during the keynote at SQL Bits 2019 by the Microsoft team, which you can watch here. Later that weekend, I gave a session about […]
Let’s be honest here, data security is really important to me. Some people probably think that I go to extremes to ensure that my data as well as my customers data is secured. With that, sometime ago, I wrote a blog post on utilizing a VPN server that I built […]
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This flexible option offers the ability to get your critical backups off site and in certain regions, they could be configured to be automatically redundant to a secondary region. Having backups […]
A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual machines won’t start. But what if you selected to disabled boot diagnostics when the virtual machine was created? Can you go back and retro-actively add them back? Yes, Virginia, yes […]