Stairway to ScriptDOM Level 3 - Finding Patterns in the Abstract Syntax Tree
Learn how you can query for patterns in the Abstract Syntax Tree to analyze your code.
2022-06-08
944 reads
Stairway Series
Stairway to ScriptDOM Level 2 - Parsing, Tokens, and the Abstract Syntax Tree
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,564 reads
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.
2022-05-11 (first published: 2022-03-09)
3,010 reads
2022-04-05 (first published: 2022-02-28)
308 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.
2021-12-01
1,414 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.
2022-08-09 (first published: 2021-06-04)
1,161 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.
2021-06-09 (first published: 2021-05-24)
2,955 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.
2021-02-17
9,047 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.
2022-04-04 (first published: 2020-10-14)
3,718 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,394 reads
Blogs
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation...
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
Forums
PASS Data Community Summit
Who's going to PASS Data Community Summit this year? It's been quite a while...
SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process
By Surendra Kumar Reddy Koduru
In this Article I’m going to demonstrate the heterogenous systems integration and building the...
Get addresses that match list of customers
Let's say i have a table with columns: cus_no, address, city, state, zip. How...
Ask SSC