Additional Articles


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

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

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Top Azure Synapse Analytics and Power BI questions

By

I have listed below the top questions I see from customers about Azure Synapse...

Pre-Conference Workshop and Sessions at PASS Summit

By

I’m pleased to announce that I will be presenting at PASS Summit. This year...

Read the latest Blogs

Forums

Index scan

By hello.priyanka

Hi, I have a query as below: ;With P As (Select ProductID --Query that...

why cannot use ClientProcessID to trace data in SQL Server Profile.

By 892717952

A C/S system is running on a SQL Server database, and I get its...

Copying an Azure SQL Database with PowerShell

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Copying an Azure SQL Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers