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
5,957 reads
Stairway Series
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.
2020-10-14
1,626 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 […]
2020-11-04 (first published: 2020-10-09)
2,700 reads
Stairway to Advanced T-SQL Level 10: Using Scalar Functions
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
2,657 reads
Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function
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,425 reads
Removing TDE from a Database: Level 4 of the Stairway to TDE
Learn how to remove TDE from a database and return it to a normal state.
2020-08-26
2,878 reads
Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics
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,931 reads
Stairway to U-SQL Level 22: Creating a Custom Extractor
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,285 reads
Configure Extensible Key Management Using Azure Key Vault - Level 3 of the Stairway to TDE
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
2020-06-24
1,704 reads
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
2,296 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Query store index rebuilds
Recently we experienced a sudden surge in disk I/O every twenty minutes or so....
Group Managed Service Accounts for SQL Server 2017/2019
We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...
How to rewrite sql query after where condition with another query more arranged
I work on sql server I need to rewrite statement after where statement so...
Ask SSC