In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
2024-01-20 (first published: 2024-01-17)
1,044 reads
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
2024-01-20 (first published: 2023-12-13)
1,205 reads
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: TOTALMTD(), TOTALQTD(), and TOTALMYD(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-16 (first published: 2023-09-27)
804 reads
In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.
2023-10-16 (first published: 2023-09-13)
2,311 reads
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: CLOSINGBALANCEMONTH(), CLOSINGBALANCEQUARTER(), and CLOSINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-16 (first published: 2023-08-30)
725 reads
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: OPENINGBALANCEMONTH(), OPENINGBALANCEQUARTER(). and OPENINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-16 (first published: 2023-08-23)
1,306 reads