HOW TO: Improve Database Performance Without Changing Code

I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience? We already know that great judgment comes from great experience, and great experience comes from bad judgment. That means … Read more

Get All Endpoints for VMs in an Azure Subscription

I wrote a post recently about troubleshooting connectivity for endpoints on Microsoft Azure VMs. The day the post went out I was greeted with this tweet: http://t.co/Ww3MyYjwPu right on time context post for me @SQLRockstar tx sir. Need to see on ports for my #linux vms with #mysql running 🙂 — Shyam Viking (@myluvsql) April 30, … Read more

Troubleshooting Azure Connectivity: Ports and Endpoints

can't connect to remote computer

It was a simple enough question, or so I thought. One I felt should be either a simple “yes” or “no”. “Do we block remote desktop connections here?” Sure enough, I got back the quick and simple answer I expected, along with a question for myself. “Nope. We don’t block any RDP sessions. Maybe you … Read more

The Five DBA Food Groups

Tomorrow is Thanksgiving here in the USA. It’s a day where we are supposed to be thankful for what we have been given and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force retail workers to work longer hours in the name of … Read more