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-07-05 (first published: 2021-06-04)
509 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,132 reads
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2021-02-17
7,611 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.
2020-10-14
1,917 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 […]
2020-11-04 (first published: 2020-10-09)
2,777 reads
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
2,742 reads
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
1,527 reads
Learn how to remove TDE from a database and return it to a normal state.
2020-08-26
3,303 reads
Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CALCULATE() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to CALCULATE(), focusing largely upon its most basic uses in evaluating an expression in a context that is modified by specified filters.
2020-08-12
2,253 reads
Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]
2020-07-01
1,348 reads
New blog post - Architect a disaster recovery for SQL Server on AWS: Part...
New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I'm pretty new a creating JSON output form SQL server. I'm having trouble with...
I'm looking for some suggestions on how to create a delta file that will...
Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful as...
Ask SSC