Export data from Cosmos DB to SQL Server

• by Arjun-Sivadasan

• SQL Roadie

Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read Microsoft...

2018-04-29

423 reads

Introduction to Azure Cosmos DB

• by Arjun-Sivadasan

• SQL Roadie

What is Azure Cosmos DB?
Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a...

2018-04-29

354 reads

Live Query Statistics – SQL Server 2016

• by Arjun-Sivadasan

• SQL Roadie

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

2018-03-07

147 reads

Because loyalty is a two-way street

• by Arjun-Sivadasan

• SQL Roadie

Moving a dog to Australia with no money at hand
I always had plans to move to Brisbane, Australia, where my...

2016-02-27

212 reads

Database Mail shutting down. Mail queue has been stopped.

• by Arjun-Sivadasan

• SQL Roadie

DB mail in our production servers started acting up last week. We have SQL Server 2012 SP1. There were a couple...

2015-07-27

140 reads

XQuery

• by Arjun-Sivadasan

• SQL Roadie

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

Retrieve unsaved query

• by Arjun-Sivadasan

• SQL Roadie

I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I...

2013-03-20

98 reads

Find tables which are most commonly used in Stored Procedures

• by Arjun-Sivadasan

• SQL Roadie

When you start working on a new project, one of the important tasks as a database developer is to get...

2011-04-04

94 reads