SQL Azure

SQL Server Backup Audit

I had a question come up last week from someone that wanted to know a few basic facts about their SQL Server backups for audit purposes. The facts they wanted were straightforward:Who took the backup? When was it taken? Where was it written?Simple questions that are answered with a simple script. As usual,...

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

error An incompatible SQL Server Version was detected
An incompatible SQL Server version was detected

I’m not what you would call an “early adopter” by any means, but I do try to work with the latest versions of software whenever possible. A few months ago I finally got around to taking Visual Studio 2013 for a test drive.The reason for me wanting to kick the...