I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation, performance tuning and troubleshooting.
Welcome to the final installment of my mini-series on Azure Analysis Services monitoring. My first session discussed monitoring tool options, the Analysis Services engines and how queries are process. Session 2 was a review of how to use OLAP Profiler Traces to capture data and evaluate events to enable us to monitor server and Analysis Services database activity.
Welcome to the second part in my series on Azure Analysis Services monitoring. In part one, I covered what makes up the Analysis Services engines (Tabular and multi-dimensional) and how each engine processes queries, as well as monitoring tool options.
There are several different tools to help you monitor and tune the performance of your Azure Analysis servers. In this mini-series, I’ll explore some of the options available that range from monitoring the health of Azure Analysis Services servers to profiling data for SQL Server Analysis Services Tabular multi-dimensional.
Azure offers many features and services, so if you’re new to Azure and the Azure Portal there is a lot to learn. One feature in the Azure Portal is the SQL Database Query Editor. Here I’ll teach you how it is possible to execute queries in the Azure Portal when we don’t have access to SQL Server Management Studio (SSMS).
Database security is of utmost importance and today I’d like to tell you about Advanced Threat Protection for Azure Database. SQL Advanced Threat Protection (ADP) is a unified package for advanced SQL Server and security capabilities that can be accessed and managed via the central ADP portal.
Security for your databases is, or should be, a top priority. Today I want to tell you about the SQL Vulnerability Assessment capability as part of the SQL Advanced Threat Protection (ATP) offering, which is a unified package for advanced SQL security.
Threat protection and managing sensitive data is of utmost importance today. In this post, I’ll discuss Azure Threat Protection for Azure SQL Database, specifically about the data discovery and classification capability.