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,119 reads
Learn how to remove TDE from a database and return it to a normal state.
2020-08-26
2,332 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
1,483 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,087 reads
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
2020-06-24
909 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
1,441 reads
In this level of the Stairway to Linux, learn how to use the TIG stack to monitor your SQL Server instance on Linux.
2020-05-27
764 reads
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
2020-05-20
1,436 reads
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
2020-04-29
2,285 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
5,970 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...
Hi All, I've got a nasty column that I need to get the name...
I'm struggling a bit here. It seems easy, but I 'm not getting it....
Ask SSC