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
The problem with SQL Azure is that it’s not named SQL Azure. It used to be named SQL Azure, but in May of 2012 Microsoft announced that after 2 years of branding efforts they were going to put all their eggs into the Windows Azure basket. In doing so, SQL Azure became known as SQL Database. … Read more
I’ve been working with Windows Azure SQL Database (WASD) on and off for about three years. This past year I’ve been a bit more involved. I did the technical review of Pro SQL Database for Windows Azure last year. I also delivered a precon seminar along with Dandy Weyn (blog | @ilikesql), Grant Fritchey (blog | @gfritchey) and … Read more
Today is the final day for my SQL Azure blog series. These past few weeks I have been able to spend a lot of time with SQL Azure. The platform has come a long way in the two years time since I first started using it and doing presentations. I am very impressed with many … Read more
Yesterday we discussed one way to improve query performance in SQL Azure by making sure your statistics are kept up to date. In today’s penultimate post we look at another way to get information about your queries in SQL Azure: wait events. One of the first things I noticed that was missing from SQL Azure … Read more
Yesterday we looked at a handful of queries that you can use with the sys.dm_exec_query_stats system view to return information about the activity on your instance of SQL Azure. Today we will talk about one way you can help yourself to improve performance for your SQL Azure instance: updating statistics. If you check the list … Read more
