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

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

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

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

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

Statistics with TSQL and R: Chi Square Test

As I move on from descriptive and  largely univariate (one variable based) analysis of data into more multivariate data – one...

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

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

“Witch” Statistics?

Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three...