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)
716 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,320 reads
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2021-02-17
7,984 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.
2021-09-24 (first published: 2020-10-14)
2,775 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,911 reads
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
2,834 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.
2021-09-15 (first published: 2020-09-02)
2,247 reads
Learn how to remove TDE from a database and return it to a normal state.
2020-08-26
3,826 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.
2021-09-08 (first published: 2020-08-12)
3,547 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,390 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I work on sql server 2012 i need to get featurekey and feature value...
Hi I have a very large database (600GB) that I am looking at creating. ...
Hi, I have a job that rebuilds indexes after a refresh of a replicated...
Ask SSC