Product has been added to your cart.

Microsoft Azure

Breaking News, Literally: SQL CLR Support Removed from Azure SQL DB

Brent Ozar
Breaking News, Microsoft Azure
14 Comments
In the on-premises, boxed-product version of SQL Server, you can build your own CLR assemblies and call them from your T-SQL code. For years, this feature was missing from Azure SQL DB – Microsoft’s platform-as-a-service database offering – and users voted that they wanted it. In December 2014, Microsoft brought SQL CLR code to Azure SQL…
Read More

Enabling Query Store in Azure SQL Database

Jeremiah Peschka
Execution Plans, Microsoft Azure, Query Store (QDS)
6 Comments
Enter Query Store Query Store, in short, is a way to track query performance over time. In Microsoft’s words, “The feature automatically captures a history of queries, plans, and runtime statistics, and retains these for your review”. It’s like sys.dm_exec_query_stats but it persists across reboots! And it has execution plans! The Query Store is a…
Read More

When Did My Azure SQL Database Server Restart?

Brent Ozar
Microsoft Azure, SQL Server, Wait Stats
21 Comments
In Azure SQL Database, no one can hear you scream query common system objects that tell you when a restart happened. You don’t get the access you need to sys.dm_os_sys_info, sys.dm_exec_sessions, sys.traces, or sys.databases. The closest I’ve been able to get is to query sys.dm_os_wait_stats for several common wait types that seem to correspond with…
Read More
BSOD-T

SQL Azure Frequently Asked Questions

Brent Ozar
Microsoft Azure
42 Comments
On Monday 2/1, SQL Azure goes commercially live.  Microsoft’s charging for service now, and that means it’s officially official. I talk to a lot of enterprise DBAs, project managers, and developers about SQL Server in the cloud.  Here’s some of the questions I get asked most often. What is SQL Azure? SQL Azure is Microsoft’s…
Read More

Playing Around with SQL Azure and SSMS

Brent Ozar
Microsoft Azure
11 Comments
The latest build of SQL Server Management Studio for SQL 2008 R2 includes built-in support for SQL Azure.  The November CTP is still only a feature-complete preview, not a release candidate, so don’t go installing it willy-nilly on your production desktop. To use this, you’ll need a SQL Azure account.  You can register for an…
Read More

Microsoft SQL Azure: The Flat Pack Database

Brent Ozar
Microsoft Azure
8 Comments

Erika’s friends call her “Fancy Feast” because she only likes the best things in life. She’s got champagne tastes, but we can’t afford to buy the best of everything. I recently picked up a coffee table from Ikea, and it got me thinking about SQL Azure.

In a perfect world, I’d have on-premise SQL Server for every database. I’d use cutting-edge storage and cluster everything. But this isn’t a perfect world…

Read More

Sky Blue Screen of Death

Brent Ozar
Microsoft Azure
1 Comment
I don’t have anything insightful to add, but Microsoft’s Azure cloud service suffered its first nearly day-long outage.  I have this vision of looking up to the clouds and seeing a giant BSOD, only with lighter colors. Might be the flu medicine, though.  I’ll be back in the game tomorrow or Wednesday.
Read More