It’s kind of fun to see Azure development artifacts on display. I’ve posted about them before, a couple of times. I’m starting to finally get systematized about the whole thing, just so I can see stuff as it changes rather than discover them by accident or get told about them by someone else. Here’s a little query I’m running to see when system views were last modified:
SELECT av.name, av.create_date, av.modify_date FROM sys.all_views AS av ORDER BY av.modify_date DESC;
The most recent stack of changes are here:
I’ll keep an eye on them to see what I can spot about interesting new functionality.
I also compared the listing of all views in Azure to those on a SQL Server 2012 instance and came up with a list of differences. These are the system views that are only in Azure. The names are intriguing. Will we be getting extended events based on the sys.dm_xe_* views? Since the create & update dates on these is 1/1/2009, I’m of the opinion that development hasn’t moved forward a whole lot. What about slo_* views? Service Level Objective? They have create dates of 8/20/2013 and modify dates for 9/19/2013, so they’re new. Nothing to add other than the interest.
Here’s the list