In this level of the Stairway to ScriptDOM, we examine the way the tool parses scripts and creates tokens from the text.
2022-05-11 (first published: 2022-04-13)
1,123 reads
Get an introduction to the Stairway Series and learn about the power of the ScriptDOM library.
2022-05-11 (first published: 2022-03-09)
2,344 reads
This series looks at the ScriptDOM .NET library.
2022-04-05 (first published: 2022-02-28)
140 reads
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.
2022-04-05 (first published: 2021-06-04)
910 reads
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
2021-06-09 (first published: 2021-05-24)
2,863 reads
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.
2022-04-04 (first published: 2020-10-14)
3,499 reads
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,293 reads
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
3,032 reads