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...

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: right on time context post for me @SQLRockstar tx sir. Need to see on ports for my #linux vms with #mysql running :) — Shyam Viking...

can't connect to remote computer
Troubleshooting Azure Connectivity: Ports and Endpoints

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....

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...