Recent Posts

1
Comments

SSIS Nugget - from NULL to NULL but different datatype by MartinIsti

It's so simple yet I spent quite many painful minutes with that. The issue is that I have flat files to use as sources. They have 1 header row and 0 or more detail rows. Since I cannot divide the file in the connection manager for the header row ...
Filed under: , , ,
0
Comments

SQL Nugget - script content of a table as INSERT statements by MartinIsti

I have wrestled a couple of times what was easy when I used TOAD but became painful with SQL Server. For example you have a control table that is manually edited most of the times in DEV. When you want to move it to TEST you can transfer the whole table...
Filed under: , , ,
0
Comments

Service Account for processing Analysis Services cubes/databases by MartinIsti

Yesterday I worked onsite at a client with my boss to deploy an SSIS masterpackage. During the deployment it turned out that cube processing is an issue because it cannot be done using the SQL service account despite the fact that it's the same one...
0
Comments

Data transfer into CRM databases with SSIS by MartinIsti

Last Friday I received a task of loading some information from a data source (which can be a SQL table, a flat file, an Excel sheet...) into a CRM database. It cannot be done directly most of the times so a web service is need to be used. Since Microsoft...
Filed under: , ,
1
Comments

Visio drawing in SharePoint 2007 by MartinIsti

Yesterday I decided to improve a SharePoint site a bit by replacing the very basic navigation web part ( content editor web part with a 5x4 table that contains only text with hyperlinks and very far from being pretty) with something fancier. I decided...
0
Comments

T-SQL bits - ROW_NUMBER by MartinIsti

About a month ago I found the SQLShare site which provides useful, clear tutorial videos of how to use some SQL functions, or how to fine tune a query. Their videos are roughly 3-5 minutes long and have proved to be very good for me with a strong BI background...
Filed under: ,
7
Comments

SSRS Drillthrough for SSAS cubes, how to pass a parameter to an MDX dataset by MartinIsti

Yesterday I had a chat with my boss about drillthrough reports. I told him that with SSRS 2008 it can be done easily. Yep, I was right in terms of a SQL Server data source (or other relational I presume) but it cost me almost a day to figure out how to do it if you have two reports based on an SSAS OLAP cube!...
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...
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems