The History of War Analyzed

War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since 1900 till date to get an understanding of how things have changed. The below chart shows the duration in years on the x axis and the count…

SSIS – Starter kit for the uninitiated Data Flow Task

In this post we explore how to use the DFT (Data Flow Task) to load data from an XML file into the database. For previous post on how we got till this step please click here. Step Screenshot Double Click and open the DFT we had added in the previous post. Drag and Drop an…

SSIS – Starter kit for the uninitiated – Foreachloop

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS…

Training DBA from other countries

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind. Time zones- lunch breaks are different for different people. Office hours – Availability of daylight usually impacts office hours and typically there is a difference…

Part 2 Buffer pool extension SQL 2014

In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it encounters memory pressure. To this end we have created a table that is little more than 2 GB in size and have set out SQL server buffer…

Conditional Flow using SSIS Expression task

One common usage for the expression task in SSIS is to implement conditional flow of the constraints. In the below screenshot you can see that we implement an expression tasks which follows an error checking activity and evaluates if there were any errors , if yes the execution move to the right else to the…

Why BI professionals should believe in Aliens

I am pretty serious about this one, not because I believe in UFOs or any other extra-terrestrial theory but because as a DBA who implements Business Intelligence solutions for companies it’s hard to ignore the facts. Business Intelligence systems are all about identifying patterns and sets within existing data. When performing data mining we split…

Why I Train

It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings from former participants who have taken the time to get back to me I have mentioned one such email below. Hi Jayanth,  This is Raja from Cognizant…

SSAS: Processing Options

In previous posts we have already covered why processing the cube is important, in this post we look at the various processing options available within Analysis Services. The below table has been reference from the MSDN website and neatly outlines the different options and the scenarios in which they are applicable. Usually process default works…

SSAS: Processing Options

In previous posts we have already covered why processing the cube is important, in this post we look at the various processing options available within Analysis Services. The below table has been reference from the MSDN website and neatly outlines the different options and the scenarios in which they are applicable. Usually process default works…