I have been working with Azure for a good number of years and felt that I wanted to share more of my experiences, since the migration to Azure (or to any cloud whatsoever) in the times of pandemic is growing…
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 ……
Sql Server 2019 Standard Edition Changes (Yeah, TDE-ah!)
The upcoming release of Sql Server 2019 which is largely expected to take place during PASS Summit 2019 & Ignite 2019 simultaneously (and given that Rohan Kumar (Microsoft VP) seems to be present only at the PASS Summit, I am…
Columnstore Indexes – part 128 (“Ordering Columnstore Indexes in Azure SQL Datawarehouse”)
Continuation from the previous 127 parts, the whole series can be found at https://www.nikoport.com/columnstore/. First of all and before everything else, I would like to extend my gratitude to Xiaoyu Li (Microsoft PM) for taking her time and exchanging long…
Columnstore Indexes – part 124 (“Estimate Columnstore Compression”)
Continuation from the previous 123 parts, the whole series can be found at https://www.nikoport.com/columnstore/. For anyone working with SQL Server since version 2005 (with Service Pack 2 to be precise) there is a very common task when thinking or research…