Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deploying Databases to the Azure Cloud: an extended plea Expand / Collapse
Author
Message
Posted Saturday, February 23, 2013 2:04 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: Administrators
Last Login: 2 days ago @ 1:22 PM
Points: 569, Visits: 1,033
Comments posted to this topic are about the item Deploying Databases to the Azure Cloud: an extended plea
Post #1423328
Posted Saturday, February 23, 2013 3:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 2:22 AM
Points: 22, Visits: 292
Tony,
I am not completely sure, but my guess is that the lack of extended properties on Azure might have something to do with the very complex metadata model Microsoft has adopted for SQL Server, and specifically how it manages resources and performance.
As we know, the metadata in SQL Server is spread out in several locations - there are base tables in the master database (these contain system-wide configs and metadata), there are some base tables tables in each database for its own metadata and settings, and there are some base tables in the resource database. In order to "get the show on the road" with the metadata, there are quite complex dependencies between the metadata stored in different places.
Hence, my guess is that it was much easier to leave behind some of the metadata features in Azure, just so the product can be rolled out to market (after all, the delay is big enough already).

And, by the way, the lack of extended properties in Azure is a relatively insignificant problem compared to other much bigger ones: performance, flexibility, supported data types, optimization and so on...


Feodor


Make everything as simple as possible, but not simpler.
Albert Einstein
Post #1423335
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse