20 November 2017
7 September 2017
MS_Description tag
In SQL Server (Database Engine) the extented property „MS_Description“ is known by Visual Studio with Data Tools.
The key and the value of a extended property can be created either by the stored procedure
This is rather usefull when coding against the objects as the value to MS_Description is shown as a popup:
As a DBA I have seen not only the developers benefit but also myself and operations as the description of a database or a object in a database is very near to the physical implementation itself. Also it is quite to collect the values automatic using the T-SQL function
This I reuse in azure through the tag key „MS_Description“. Unfortunately this tag key is not known in Visual Studio or Azure Dashboard. But still the tag value is direct available through the Tag attribute in PowerShell or another Azure tool. There are some guidance in the document „Use tags to organize your Azure resources“.
This still gives the same benefits as the SQL Server extended property as the prose description is very close to the physical object, e.g. a Resource Group or a virtual machine.
I would like to see this tag deeper implemented in Azure tools, but are still looking for a place to put such a suggestion. It looks like Azure is no longer active on Microsoft Connect.
When I have found the right place and posted the proposal then I will update this post…
Hmmm - Actually I have some problems tagging a resource. In the Azure Dashboard I get "Error adding tags - Unknown error occurred" and using PowerShell cmdlet Set-AzureRmResource I get "The pipeline has been stopped." and a more generic error. This is on different resource types.
The key and the value of a extended property can be created either by the stored procedure
sys.sp_addextendedproperty in a T-SQL statement or in SQL Server Management Studio as this:
This is rather usefull when coding against the objects as the value to MS_Description is shown as a popup:
As a DBA I have seen not only the developers benefit but also myself and operations as the description of a database or a object in a database is very near to the physical implementation itself. Also it is quite to collect the values automatic using the T-SQL function
sys.fn_listextendedproperty.This I reuse in azure through the tag key „MS_Description“. Unfortunately this tag key is not known in Visual Studio or Azure Dashboard. But still the tag value is direct available through the Tag attribute in PowerShell or another Azure tool. There are some guidance in the document „Use tags to organize your Azure resources“.
This still gives the same benefits as the SQL Server extended property as the prose description is very close to the physical object, e.g. a Resource Group or a virtual machine.
I would like to see this tag deeper implemented in Azure tools, but are still looking for a place to put such a suggestion. It looks like Azure is no longer active on Microsoft Connect.
When I have found the right place and posted the proposal then I will update this post…
Hmmm - Actually I have some problems tagging a resource. In the Azure Dashboard I get "Error adding tags - Unknown error occurred" and using PowerShell cmdlet Set-AzureRmResource I get "The pipeline has been stopped." and a more generic error. This is on different resource types.
Subscribe to:
Posts (Atom)