SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Ziek's SQL Home

Ezekiel is an IT professional with over ten years experience in building database applications and BI solutions. He holds a BSc Computer Science degree from KNUST, Ghana and a MSc Business IT degree from Kingston Business School, London. He has delivered solutions for the Insurance, Banking, Telecom and Housing Industries and his key expertise include developing Microsoft BI solutions using the full stack and C#, Business Process Improvement and Project Risk Management. He is a Microsoft SQL Server Certified Professional.

How to retrieve Cell Properties from a SSAS MDX query using SSIS


This is a short article where I want to share something I discovered recently. I worked on an SSIS package where I had to query a SSAS cube using MDX and pass cell properties such as the VALUE and FORMATTED_VALUE down the data path to an output/destination file.

Problem Read more

0 comments, 1,547 reads

Posted in Ziek's SQL Home on 2 July 2016

How to Load XML Data Files using the SSIS Script Component.

One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then is XML source files. This is even truer given how common distributed systems have become and the need for applications from different sources and protocols to share data and communicate. Read more

2 comments, 6,981 reads

Posted in Ziek's SQL Home on 3 April 2016

Why the MS Power Query (PQ) for Excel is an invaluable Business Intelligence tool

Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings to the BI table. The Microsoft Power Query for Excel, previously the Data Explorer, provides a useful tool for gaining insights into data, data transformation and analysis.

The MS PQ… Read more

1 comments, 4,463 reads

Posted in Ziek's SQL Home on 19 August 2013

How to drop all tables in a SQL Server Database whose name begins with a common value


I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables for things like loading, parsing and data cleansing.  Let’s assume that as per your project or company’s database naming convention, these tables are all prefix with the name/value; “temp_”… Read more

0 comments, 1,838 reads

Posted in Ziek's SQL Home on 23 December 2012

SharePoint 2010 Setup Error

Sometimes in life things happen when you least expect them.  This was my experience some few weeks ago when I had to install SharePoint 2010 on a new server. I installed all the pre-requisites needed for this application and going forward  I was faced with a very strange error –… Read more

0 comments, 909 reads

Posted in Ziek's SQL Home on 13 November 2012

SQL Server 2012 – Enter the EOMONTH Function

In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End of Month) which is used to find or get the last day of a month in a specified date.

In prior versions of SQL Server 2012, date functions like “dateadd”… Read more

0 comments, 1,626 reads

Posted in Ziek's SQL Home on 2 August 2012



Read more

0 comments, 605 reads

Posted in Ziek's SQL Home on 10 June 2012

Data Quality; the road to Accurate Reporting

I am sure you have heard of the term; garbage in garbage out. This maxim is even more true when it comes to preparing, processing and analysing data for reporting purposes. In this blog post, I will focus on some of processes of data quality and then share some… Read more

0 comments, 843 reads

Posted in Ziek's SQL Home on 10 June 2012


These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around when to use any of these, I feel oblige to share and infact to also learn more from anyone out there.



This data is used for storing a… Read more

1 comments, 7,370 reads

Posted in Ziek's SQL Home on 28 May 2012

Slowing Changing Dimension (SCD) demystified – Part 3

I am wrapping up this series by finally considering the rarely used type 3 SCD.

( i.e.  in most business scenarios)

Unlike the Type 2 SCD, the type 3 SCD tracks only the current value and the original value of a dimension member.
Two attributes are normally used in designing… Read more

0 comments, 771 reads

Posted in Ziek's SQL Home on 22 May 2012

Slowing Changing Dimension (SCD) demystified – Part 2

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type II.  Let’s assume the table below holds historical info of call plans of a customer in the Telecom industry.

Historical information storage (As a row)

From the table above it… Read more

0 comments, 685 reads

Posted in Ziek's SQL Home on 4 May 2012

Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are three main scenarios namely Type I, Type II and Type III.

In this post, I will be discussing the Type I scenario and I promise to do the part… Read more

0 comments, 630 reads

Posted in Ziek's SQL Home on 3 May 2012