Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

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:

Views

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

 

Comments

Leave a comment on the original post [www.scarydba.com, opens in a new window]

Loading comments...