Forgetting to shutdown your Azure environments and burning through a month’s worth of Azure MSDN credit if you’re lucky (and racking up a large credit card charge if you’re not) is a pretty common experience these days. Some might even call it a right-of-passage (like running a DELETE statement in […]
Read more →Posts Tagged ‘AzureAS’
At some point in the past couple weeks/months, the Azure Analysis Services team managed to expose a few more metrics to the Azure AS Monitoring / Metrics blade. Last I checked, there were only 2 metrics available… Memory and QPU… arguably two of the most important metrics to track as they […]
Read more →
In order to access a tabular model, users must either be a member of the Analysis Services instance administrators group or granted access via a database role. For on-premise SSAS instances, this meant adding the windows user account (e.g. Domain\User) to the SSAS database project via SSDT during development (or […]
Read more →Power BI is certainly picking up speed, but the number 1 ad-hoc reporting client in Analysis Services environments continues to be Excel. Not much of a surprise really… Excel is a super popular tool across a wide-variety of users. Once you train someone how to use a pivot table, there’s […]
Read more →One of the major value propositions of Azure AS (and this is true for many cloud technologies) is flexibility – spinning up more resources when demand spikes and turn things off when they aren’t – so that you’re only paying for what you need. In order to take advantage of […]
Read more →One of the major value propositions of Azure AS (and this is true for many cloud technologies) is flexibility – spinning up more resources when demand spikes and turn things off when they aren’t – so that you’re only paying for what you need. Consider your own Analysis Services environment. […]
Read more →This post contains a list of various methods that can be used to process (i.e. load data into) an Azure AS tabular model. As you will see – not much has changed from the regular on-premise version (which is a very good thing as it softens the learning curve). Note: […]
Read more →When brought in the perform a health check or performance optimization, one of the first steps in the process (after getting the perfmon and xevent traces running) is to document review the environment. In addition to the basics (i.e. CPU cores, GB of memory, clock speeds, etc) one item I’m […]
Read more →