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