Arjun Sivadasan

Hi, I am Arjun Sivadasan. I am a Data Engineering and Analytics manager with 14 years of experience. I have worked in various data-focused roles, developing and maintaining mission critical data-driven solutions in transaction and analytics environments. I am adept at mapping business goals to technology road map. Most of my work has been on data strategy, data architecture, data platform modernization and analytics. I enjoy speaking about databases and analytics at local user group events.
  • Interests: Cycling, Cooking, Motorbikes

Blog Post

XQuery

In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...

2013-03-27

218 reads

Blogs

Large System Databases on SQL Server

By

This one is an oldie in my blog drafts, but a goodie! So, I...

Free Advanced SQL Course for June: Don’t Miss Out!

By

Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...

How to give developers access to Query Store

By

Let’s have devs look at their own query performance. Yes, please, sign me up...

Read the latest Blogs

Forums

Factless Fact and Slowly Changing Dimensions

By pietlinden

I'm working on the same bakery problem... <g> Product--(1,M)--ProductIngredient--(M,1)---Ingredient Both Product and Ingredient are...

How to sum the CountDistinct in the detail rows

By danyeungw

The SSRS report has a CountDistinct in the detail row grouping by Facility. It...

Ledger Feature In Sql Server 2022

By rogue1009

Hi All, Wonder if someone can clear something up for me and let me...

Visit the forum

Question of the Day

The SQL Assessment API

What is the SQL Assessment API?

See possible answers