We Don’t Trust This Data

“Learning to trust is one of life’s most difficult tasks.” –  Isaac Watts
As data professionals, there are times when our jobs...

Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table

Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...

PASS Board Update: July 2015

I was actually travelling for most of July and some of that was on holiday with the family, the real...

SSMS 2016 CTP 2.2 Setup Failure 0x81f40001

I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition). ...

Stranger Danger… The need for trust with constraints

I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....

Getting Started With Power BI Desktop: Installation

Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to...

Quick Script: Index Sizes

In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither...

Reblog: Slow source? Make your data flow buffers smaller!

Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...

Getting and storing a high precision datetime

Earlier today I was working on a project where I was recording some time stamps. In order to get as...

Interview question - Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-
 1) Can we create clustered index on a column containing duplicate values?

 2) Can we create...