MORE ABOUT ME

SQL Azure

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

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

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

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