Microsoft Azure hack for social justice
An invitation to Microsoft’s social justice hackathon and ideas for technology projects that can support justice.
Continue readingBrowse the archive
Cloud
How To Fix High DTU Usage on Specific Query
Question I have a query that runs every few seconds on a Microsoft SQL Azure Database. It is from a web job that checks if there are actions that need to be done based on rows in a specific table (its a queueing table). Based on the image attached, does …
Continue reading
Webinar: Azure SQL DB Managed Instance--A New Path to the Cloud
On October 2, 2018 at 11PM EDT, I’ll be joined by John Q. Martin (blog) for a webinar on Azure SQL Database Managed Instance. To sign up, register here. You can access the recording of the session here.
Continue reading
What the heck is a DTU?
In this post, I explain Azure SQL Database DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.
Continue reading
Building a Twitter-bot RSS Aggregator
I hate RSS readers I love my new bot For some reason, about once a year, I go hunting for a new RSS reader so I can keep track of blogs that I like to read. It’s always the same process:
Continue readingCannot restore azure database to local due to missing master key
Question I create a bacpac from azure and restore to my local on-prem server. However, it throws an error like “Please create a master key in the database or open the master key in the session before performing this operation”. The reason is one of the column …
Continue reading
TSQL Tuesday #85: Backup + Recovery + ☁️
It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog) started. This month’s episode is hosted by Kenneth Fisher (blog). The topic: Backup & Recovery ## Your backups are my bread & butter Backup & recovery are a DBA's bread & butter. I …
Continue reading