Azure contains multiple services that can handle stream data. I can mention just few of them: Stream Analytics Data Explorer Synapse Spark Databricks The above list is not everything that you can use. If you want to have a solution that will minimize maintenance and simplify the entire process you can use PaaS services like […]
Latest Posts
Azure Synapse Resultset caching – how it works?
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 […]
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 […]
Last comments