ReadyRoll for Database Deployments

This is the 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need...

Making sense of Microsoft technology

In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with...

xSQL Schema/Data Compare database list is empty

Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0

Summary: When adding databases to the workspace both in xSQL Schema Compare...

xSQL Schema/Data Compare database list is empty

Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0

Summary: When adding...

Future DBA – Hadoop Big Data

As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to...

A quick fix for a full identity column.

A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...

Associative Statistics – One sample T-Test with TSQL and R

In this post am going to attempt to explore a statistical procedure called ‘One Sample T Test’.
A T-Test is used...

Learn Basic SQL in 30 minutes

This article is for those who have no idea about Sql and I will be giving them a start point...

SQL 2016 - Configuration Manager Not Showing in Start Menu

Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...

Azure SQL Data warehouse

For this blog post I want to show you the steps required to setup an Azure SQL Data warehouse and...