Recent Posts

0
Comments

Reporting Services - Parameters AND Filters nugget by MartinIsti

How to use interactive Filters in Reporting Services (2008)...
0
Comments

70-448 by MartinIsti

Almost 2 weeks ago (9 February 2010) I managed to take the 70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance exam! Hurray! It was quite good I mean I enjoyed taking it. I experienced some very tricky questions about the...
0
Comments

Unified dimension by MartinIsti

The reason behind this post is that I quite often meet the need for some little dimensions for certain cubes. Little now means that they consist of only a couple of attributes (like e.g. a Salesmethod dimension with two members: Reseller, Internet). These...
0
Comments

70-446 is done! :) by MartinIsti

Yesterday I tried myself in the 70-446 exam and I succeeded! It wasn't easy, wasn't fast and wasn't even relaxing but I liked it! I began it at 8 o'clock and finished it at noon and in the meantime I took only a short toilet-brake But...
3
Comments

NUMBER without Precision by MartinIsti

This week I experienced an annoying incompatibility between SQL Server 2005 and Oracle 9.2.2. If a column in Oracle has a NUMBER data type without explicitly set precision (like NUMBER(10)) then SSIS is not able to handle it when using an OLE DB Connection...
Filed under: , ,
0
Comments

70-445 is accomplished! :o) by MartinIsti

Hereby I present you the news of the week (for myself of course ) I sat to try the 70-445 exam once more this morning and I succeeded! I had been preparing since last december, read the training kit at least 4 times, looked through every test questions...
Filed under: ,
0
Comments

Oracle DATE vs SQL DATE by MartinIsti

During the development of a simple (or so we thought ) SSIS task a strange error came up: we had a dbtimestamp column from Oracle which we had to load into a SQL Server ( 2005! ) table. It was a transaction date so by default there shouldn't have...
0
Comments

False TEST questions in 445 Practice Tests? by MartinIsti

Last weekend I tried my knowledge with the practice tests of the 445 Training Kit. I enjoyed it because larger part of the questions was explained well in the book. But I've found 3 wrong answers. I've showed it to one of my friends and he has...
0
Comments

Books to read by MartinIsti

This post is mainly for fellow BI folks such as me who feel that they are only at the beginning of this road: First I show you what I've already read (or at least have learnt a lot from): The 70-445 Training Kit - it's a great book, teaches a...
Filed under: , , , , , , , ,
0
Comments

Training Kit is over by MartinIsti

Hi folks, This week I finished the Self-Paced Training Kit for 70-445 ( 2005 Business Intelligence—Implementation and Maintenance). I mainly read the digital version of the book (this way it was much easier to create notes and do the practice exercises...
Filed under: ,
0
Comments

INSERT values into IDENTITY columns by MartinIsti

Yesterday I had to recreate a table because it has different a column order in the DEV and in the TEST environment. Since it was too large to drag-and-drop column on the SSMS table design screen I had to use a very simple trick: script the table in SSMS...
0
Comments

Time hierarchy - desc order by MartinIsti

Yesterday I received the task to change the order of our time dimension from ASC to DESC. As easy it is in SQL that difficult it is in AS. Or so it seemed. First I tried looking for a solution among the properties. After finding nothing I began thinking...
Filed under: , ,
0
Comments

Little deployment utility (for DTUTIL) by MartinIsti

Today I did not want to use the package deployment wizard so I decided to automate a little our package deployment by using a batchfile with DTUTIL commands. I've created an Excel file with some expressions so the user just need to fill in some mandatory...
Filed under: , , ,
3
Comments

Star or Snowflake i.e., 1 or 2 Dim tables? by MartinIsti

Last week I had to design and sketch a more or less simple OLAP solution during which I had to face a certain dilemma. But before going into details I'd like to share some background. The OLTP source system is in Oracle: The first fact table row points...
Filed under: , , , ,
0
Comments

Kiwi's are welcome to write :) by MartinIsti

This won't be an SQL-related post so I'll be short: If I happen to have a reader from NZ I'd like to ask him/her to contact me via a comment or via email because I'd be interested in the NZ BI, datawarehouse market. Thanks!
Filed under: , ,
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems