Productivity

[repost from Stephen Forte's Blog] See also: Part I: When to build your data warehouse Part II: Building a new schema Part III: Location of your data warehouse In Part I we looked at the advantages of building a data warehouse independent of cubes/a BI system and in Part II we looked at how to architect a data warehouse’s table schema. In Part III, we looked at where to put the data warehouse tables. Today we are going to look at how to populate those tables and keep them in sync with your OLTP system. No matter where your data warehouse is located, the biggest challenge with a...

Today, I happen to find an interesting post on mocking SharePoint context using TypeMock. Being a JustMocker, i thought rather to follow the footsteps and see if can do the same with JustMock. I am no SharePoint expert. Occasionally, I use a Windows 2003 VM with SharePoint server installed which gives me the required flavor of SharePoint for testing  SP capabilities of JM. Anyway, here is the original post that i am going to recycle using JustMock. http://meronymy.blogspot.com/2010/09/mocking-spcontextcurrent-with-typemock.html   The scenario here is pretty simple. There is a method that returns an URL from the current SPContext which i am going to mock in order...

[repost from Stephen Forte's Blog]   See also: Part I: When to build your data warehouse Part II: Building a new schema In Part I we looked at the advantages of building a data warehouse independent of cubes/a BI system and in Part II we looked at how to architect a data warehouse’s table schema. Today we are going to look at where to put your data warehouse tables. Let’s look at the location of your data warehouse. Usually as your system matures, it follows this pattern: Segmenting your data warehouse tables into their own isolated schema inside of the OLTP database Moving the data warehouse...

By default TeamPulse makes use of ports 9897, 9898, and 9899 for access to the User Management, TeamPulse, and Integration sites and services. In some cases those ports may be in use by another application, or otherwise restricted within your environment, making it necessary for a change to these defaults. With TeamPulse SP1 it's a fairly simple task to change the ports via modifications to a couple of configuration files, which we will show below. We do recommend, however, that anyone uncomfortable with editing config files have their system administrator help to make these changes.   Part 1: IIS Configuration...

[repost from Stephen Forte`s Blog] Most developers are scared of “Business Intelligence” or BI. Most think that BI consists of cubes, pivot/drill down apps, and analytical decision support systems. While those are very typical outcomes of a BI effort, many people forget about the first step, the data warehouse. Typically this is what happens with a BI effort. A system is built, usually a system that deals with transactions. We call this an OLTP or on-line transaction processing system. Some time passes and reports are bolted on and some business analysts build some pivot tables from “raw dumps” of data. As the system grows, reports start to slow...