Dennes Torres in Blogs

Dynamic Partitioning and a Simple Incremental Load

Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode("overwrite").format("delta").partitionBy("Year","Month","Day").save("Tables/" + table_name) Let’s consider we...

03 April 2024 2 min read

Robert Sheldon in MongoDB

Building MongoDB Aggregations in MongoDB Compass

In the previous article in this series, I demonstrated how to build and run an aggregate statement in MongoDB Shell....

02 April 2024 22 min read

Theory and design

Joe Celko in Theory and design

SQL Logic

In this article, I will discuss the history and thinking behind several types of logic that are typically associated with...

29 March 2024 13 min read

Blogs

Dennes Torres in Blogs

Creating a Single JSON File for Configuration using Notebooks

On the blog Fabric Notebook and Deployment Pipelines I explained a technique to keep notebooks configuration values in JSON files...

27 March 2024 2 min read

T-SQL Programming

Aaron Bertrand in T-SQL Programming

Pagination and ordering by large values

Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing...

25 March 2024 9 min read

Blogs

Louis Davidson in Blogs

Lies you should believe: There are no dumb ideas

When I was a brainstorming ideas for a series of posts, it took me back to a brainstorming session we...

22 March 2024 3 min read

Web

Aneesh Lal Gopalakrishnan in Web

Cloudfare Turnstile, A New Way To Prove You Are Real

This article describes the recommended way to integrate Cloudflare Turnstile into a React application. When I first heard...

21 March 2024 9 min read

Blogs

Dennes Torres in Blogs

Model Optimization: Available In MDX Property

Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and...

20 March 2024 3 min read

Theory and design

Joe Celko in Theory and design

Department of Redundancy Department

Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too...

18 March 2024 12 min read

Blogs

Sheila Romans in Blogs

The Benefits of Volunteering at SQL Saturdays

How it all started After attending PASS Summit in 2022 my husband set a goal to speak at as many...

14 March 2024 5 min read

Containers and Virtualization

Bravin Wasike in Containers and Virtualization

Kubernetes For Complete Beginners

Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment...

14 March 2024 32 min read

Blogs

Dennes Torres in Blogs

5 Secrets about Dataflows Gen 2

Dataflows Gen 2 are the new version of Power BI dataflows. There are so many changes in relation to the...

13 March 2024 5 min read

PostgreSQL

Ryan Booz in PostgreSQL

Transforming and Analyzing Data in PostgreSQL

In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued...

12 March 2024 20 min read

Database Administration

Aaron Bertrand in Database Administration

Get the most out of SQL Server Agent logs

If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent...

11 March 2024 6 min read

Blogs

Dennes Torres in Blogs

Reverse Creating the PBIP file from Source Control

On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to use the PBIP...

06 March 2024 3 min read

Opinion Pieces

Simple Talk Editor in Opinion Pieces

Writing your 2024 PASS Data Community Summit Submission

It is time again for the PASS Data Community Summit Call For Speakers. Some of you are very ready. You...

05 March 2024 10 min read

Goodness Woke in Cloud

Serverless Authentication methods in web apps.

Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional server-based authentication systems....

05 March 2024 24 min read

Career