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 a simple script. As usual,...

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

default_stripe
Q&A From My Azure Webinar With Scott Klein

Recently (OK, on July 23rd, 2014 to be exact) I co-presented a webinar with Scott Klein (blog | @SQLScott) titled "Know Before You Go: SQL Server on Microsoft Azure Virtual Machines". It was a repeat performance of the session we delivered at TechEd in Houston earlier this year. There were a...