28 September 2020
28 September 2020

Why choose Oracle?

8
Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.… Read more
19 September 2020
19 September 2020

Introduction to DAX Financial Functions – Part 1

0
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.… Read more
15 September 2020
15 September 2020

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.… Read more
09 September 2020
09 September 2020

How to make classifying SQL Server data easier

Classifying the data within an organization is not just something nice to do. It’s critical for complying with regulations such as The General Data Protection Regulation (GDPR), California Consumer Privacy Act (CCPA), The Health Insurance Portability and Accountability Act (HIPAA), The Australian Privacy Act, and a host of other privacy laws enacted throughout the world. … Read more