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

Hekaton Part 3: Table Creation and Parameters

Part of a Series on "Hekaton". Refer below for previous posts

Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...

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

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

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

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

SSIS Catalog – Path to backup file could not be determined

I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...

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