Stairway to ScriptDOM Level 1 - An Introduction to ScriptDOM
Get an introduction to the Stairway Series and learn about the power of the ScriptDOM library.
2023-02-22 (first published: 2022-03-09)
7,964 reads
Stairway Series
2023-02-22 (first published: 2022-02-28)
2,633 reads
Stairway to Snowflake Level 3 – Configure Snowflake with Your Cloud Account
Learn how you can configure a Snowflake account in your cloud database and load data.
2025-06-13 (first published: 2021-12-01)
2,731 reads
Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.
2021-06-04
2,776 reads
Stairway to Snowflake Level 2 – Create a Snowflake Account
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
2025-06-13 (first published: 2021-05-24)
4,156 reads
Stairway to Snowflake Level 1 - An Introduction to Snowflake
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2025-06-13 (first published: 2021-02-17)
11,921 reads
Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.
2020-10-14
5,076 reads
Stairway to Advanced T-SQL Level 11: Using Logical Operators
SQL Server supports a number of different logical operators. These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code. Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]
2022-04-20 (first published: 2020-10-09)
3,838 reads
Stairway to Advanced T-SQL Level 10: Using Scalar Functions
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
3,678 reads
Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.
2020-09-02
3,824 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers