Azure SQL DB

Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don’t know how long it’s been this way – could even be since the launch of Azure SQL DB Serverless – but I just now noticed it while helping a client with a slow query. When you view an…

On August 30, Azure’s Australia East data center had a big problem, affecting customers like Bank of Queensland and Jetstar. Here’s the timeline: 30 August 2023 @ 08:41 – Voltage sag occurred on utility power line 30 August 2023 @ 08:43 – Five chillers failed to restart 30 August 2023 @ 10:30 – Storage and SQL…

I’ve seen your search history. Let’s get you some answers. Is Azure SQL DB PaaS, IaaS, or SaaS? Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA. This also means that like a DBA, Microsoft will tell you “no” if you try to implement…

If you’ve got a database that doesn’t need to be on all the time, Azure SQL DB Serverless is in public preview now. It makes a lot of sense for those development databases you have to keep around, but don’t really want to pay for. If your database doesn’t get any queries for 6 hours,…

No no, April Fool’s was yesterday. Hear me out. Azure SQL DB’s feature limitations are a good thing. It doesn’t support everything that SQL Server supports, like CLR, cross-database transactions, database mail, linked servers, and OPENQUERY, but…frankly that feature-limitation page reads like a list of my favorite things to tell developers to avoid. You shouldn’t…

All it really means is, “Click Execute again, and you will be fine.” If I had a dollar for every time I saw this error message in SQL Server Management Studio: The connection is broken and recovery is not possible. The error says: The connection is broken and recovery is not possible. The connection is…

As you pay more for Business Critical Azure SQL DB servers, they’re supposed to get more storage throughput. The documentation on this is kinda hard to read, but boiling it down, for every core you add to a Gen5 server, you’re supposed to get 2,500 IOPs. That should scale linearly: insert speed should go up evenly with…