Stairway to DAX and Power BI - Level 20: Time Intelligence – Date Functions: ENDOFMONTH(), ENDOFQUARTER(), ENDOFYEAR()

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the End of Periods: ENDOFMONTH(), ENDOFQUARTER(), and ENDOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.

Artificial Intelligence with Power BI

Get a brief introduction to using the AI features in Power BI.

SSIS Bad Habits: Decreasing SSIS Package Performance

This tip will explain some mistakes SSIS developers usually make when designing ETL and how they should be avoided to help improve performance.

Recursive Triggers

Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back

Learn how to control which SQL Server transaction will get rolled back when a deadlock occurs by using DEADLOCK_PRIORITY.

Migrating to Synapse

Deploy and Configure Azure SQL Managed Instance

This article covers how to deploy, configure and test the managed instance version of Azure SQL Database using the General-Purpose edition.

Upgrading SQL Server Central

It's time to look at an instance upgrade for SQL Server Central. Or is it? Steve shares some thoughts about the process and decision making.

Introducing the MySQL DELETE statement

In this article, I focus exclusively on the DELETE statement to help round out our discussion on the core DML statements in MySQL. Overall, the DELETE statement is fairly basic, but one that’s no less necessary to have in your arsenal of DML tools.

Automate Power BI desktop data model with a PowerShell script

Learn how you can use PowerShell to update the Power BI data model.