Blog about Microsoft Data Platform and Azure cloud. #SQLServer #PowerBI #Azure #New
Today I would like to write few words about one of the most important techniques used to improve performance in your Lakehouse – two specific keywords: OPTIMIZE and ZORDER. Let’s start by introducing those two terms. The OPTIMIZE command in Delta Lake helps tidy up how data files are stored in a Delta table. It […]
In my latest post, I wrote a few words about the warehouses available within Fabric. Today, I would like to show you an end-to-end analytical scenario with the second most important item available on the platform, which is the Lakehouse. Microsoft’s Fabric Lakehouse serves as a cutting-edge data architecture platform that consolidates the storage, management, […]
One of the key components of Microsoft Fabric is Synapse Data Warehouse. This entity within the Fabric is specifically designed to facilitate the storage of data within the OneLake concept. It provides a seamless interface for interacting with the data through TSQL commands. If you were to consider Synapse SQL pools, such as Dedicated SQL […]
SQLDay is an annual conference that brings together professionals and enthusiasts from the field of relational databases and SQL. As a participant in this event, I can confidently say that SQLDay was an exceptional conference that exceeded all expectations and left a lasting impression on me. The conference, held over multiple days, showcased a diverse […]