The capability to generate code with AI created a new fashion in the market: The Vibe Coding. Mocking and memes about vibe coding don’t stop people with limited technical knowledge—who may be unaware of the consequences—from doing it anyway. There is one good example about what vibe code actually means: There was a message from…… […]

This is something we expect to be simple, but it has a lot of secrets. Using parameters in DAX queries is essential, as any other query: The parameter transfers the filtering to the server side instead of the report side and optimize the report performance. However, DAX queries have many secrets to use parameters. If…… […]

The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation in SQL Databases. These features are slated to be a part of SQL Server 2025 as well. Let’s analyze some practical uses of these features. Creating and using a JSON column Before this new field…… […]

I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability to track the queries back to a semantic model, report and visual in a report, identifying the query lineage. If you check the text of the queries, at the end of the text you will find content like…… […]

Rate limit is common when consuming API’s: They control how many calls you can make in an interval of time. I faced one challenge with the rate limit recently: Out of the blue, the rate limit started to be reached. Why it was out of the blue and random I will not include here in…… […]

You may have already discovered the 4 special views the lakehouse has in the queryinsights schema to track query performance. I made a video about the lakehouse special tables, but since then, they evolved a lot: Let’s discover what these tables have to offer for us to analyze the lakehouse performance. exec_requests_history and performance metrics…… […]

A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about some advanced features available in both of them. Before analysing these advanced features, we need to understand some concepts about vectors and embeddings. Embeddings Concepts Creating embeddings is the process of creating vectors for documents…… […]

Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how to make a query to a SQL Endpoint. We use notebooks to connect directly to lakehouse. Except by the T-SQL notebook, the notebooks have a default lakehouse and work directly with it from spark. However,…… […]

I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided sample code about it. However, there is one problem: All the maintenance execution should be avoided over shortcuts. The tables require maintenance in their original place. According to our solution advances, we start using shortcuts, lots of them….… […]

Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new feature. This feature seems simple, especially for everyone who already knows about Azure SQL. However, we don’t need to dig too deep to discover the small secrets this feature has. Secrets that can easily cause mistakes with bad…… […]