Browse the archive
Photo via unsplash Microsoft is going to be running a virtual hackathon, running from October 12 through November 20. The theme of the hack will be to use Microsoft Azure to address some social justice issue. I’m thrilled to be joining the judging panel for …
Continue readingQuestion 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 readingNo, seriously. What is a DTU? When you’re deploying any application, one of the first questions that comes up is “What will this cost?” Most of us have gone through this sort of exercise for sizing a SQL Server installation at some point, but what if you’re …
Continue readingI 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: Dig through reviews to find an app that I think I will love. Come up with …
Continue readingQuestion 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 readingIt’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery ## Your backups are my bread & butter Backup & recovery are a DBA's …
Continue reading
