In this level of the Stairway to ScriptDOM, we examine the way the tool parses scripts and creates tokens from the text.
2023-02-22 (first published: 2022-04-13)
4,688 reads
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,475 reads
2023-02-22 (first published: 2022-02-28)
2,488 reads
Learn how you can configure a Snowflake account in your cloud database and load data.
2025-06-13 (first published: 2021-12-01)
2,584 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.
2024-01-16 (first published: 2021-06-04)
2,625 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.
2025-06-13 (first published: 2021-05-24)
4,006 reads
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,572 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.
2024-01-16 (first published: 2020-10-14)
4,895 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,746 reads
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
3,597 reads
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Comments posted to this topic are about the item A Place where AI Technology...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers