Archive for December, 2007

Geographic driven content needs sitemaps

Saturday, December 8th, 2007

I am currently developing two separate locative content systems. Meaning, what you see is determined by your location. We map your IP address to a geocode, or latitude and longitude. Hopefully in the future geo headers will be added by browsers and we will not need to play this guessing game.

Looking through the logs and seeing the regular list of search engine indexers I normally see, what comes to mind is that the engine will see locative content based on its IP address. But the rest of the content will not get indexed unless we make sure to give them a way to find it.

I suppose that is a long way around of saying sitemaps are important after all, though I would have normally made then very low priority.

SqlServer Analysis Services

Wednesday, December 5th, 2007

Couple of evolving practices for my current team:

Do not try to set up an analysis services project on a full database. I always cut down the data to a small representative sample first.

Whenever possible, let the business folks write the calculation formulas. Don’t let your development team get bogged down with change requests for things the business people can do. Again, you will want to set these folks up with your representative sample so they can reprocess formula changes at will. Thus, the sample should be small but as complete as possible. I like to use a filtered set from the production database, pulled nightly.

Set process tasks nightly on the QA environment, even if no one is planning on looking at it this week. Make sure the unit tests are running, and if any fail, have them create cases in Bugzap in failure fixtures.

Do not forget to create performance unit tests. Meaning, if the unit test takes longer than xx milliseconds, you create a case to examine.

This isn’t necessarily analysis services, but I have found a special teams approach much more effective than a ‘you own everything approach’. Let two or three people concentrate on performance, two or three on testing coverage, etc. If you try to make everyone learn it all then no one has time to get to the bits, and that is extremely inefficient. Rotate the teams often, but always pair up someone new to the focus area with an experienced person – the cross pollination of ideas helps a lot.

Super rapid deployment with .Net

Tuesday, December 4th, 2007

One way to think about Powershell is to think of it similar to the python interpreter, but for .Net. And yes, given that IronPython exists, you can actually write your python if you so desire. The point here is, powershell becomes a rapid deployment mechanism for anything you write in .Net. Write your assembly, deploy to the GAC throughout the enterprise using SMS, and then push your powershell scripts out to the machines. This results in a very rapid design-develop-deploy cycle. You can almost get as fast as deployment as linux this way.