-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Roadie

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.

Global AI Bootcamp – Developing AI, responsibly

Global AI Bootcamp, Brisbane 2018

Yesterday, I attended the Global AI Bootcamp Brisbane (at the Precinct, Valley) along with nearly 100 other technology enthusiasts. The event was well organized by David Alzamendi of Wardy IT Solutions and Thiago Passos of SSW Consulting. I rocked up to the event hoping to… Read more

0 comments, 384 reads

Posted in SQL Roadie on 16 December 2018

Part 2: Predictive Modeling using R and SQL Server Machine Learning Services

Recap!

Part 1 of Predictive Modeling using R and SQL Server Machine Learning Services covered an overview of Predictive Modeling and the steps involved in building a Predictive Model. Using our sample dataset – Ski Resort rental data – we wanted to predict RentalCount for the year 2015, given the… Read more

1 comments, 2,785 reads

Posted in SQL Roadie on 18 November 2018

Part 1: Predictive Modeling using R and SQL Server Machine Learning Services

To R or not to R?

A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research, I found that R is regarded as more old-school and difficult to learn, but Python is more popular. It made perfect… Read more

5 comments, 244 reads

Posted in SQL Roadie on 12 November 2018

Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph

After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager to check out Cosmos DB, this is a great opportunity to familiarize yourself with the hottest No SQL database in the market. Cosmos DB is currently sitting pretty at Rank… Read more

0 comments, 2,322 reads

Posted in SQL Roadie on 1 October 2018

Azure Cosmos DB – Partition and Throughput

In my previous article Introduction to Azure Cosmos DB, I mentioned Partition and Throughput only briefly. Adopting a good partition scheme is quintessential to setting up your Cosmos DB container for elastic scaling and blazing performance. This article will take a closer look at these two aspects to help… Read more

2 comments, 1,953 reads

Posted in SQL Roadie on 5 August 2018

Introduction to Azure Cosmos DB

What is Azure Cosmos DB?

Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a globally distributed, highly scalable and performant multi-model database service built on Azure. It was built ground up with horizontal scalability and global distribution in view,… Read more

3 comments, 264 reads

Posted in SQL Roadie on 29 April 2018

Export data from Cosmos DB to SQL Server

Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read Microsoft documentation about Cosmos DB here or check out my blog about Introduction to Azure Cosmos DB. In its infancy, Cosmos DB was known as Document DB. Renaming was inevitable… Read more

1 comments, 303 reads

Posted in SQL Roadie on 29 April 2018

Live Query Statistics – SQL Server 2016

SQL Server Management Studio (SSMS) 2016 has a handy new feature to View Live Query Statistics. This feature also works when connected to a 2014 instance using SSMS 2016.

Why use it?

Previously, similar stats were available by doing so:

SET STATISTICS "Detail" ON;

With the new feature, the… Read more

0 comments, 111 reads

Posted in SQL Roadie on 7 March 2018

Because loyalty is a two-way street

Moving a dog to Australia with no money at hand

I always had plans to move to Brisbane, Australia, where my brother lived. After getting hitched, it was a long wait for my wife to be relieved from Central Government services before we moved to AU. With the way things… Read more

10 comments, 169 reads

Posted in SQL Roadie on 27 February 2016

Database Mail shutting down. Mail queue has been stopped.

DB mail in our production servers started acting up last week. We have SQL Server 2012 SP1. There were a couple of sets of symptoms. Following is what I did to get DB mail working again.

I hope you don’t spend 4 hrs like me to find a solution.

Symptom… Read more

0 comments, 96 reads

Posted in SQL Roadie on 27 July 2015

XQuery

In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE, it helps to keep code simple and clean. I use XML extensively in my code and many a time, I find myself looking up code, searching the internet or trying… Read more

0 comments, 174 reads

Posted in SQL Roadie on 27 March 2013

Retrieve unsaved query

I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I had not saved, or so I thought; and then I came up with this – was a life saver!

SELECT TOP 10 
EST.text
FROM sys.dm_exec_query_stats EQS
CROSS APPLY sys.dm_exec_sql_text(eqs.sql_handle) EST…

Read more

0 comments, 78 reads

Posted in SQL Roadie on 20 March 2013

Find tables which are most commonly used in Stored Procedures

When you start working on a new project, one of the important tasks as a database developer is to get used to the table names. Here’s a script which will help you identify the most commonly used tables (assuming that the most commonly used are the most important).

SELECT TOP…

Read more

0 comments, 71 reads

Posted in SQL Roadie on 4 April 2011