Alan Faulkner

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.

Monitoring in Azure Analysis Services (Part 3 of 3)

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.

Alan FaulknerMonitoring in Azure Analysis Services (Part 3 of 3)
Read More

Monitoring in Azure Analysis Services (Part 2 of 3)

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.

Alan FaulknerMonitoring in Azure Analysis Services (Part 2 of 3)
Read More

Monitoring in Azure Analysis Services (Part 1 of 3)

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.

Alan FaulknerMonitoring in Azure Analysis Services (Part 1 of 3)
Read More

Using the SQL Database Query Editor in the Azure Portal

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).

Alan FaulknerUsing the SQL Database Query Editor in the Azure Portal
Read More

SQL Advanced Threat Protection – Threat Detection for Azure Databases

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.

Alan FaulknerSQL Advanced Threat Protection – Threat Detection for Azure Databases
Read More