Recently I had trouble running and configuring a DB2 client installed on Windows XP and thought I'd share what went wrong and how to resolve the issue as it wasn't immediately obvious. The IT centre installed DB2 client on a remotely accessed Windows desktop but when I logged in I couldn't use the client. The first… Continue reading DB2 Client Configuration Issues
Author: Al Gulland
I am a Data Architect specialising in delivery data and analytical platforms.
Date Maths – SQL Server
This article is the first in a series that lists date functions and date manipulation calculations for leading database systems and this article looks at the first of those - Microsoft SQL Server. Please refer to the other articles in this series on DB2 and Oracle. Rather than providing a list of all possible calculations… Continue reading Date Maths – SQL Server
Limitations with using System Date part 1
Often in a reporting or data analysis scenario the analyst or business user wants to view data that is current, for example, sales for the current week or employee turnover for the current month etc. The analyst could create the report and then just enter whatever the current date is or in a operational report… Continue reading Limitations with using System Date part 1
Limitations with using System Date part 2
In the previous article we looked at why using System Date functions in a BI solution can lead to difficulties in development and testing. In this article we are going to look at several alternatives to using system date functions. Contents Problem Overview Creating a Query that Returns Current Data The Easiest Method The Max… Continue reading Limitations with using System Date part 2
Limitations with using System Date part 3
In the last article we looked at alternatives to returning the system date in the report queries. This article looks at the report and alternatives to using system date functions in report calculations Contents Problem Overview Creating a Query that Returns Current Data The Easiest Method The Max Date Method Flagging Today’s Date in the… Continue reading Limitations with using System Date part 3
Al Gulland 
You must be logged in to post a comment.