UPDATE: GIVEN THE CURRENT SITUATION WITH COVID-19 THIS EVENT HAS BEEN POSTPONED. This week seems like a line of announcements, but mostly because they have been in works hidden for quite some time – on the 6th of May in…
Columnstore Indexes – part 131 (“Rebuilding Rowstore Indexes ONLINE”)
Continuation from the previous 130 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blogpost will be about older SQL Server versions (2016, 2017) and some implications that I have found that people rather do not understand, until they…
Delivering a precon on Columnstore Indexes at SQLSaturday Cincinnati 2020
UPDATE: GIVEN THE CURRENT SITUATION WITH COVID-19 THIS EVENT HAS BEEN POSTPONED. My first ever precon in the United States is already public and I am happy to share that on the 20th of March 2020 in the wonderful city…
Copying Data into a Table in Azure SQL DW (Synapse Analytics)
In this post I want to start conversation about copying data into Azure Synapse Analytics (SQL DW). Yes, as you expected there are multiple ways and besides some of the good old ones (such as a primitive INSERT INTO ……
Query Identification in Azure SQL DW (Synapse Analytics)
If you have been following this blog closely in the past month, you might have noticed that I have started blogging actively about the Azure Synapse Analytics (Azure SQL DW) lately – (Azure SQLDW Result Set Caching, Azure SQL DW…