Additional Articles


External Article

Introduction to DAX Financial Functions – Part 1

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

2020-10-22

External Article

Dynamic Data Unmasking

The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.

2020-10-16

Blogs

Query Intelligence in SQL Server 2025: What Developers Need to Know

By

When Microsoft announced SQL Server 2025, I was curious about what would truly change...

Finding and Killing Blockers with Redgate AI Tech

By

Redgate has a research arm, called the Foundry, that has been experimenting with AIs...

Back at Small Data SF in 2025

By

Today I’m in San Francisco at Small Data SF 2025. I went to the...

Read the latest Blogs

Forums

Large posts full of code not allowed anymore?

By Lowell

Several times now, I've seen a post asking for a solution. I've replied, and...

Data > Hype

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data > Hype

Create and Read the Analysis Services Flight Recorder

By Pablo Echeverria

Comments posted to this topic are about the item Create and Read the Analysis...

Visit the forum

Question of the Day

Slipstream parameters

What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?

See possible answers