Nonclustered columnstore index quick test on SQL Server 2016

For those of us who's been following the development of Columnstore index since SQL 2012, it's been quite an exciting and viable feature that can truly help businesses gain significant queries performance and data compression.

Replicate to SQL Server Azure IaaS

Replication is one great way to have On-Premise data being periodically transferred to servers that's hosted on the Cloud. Especially since infrastructure cloud hosting is gaining popularity as businesses start moving non-critical workloads such as reporting servers, development environments, etc. in an effort to reduce CAPEX.

Hi, I am Ian Choy SH


I currently live in Kuala Lumpur, Malaysia with my family, a dog name Freckle and several cardinal tetras and mollyfishes.

I enjoy dabbling in technology particularly in areas related to data and cloud platform.

In my spare time I enjoy competitive PC gaming, badminton, traveling & watching Netflix.

Seach By Tags