Dennes Torres in Other

SQL Endpoint Secrets you need to know

Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this....

29 January 2025 5 min read

Koen Verbeeck in General Analytics

Loading Models from Source Data with dbt

The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses...

20 January 2025 8 min read

Dennes Torres in Other

Fabric Copy Job: What’s new in it

At first sight, the new Copy Job may seem only one more redundancy: Why do we need this? We have...

15 January 2025 2 min read

Microsoft Fabric

Dennes Torres in Microsoft Fabric

High Concurrency Data Pipelines in Fabric

Data Pipelines can orchestrate many activities, creating a flow for data ingestion. One of these activities is the notebook execution...

08 January 2025 2 min read

John Kerski in Data Science

Comparing Groups for Similarities in Power Query – Using Cosine Similarity

I’ll admit upfront—I am not a data scientist by trade. Instead, I’ve picked up my data science skills over time,...

17 December 2024 7 min read

Koen Verbeeck in General Analytics

A gentle introduction to dbt

In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract...

10 December 2024 12 min read

Dennes Torres in Microsoft Fabric

Granting Permissions in a Fabric Data Warehouse and Lakehouse

We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses in Fabric. We...

04 December 2024 4 min read

Dennes Torres in Other

KQL: The top of a group in an easy way

When learning something new, we always compare it with what we know. In this case, we end up comparing KQL...

13 November 2024 3 min read

Dennes Torres in Other

Analyzing Kusto Query History in Fabric

We can consume a Kusto database in Fabric from many different places: Notebooks, semantic models, real time dashboards and more....

07 November 2024 5 min read

Dennes Torres in Other

T-SQL Notebooks: Manage Views Source Control and more

T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss the fact this...

31 October 2024 3 min read

Dennes Torres in Other

Shortcuts, Capacities and Costs : Some Considerations

Edit on 25/10/2024: According to some official documentations, there is an inaccuracy on this blog. The costs involved on data...

23 October 2024 3 min read

Microsoft Fabric

Dennes Torres in Microsoft Fabric

Using a Service Account in Microsoft Fabric

Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA...

16 October 2024 4 min read

Koen Verbeeck in BI

Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster

Power BI has been a leading data visualization tool in the market for years. It can be used as a...

11 October 2024 13 min read

Dennes Torres in Other

Cloud Connections in Microsoft Fabric

I wrote about cloud connections when they were in a very early stage. Cloud connections evolved and are now sharable....

09 October 2024 4 min read

Dennes Torres in Other

Debugging DAX with DAX Query View

DAX Query View was created some time ago and it was a great tool to run DAX inside Power BI...

25 September 2024 3 min read

Dennes Torres in Other

Infinity Notebook Loop in Fabric using Data Activator

Data Activator allow us to make an interesting workaround for infinity notebook executions. Infinity execution loop is interesting for constant...

20 September 2024 4 min read

Dennes Torres in Other

Data Activator: The secrets of monitoring alerts

Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and...

11 September 2024 2 min read

Dennes Torres

Microsoft Fabric and PySpark: Coding tricks to improve your solutions

PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked about loops before. Let’s...

04 September 2024 4 min read

Dennes Torres in Other

PySpark: The flexibility of a loop

Pyspark has many flexible syntaxes which are not so common to other languages. One of these syntaxes is the loop...

15 August 2024 3 min read

Dennes Torres

Microsoft Fabric: Using Lakehouse data in Real Time Dashboards

Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default it’s made...

08 August 2024 2 min read

Register for Simple Talk

Data Analytics

SQL Endpoint Secrets you need to know

Loading Models from Source Data with dbt

Fabric Copy Job: What’s new in it

High Concurrency Data Pipelines in Fabric

Comparing Groups for Similarities in Power Query – Using Cosine Similarity

A gentle introduction to dbt

Granting Permissions in a Fabric Data Warehouse and Lakehouse

KQL: The top of a group in an easy way

Analyzing Kusto Query History in Fabric

T-SQL Notebooks: Manage Views Source Control and more

Shortcuts, Capacities and Costs : Some Considerations

Using a Service Account in Microsoft Fabric

Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster

Cloud Connections in Microsoft Fabric

Debugging DAX with DAX Query View

Infinity Notebook Loop in Fabric using Data Activator

Data Activator: The secrets of monitoring alerts

Microsoft Fabric and PySpark: Coding tricks to improve your solutions

PySpark: The flexibility of a loop

Microsoft Fabric: Using Lakehouse data in Real Time Dashboards