I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.

The Learning Choice

by Steve Jones

SQLServerCentral.com

Editorial

R or Python? Or both? Neither? Where should you spend your learning effort?

Memory profiling in Python with tracemalloc

by Additional Articles

SimpleTalk

Python

You can find memory leaks in Python code with tracemalloc. In this article, Priyanka Nawalramka demonstrates how to use tracemalloc to find the leaks.

Simple Reporting with Flyway and Database Models

by Additional Articles

Redgate

Vendors/3rd-party Products

If you can generate a file-based (JSON) model for each new version of a database, produced by a Flyway migration, then you have an easy way to run simple reports to help you search, list, and understand the structure of these databases. I'll show how to produce the models using PowerShell and then run some queries against them to generate the reports.

It's Not Yours

by Steve Jones

SQLServerCentral.com

Editorial

We may talk about our databases, but hopefully most of us know we don't own the data.

Permissions and Security in Dynamic Data Masking - Step 4 of the Stairway to Dynamic Data Masking

by Steve Jones

SQLServerCentral.com

Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.

Oracle optimizer removing or coalescing subqueries

by Additional Articles

SimpleTalk

Oracle

The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations involving subqueries.

Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform

by Additional Articles

Redgate

Vendors/3rd-party Products

SQL Prompt users can now share formatting style or code snippets in designated Team spaces on the Redgate Platform. Louis Davidson explains how it works.