Windows Azure Views

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

Sys.audits
Database_firewall_rules
Database_query_store_options
Dm_continuous_copy_status
Dm_db_objects_impacted_on_version_change
Dm_db_wait_stats
Dm_federation_operation_error_members
Dm_federation_operation_errors
Dm_federation_operation_members
Dm_federation_operations
Dm_xe_database_session_event_actions
Dm_xe_database_session_events
Dm_xe_database_session_object_columns
Dm_xe_database_session_targets
Dm_xe_database_sessions
Event_session_actions
Event_session_events
Event_session_fields
Event_session_targets
Event_sessions
Federated_table_columns
Federation_distribution_history
Federation_distributions
Federation_history
Federation_member_distribution_history
Federation_member_distributions
Federation_member_history
Federation_members
Federations
Query_context_settings
Query_store_plan
Query_store_query
Query_store_query_text
Query_store_runtime_stats
Query_store_runtime_stats_interval
Resource_stats
Resource_usage
Server_quotas
Slo_assignment_history
Slo_database_objectives
Slo_dimension_settings
Slo_objective_setting_selections
Slo_service_dimensions
Slo_service_objectives
Sysdac_instances