Blog on Power BI, Power Apps, Azure, SQL Server, BI, and more! | Alan Faulkner

Skip to content

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.

Azure Every Day, Azure Analysis Services, Azure Monitor, Azure Log Analytics

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 [...]

Alan Faulkner

Alan Faulkner July 31, 2020

Azure, SQL Server Management Studio, Azure Every Day, Azure Analysis Services, SQL Profiler Trace

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 [...]

Alan Faulkner

Alan Faulkner July 21, 2020

Azure, Azure Every Day, Azure Analysis Services, Server Monitoring Tools

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 [...]

Alan Faulkner

Alan Faulkner July 15, 2020

Using the SQL Database Query Editor in the Azure Portal

SQL Server Management Studio, Azure Every Day, Azure Portal, SQL Database Query Editor

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 [...]

Alan Faulkner

Alan Faulkner August 29, 2019

Intro to Azure Functions

Azure, Azure Every Day, Azure Functions

Introduction to Azure Functions

If you don’t know about Azure Functions, I’ll tell you here how they can make development more productive and how they are a [...]

Alan Faulkner

Alan Faulkner November 7, 2018

Copy of SQL Advanced Threat Protection - Threat Detection for Azure Databases

Azure, SQL Server, Azure Every Day, Azure Database, Advanced Threat Protection, Database Security

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 [...]

Alan Faulkner

Alan Faulkner October 29, 2018

SQL Advanced Threat Protection - Vulnerability Assessment (1)

Azure, Azure Every Day, SQL Database, Advanced Threat Protection, Security and Management

SQL Advanced Threat Protection - Vulnerability Assessment

Security for your databases is, or should be, a top priority. Today I want to tell you about the SQL Vulnerability [...]

Alan Faulkner

Alan Faulkner October 26, 2018

Azure Threat Protection for Azure SQL Database - Data Categorization (1)

Azure, Azure Every Day, Azure SQL Database, Advanced Threat Protection

Azure Threat Protection for Azure SQL Database - Data Categorization

Threat protection and managing sensitive data is of utmost importance today. In this post, I’ll discuss Azure Threat [...]

Alan Faulkner

Alan Faulkner October 17, 2018

Advanced Threat Protection for Azure SQL Database

Azure, Azure Every Day, Azure SQL Database, Advanced Threat Protection

Advanced Threat Protection for Azure SQL Database

Keeping your database protected is of utmost importance. In today’s post, I want to introduce the Advanced Threat Protection [...]

Alan Faulkner

Alan Faulkner August 16, 2018

Migrating SQL Database On-Prem to Azure SQL Database

Azure, Azure Every Day, Azure SQL Database, Database Migration Assistant, SQL Database

Migrating SQL Database On-Prem to Azure SQL Database

Are you looking to modernize your data platform by migrating your on-prem database to Azure? Azure’s Database Migration [...]

Alan Faulkner

Alan Faulkner July 31, 2018

Data Migration Assistant - Azure SQL Database (1)

Azure, Azure Every Day, Azure SQL Database, Data Migration Assistant

Data Migration Assistant - Azure SQL Database

In today’s blog/video I’ll walk through using the Data Migration Assistant to assess for migrating an on premises SQL Server [...]

Alan Faulkner

Alan Faulkner July 25, 2018

What is Azure SQL Data Warehouse_

Azure, Azure Every Day, Azure SQL Data Warehouse

What is Azure SQL Data Warehouse?

In today’s post, I’d like to review what an Azure SQL Data Warehouse is, as well as its benefits to performance and [...]

Alan Faulkner

Alan Faulkner June 19, 2018

SQL Server, Free Training, PII

Exposure Data Audit - Questions & Answers

As a BI Architect/Developer, it may become necessary to conduct an Exposure Data Audit to uncover Personally Identifiable [...]

Alan Faulkner

Alan Faulkner January 22, 2018

SQL Server, T-SQL, Power BI, SQL Server Management Studio, Power BI Desktop, SQL Server Integration Services

Exposure Data Audit - Locating Personally Identifiable Information (PII) in SQL Server

As a BI Architect/Developer, it may become necessary to conduct an Exposure Data Audit to uncover Personally Identifiable [...]

Alan Faulkner

Alan Faulkner January 15, 2018

SSAS Multidimensional or SSAS Tabular?

Determining whether multidimensional or tabular is the optimal solution for your organization is a key step when working [...]

Alan Faulkner

Alan Faulkner March 22, 2017

SSAS

SSAS Tabular vs. SSAS Multidimensional - Business Logic

Introduction In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the [...]

Alan Faulkner

Alan Faulkner May 29, 2015

SSAS

SSAS Tabular vs. SSAS Multidimensional – Part III – Complex Business Problems

Introduction In Part I of the SSAS Tabular vs. SSAS Multidimensional series, we began to set the stage for looking at 5 high [...]

Alan Faulkner

Alan Faulkner May 12, 2015

SSAS

SSAS Multidimensional vs Tabular - Part 2

Introduction In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the [...]

Alan Faulkner

Alan Faulkner April 7, 2015

SSAS

SSAS Multidimensional vs Tabular - Part 1

Have you been or are you currently working on a project where you are trying to determine which flavor of Analysis Services [...]

Alan Faulkner

Alan Faulkner March 27, 2015

8860e555-b413-4feb-99b7-320c0e09f43e-removebg 1

free events

Learn With The Nerds

A free virtual series bringing thousands of tech professionals together for a few hours covering an array of data analytics and cloud topics.

Join Now!