sqlroadie

Hi, I'm Arjun. I'm a Database programmer with over 10 years of experience designing and optimizing OLTP / transaction database systems. Of late, I have been focusing on Data Analytics. I presently work in the Data Analytics team at Oaks Hotels, Brisbane. Most of my work has been on SQL Server, but I have also worked on NoSQL databases such as CosmosDB and MongoDB, and Oracle. I am quite excited about the new Azure suite of products. My goal is to help organizations design scalable data frameworks and take decisions based on actionable data insights.
  • Interests: Cycling, Cooking

All authors

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

216 reads

All authors

Blogs

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

[Coping] Hidden Wounds

By

Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs

Forums

DAX how to rewrite this FILTER to CALCULATETABLE?

By ktflash

Ahoi,   i have been starting to look into DAX and there is something...

MYSQL ERROR - need desperate help

By Anth

Hi, Im having a problem with new players selecting a player class. Keep getting...

Execute As not reading system view

By pdanes

I have a stored procedure with the following: SELECT physical_name FROM sys.master_files Where physical_name...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

What hasn't changed?

See possible answers