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

All authors

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

All authors

Blogs

AI Step 1

By

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

By

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Automating SQL Server 2019 Setup and Configuration Across Multiple Servers

By shellscripter

Hi everyone, I’m looking to automate the installation and configuration of SQL Server 2019...

Creating LS from IaaS to Paas using MFA

By gkramer 23701

Guys - I need your help on this.... I like to create an linked...

Doing a Little Research

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Doing a Little Research

Visit the forum

Question of the Day

The Funny SELECTs

What is returned from this query? 

SELECT
  ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
    WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;

See possible answers