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.
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:
Synapse Analytics
Many CTAS Sintaxes with the table configuration
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.
Parquet to SQL Type Mapping
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
Parquet complex types
This link is a blog post with interesting examples of parquet complex type, using a public blob storage for that
COPY INTO and public example of PARQUET complex types
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
External tables and URI format reference
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
More URI format reference for external tables
This other link contains reference for many kinds for external sources, Oracle, Teradata and more
Create external table as select
This is the reverse of the most famouse cousing, CTAS. Instead of loading data, we can use this syntax to export data.
Storage access with credentials
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
Azure Monitor, Log Analytics and more
Resource Manager Templates for Log Analytics
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.
Application Insight Workbooks
This link is a github repo full of workbooks built to provide management information about many azure services
https://github.com/microsoft/Application-Insights-Workbooks
Resource Manager Templates for Workbooks
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
Programatically Manage Workbooks
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.
Powershell
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.
Remove a Powershell object property
https://lazywinadmin.com/2017/06/Remove_PSObject_Property.html
Add-Member
https://ss64.com/ps/add-member.html
https://community.idera.com/database-tools/powershell/ask_the_experts/f/learn_powershell_from_don_jones-24/13052/adding-new-values-to-a-psobject
https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/add-member?view=powershell-7&WT.mc_id=DP-MVP-4014132
Array of Custom Objects
https://stackoverflow.com/questions/17353797/how-to-initialize-an-array-of-custom-objects/17354800
Add Many properties
https://stackoverflow.com/questions/51620654/can-i-create-a-custom-powershell-object-with-an-array-property
https://stackoverflow.com/questions/36200749/how-do-you-add-more-property-values-to-a-custom-object
Real-Time Twitter sentiment Analysis in Azure Stream Analytics
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-twitter-sentiment-analysis-trends?WT.mc_id=DP-MVP-4014132
Billing
Billing Permissions on Azure
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
Azure Comsumption Insights
This link explains how to user Power BI to access Azure Comsumption Insights API to manage Enterprise Agreement azure subscriptions
Azure Cost Management App
This link explains how to use Power BI Azure Cost Management Application to manage Azure billing. This application is exclusive for enterprise agreement subscriptions
Azure Enterprise Portal
The enterprise portal is used by companies with Enterprise Agreement contract. On this link you can learn details about the enterprise portal.
Azure Enterprise Roles
The roles used by companies with Enterprise Agreement contract are different than the roles used by companies with customer agreement. The link below explain these roles
Load comments