June 2010 - Posts

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: ,
Powered by Community Server (Commercial Edition), by Telligent Systems