Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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/DW 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/DW solutions, .NET applications, Business Process Improvement and Project Risk Management. He is a Microsoft Certified Professional - MCTS: Microsoft SQL Server 2005 Implementation and Maintenance.

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, 2,382 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

Scenario

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,006 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, 373 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, 767 reads

Posted in Ziek's SQL Home on 2 August 2012

Testing

ziek


Read more

0 comments, 334 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, 455 reads

Posted in Ziek's SQL Home on 10 June 2012

NVARCHAR(n) Vrs NVARCHAR(max)

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.

 

NVARCHAR(n)

This data is used for storing a… Read more

1 comments, 2,535 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, 422 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, 324 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, 292 reads

Posted in Ziek's SQL Home on 3 May 2012