Browser tabs hold some similarities with tribbles in the way they multiply. Before you can notice, you have hundreds of them. However, in the same way tibbles are fluffy, browser tabs sometimes hold fluffy information as well, the kind of information you know you need but usually you are not sure where to hold it and may not be able to find it again.<\/p>\n
An interesting solution is share with all of you the best links open when my desktop ship get too floaded with them and transport the other ones to a klingon ship. Let’s see what I have today:<\/p>\n
This link has many CTAS (Create Table as Select) syntax examples, not only with simple queries but aggregations and more, besides also many different distribution examples.<\/p>\n
https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/sql-data-warehouse-develop-ctas?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n Synapse SQL Pool is very demanding about parquet data types. This link has details about the parquet data type mapping to SQL. However, there is something even better on this link: The address and query samples for public blob storages with data about the pandemic and the NYC Taxi sample<\/p>\n https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql\/query-parquet-files?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n <\/p>\n This link is a blog post with interesting\u00a0 examples of parquet complex type, using a public blob storage for that<\/p>\n https:\/\/techcommunity.microsoft.com\/t5\/azure-synapse-analytics\/easily-load-complex-data-types-with-azure-synapse-analytics\/ba-p\/1479676?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This is the documentation of the COPY INTO statement. Unlinke CTAS, in this case we can import data into existing table. COPY INTO also is extremely flexible in relation to the loading data options<\/p>\n https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/copy-into-transact-sql?view=azure-sqldw-latest&WT.mc_id=DP-MVP-4014132<\/a><\/p>\n There are many links about creating external tables, but this one is special: on this link you will find a very interesting explanation about the LOCATION setting, including what prefix you should use with each kind of blob storage<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql\/develop-tables-external-tables?tabs=sql-pool&WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This other link contains reference for many kinds for external sources, Oracle, Teradata and more<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-external-data-source-transact-sql?view=sql-server-ver15&WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This is the reverse of the most famouse cousing, CTAS. Instead of loading data, we can use this syntax to export data.<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-external-table-as-select-transact-sql?view=aps-pdw-2016-au7&WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This link contains details about how to access a private blog using SQL On demand and many different credentials: SAS, user identity and managed identity<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql\/develop-storage-files-storage-access-control?tabs=shared-access-signature&WT.mc_id=DP-MVP-4014132<\/a><\/p>\n <\/p>\n This link explain in details how to build an ARM template to create and configure a log analytics workspace. Each piece of configuration is explained, I used this link to help in automate the export of log analytics workspace to ARM templates. I will write about this later.<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/azure\/azure-monitor\/samples\/resource-manager-workspace?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This link is a github repo full of workbooks built to provide management information about many azure services<\/p>\n https:\/\/github.com\/microsoft\/Application-Insights-Workbooks<\/a><\/p>\n This link explains how to create an ARM template to install an Azure Monitor Workbook. Specially the type property is not so easy to find in documentations<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/azure\/azure-monitor\/samples\/resource-manager-workbooks?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This link explains how to create an ARM template to install an Azure Monitor Workbook template. The template will be available for the creation of new workbooks from it.<\/p>\n https:\/\/docs.microsoft.com\/en-us\/azure\/azure-monitor\/platform\/workbooks-automate?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n <\/p>\n Creating ARM templates involves manipulating JSON files. While building some script to manipulate and create ARM templates, I had the challenge to manipulate custom objects, creating or removing properties on the fly. These are references I found about it.<\/p>\n Remove a Powershell object property<\/strong> Add-Member<\/strong> Array of Custom Objects<\/strong> Add Many properties Real-Time Twitter sentiment Analysis in Azure Stream Analytics<\/strong> <\/p>\n You can delegate the task to manage billing information and maybe you should (I hate billing). These two links help with this, explaining how to give access to another user to manage billing and what are the existing roles in a customer agreement scenario<\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/azure\/cost-management-billing\/costs\/assign-access-acm-data?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n \nhttps:\/\/docs.microsoft.com\/en-us\/azure\/cost-management-billing\/manage\/understand-mca-roles?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This link explains how to user Power BI to access Azure Comsumption Insights API to manage Enterprise Agreement azure subscriptions<\/p>\n https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-connect-azure-consumption-insights?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n This link explains how to use Power BI Azure Cost Management Application to manage Azure billing. This application is exclusive for enterprise agreement subscriptions<\/p>\n https:\/\/docs.microsoft.com\/en-us\/azure\/cost-management-billing\/costs\/analyze-cost-data-azure-cost-management-power-bi-template-app?WT.mc_id=DP-MVP-4014132<\/a><\/p>\n <\/p>\n The enterprise portal is used by companies with Enterprise Agreement contract. On this link you can learn details about the enterprise portal.<\/p>\n\nParquet to SQL Type Mapping<\/h3>\n
Parquet complex types<\/h3>\n
COPY INTO and public example of PARQUET complex types<\/h3>\n
\nExternal tables and URI format reference<\/h3>\n
\nMore URI format reference for external tables<\/h3>\n
\nCreate external table as select<\/h3>\n
\nStorage access with credentials<\/h3>\n
Azure Monitor, Log Analytics and more<\/h2>\n
\nResource Manager Templates for Log Analytics<\/h3>\n
Application Insight Workbooks<\/h3>\n
Resource Manager Templates for Workbooks<\/h3>\n
Programatically Manage Workbooks<\/h3>\n
Powershell<\/h2>\n
\nhttps:\/\/lazywinadmin.com\/2017\/06\/Remove_PSObject_Property.html<\/a><\/p>\n
\nhttps:\/\/ss64.com\/ps\/add-member.html<\/a>
\nhttps:\/\/community.idera.com\/database-tools\/powershell\/ask_the_experts\/f\/learn_powershell_from_don_jones-24\/13052\/adding-new-values-to-a-psobject<\/a>
\nhttps:\/\/docs.microsoft.com\/en-us\/powershell\/module\/microsoft.powershell.utility\/add-member?view=powershell-7&WT.mc_id=DP-MVP-4014132<\/a><\/p>\n
\nhttps:\/\/stackoverflow.com\/questions\/17353797\/how-to-initialize-an-array-of-custom-objects\/17354800<\/a><\/p>\n
\nhttps:\/\/stackoverflow.com\/questions\/51620654\/can-i-create-a-custom-powershell-object-with-an-array-property<\/a>
\nhttps:\/\/stackoverflow.com\/questions\/36200749\/how-do-you-add-more-property-values-to-a-custom-object<\/a><\/p>\n
\nhttps:\/\/docs.microsoft.com\/en-us\/azure\/stream-analytics\/stream-analytics-twitter-sentiment-analysis-trends?WT.mc_id=DP-MVP-4014132<\/a><\/p>\nBilling<\/h2>\n
\nBilling Permissions on Azure<\/h3>\n
\nAzure Comsumption Insights<\/h3>\n
Azure Cost Management App<\/h3>\n
Azure Enterprise Portal<\/h3>\n