BYO Time Zone Conversion With SSAS DMVs

This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...

This Week In Data – Episode 5 (Data Visualization Best Practices)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

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...