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, … Read more

Troubleshooting Azure Connectivity: Ports and Endpoints

can't connect to remote computer

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. Maybe you … Read more

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 … Read more

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. … Read more

Choosing The Cloud Solution Provider That’s Right For You

Choosing the right cloud solution provider that's right for you

It’s hard to talk architecture these days without a mention of the Cloud finding it’s way into the conversation. Everyone wants to know “is the Cloud right for me?” Unfortunately a lot of people have no idea what “cloud” truly means. Do some digging on what “cloud” means and you will find a lot of information. You … Read more

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

One of the things I love most about Windows Azure SQL Database (WASD) is that you don’t have many options when it comes to performance tuning. WASD makes you focus on code and design in order to maximize performance. I would estimate that 98% of all performance issues are due to sub-optimal code and database design … Read more