I wrote a blog post a few months ago about the tools I use on my jumpbox you can read here. Since then, I have automated most of the install with Chocately and so I’ll have the script later I’m going to blog it here. First, we need to install
Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop some indexes and they couldn’t because they couldn’t get a lock request. Sadly, they were using the GUI to try to accomplish this. Always makes