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, here’s(…)

Get All Endpoints for VMs in an Azure Subscription

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, 2015(…)

Q&A From My Azure Webinar With Scott Klein

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 handful of questions asked during(…)

Microsoft Azure SQL Database Data Compression

Microsoft Azure SQL Database Data Compression

Back in March there was an announcement that data compression was available for Microsoft Azure SQL Database (MASD). This was met with much rejoicing. You can read more about the announcement here. Oh, wait…that’s right…Microsoft pulled the announcement back for some reason. Three months later, and I still don’t see an announcement regarding data compression.(…)

Load More