Dedicated SQL Pool in Azure Synapse has a very interesting feature called result set caching. This mechanism is very specific to Synapse and it can significantly increase the performance of a query. In a nutshell, we can say that result set caching when enabled automatically cache query results for repetitive use. Because of this, any […]
Author: Adrian Chodkowski
Loading Azure Synapse Dedicated SQL Pool with COPY INTO
One of the hottest topics in the world of the Microsoft data platform is without any doubt Azure Synapse Analytics. It is a service that evolved from Azure Datawarehouse and is currently based on several pillars, where on the one hand we are dealing with Dedicated SQL Pool, i.e. a relational SQL engine operating in […]
Azure Synapse Link for SQL – how it works?
One of the most exciting things that have been announced during Microsoft Build conference was Azure Synapse Link for SQL. Previously there was the possibility to connect using Synapse Link to Azure Cosmos DB and Dataverse database but guess what – now it is available also for Azure SQL Database and SQL Server 2022. Let’s […]
Moja sesja na Microsoft Build 2022!
Nadszedł czas na kolejną konferencję poświęconą technologiom Microsoft – tym razem mowa o tegorocznej edycji Microsoft Build, która odbędzie się 24 i 25 maja. Czym jest ta konferencja? Myślę, że nie trzeba jej przedstawiać ale dla tych co nie wiedzą jest to coroczne darmowe wydarzenie organizowane przez Microsoft dla deweloperów. Podczas tego eventu z całą […]