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

Where is your Awesome?

Everyone of us is in a perpetual pursuit of awesomeness - some actively looking for it, while others passively. Either way, it is inherent in our making to reach...

2020-09-11 (first published: )

392 reads

Blogs

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)

By

Welcome to a new year, and a new look at what I’ve learned in...

Azure SQL vCore vs DTU

By

If you are building database solutions in Azure , using Azure SQL Database then...

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...

Read the latest Blogs

Forums

Deadlock - What to do next?

By krypto69

Hi, I have a job that keeps getting a deadlock victim error and  fails....

XML Vs Non-XML

By IT researcher

I am using SQL Server 2008 R2. While using XML data type and  XQuery...

Staging or UAT Environment

By VastSQL

Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers