Welcome to Office Zealot Sign in | Join | Help

March 2006 - Posts

Troubleshooting IIS Authentication Problems

Had a customer show me this today... It's a tool from Microsoft (named 'Authentication and Access Control Diagnostics') to help IT staff troubleshoot authentication problems with IIS (your ears should perk up if you're a SharePoint administrator). See
Posted by Mauro | 1 Comments

Great Resource for Designing Performance Dashboards

How do you decide what your dahsboard should look like? One the best places to start is by seeing what other people are doing... you know what they say... “imitation is the greatest form of flattery”!... A great resource for actual dashboard
Posted by Mauro | 0 Comments

Formatting Multi-Select Fields in Data View Web Part

Add this one to your SharePoint bag-of-tricks... Came across a post by Wayne Hall ( http://mindsharpblogs.com/wayne/archive/2005/06/13/494.aspx ) that talks about a solution to the annoying presentation of multi-select data in a Data View web part column.
Posted by Mauro | 0 Comments

New Cumulative Patch for Business Scorecard Manager

There's a new patch out for BSM (”Update Rollup 2 for Microsoft Office Busines Scorecard Manager 2005” -- http://www.microsoft.com/downloads/details.aspx?FamilyID=a60ab1e3-4775-47d0-8b59-2c7c547fcc48&DisplayLang=en ). This patch is cumulative
Posted by Mauro | 0 Comments

White Paper on Using SharePoint Portal Server in a Geographically Dispersed Organization

I get this question a lot... “How can an organization with offices all over the world effectively use SharePoint Portal Server without having regional office users face long page load or download times?” The answer, obviously, is the congifuration
Posted by Mauro | 0 Comments

Continuing My Crusade for Performance Dashboards

Several weeks ago I wrote a simple blog entry on the differences bewteen dashboards and scorecards. It has received over 13,000 hits. Now that may not be much to Scoble (great book by the way!) but that's a lot for me. In my effort to push the cause (i.e.
Posted by Mauro | 1 Comments

More on Scheduling a SharePoint Portal Server Backup

A few months ago I published a script for automatically backing up a SharePoint portal. It was designed to create a new set of SharePoint backup files every night (overlaying the previous night's backup). I've had a few folks ask for a more robust script
Posted by Mauro | 3 Comments

T-SQL Trick for Deleting All Data in Your Database

I came across a great tip in Roman Rehak's blog ( http://www.sqljunkies.com/WebLog/roman/archive/2006/03/08/18620.aspx ) on how to use simple t-sql to delete all the data in all the tables of a database. I've added this to my SQL toolbox for two reasons:
Posted by Mauro | 9 Comments

More Interesting Information on BI Tools Adoption

I read an interesting article in this week's “InformationWeek”. It is entitled “ Intelligent Spending - Companies are investing more money in business intelligence tools and handing them out to more employees ”. There is some great
Posted by Mauro | 0 Comments

C# Code Snippet for Doing Placeholder Replacement

Every once in a while I feel the urge to prove to folks (including myself) that I am simply a coder at heart... I had a friend present me with an interesting design challenge in his email submission application. His tool constructs email templates with
Posted by Mauro | 1 Comments

Taking a Look at Business Object's Xcelsius

Put this one in the “Have you seen this?” category... I came across Business Object's Xcelsius product. Very interesting! Crystal Xcelsius and Crystal Xcelsius Workgroup edition are the industry leaders in visual analytics software. Using
Posted by Mauro | 3 Comments

Quick Tutorial on Moving a WSS Site

I had someone ask me for instructions on moving a WSS site from one server to another. There are a few options but the best (I think) is the stsadm utility. Stsadme.exe is a command-line administration tool that is installed on all servers running WSS
Posted by Mauro | 3 Comments