Welcome to Office Zealot Sign in | Join | Help

May 2006 - Posts

Dundas - Another Tool for Your Dashboard Toolkit

Have you seen the visualization tools from Dundas? Wow! I happened to stumble across them while looking for a web-based control that would do funnel charts for a sales dashboard. Dundas has one. They also have a number of other dashboard charts, including
Posted by Mauro | 0 Comments

Where does SPS Store Alerts Data?

I had a client report an issue with SPS Alerts last week. They implemented a new DNS name for the portal URL but emails coming from SharePoint alerts were stilling referencing the old URL. Here's why... Look in the _SITE database. There are two tables
Posted by Mauro | 1 Comments

New Visio Tool For Business Scorecard Manager

Saw this Microsoft download referenced on the BIMVP site... A new tool from Microsoft called KPIDraw. See the download link and blurb below. I just started tinkering with this tool but it seems like it is a good one. You can tell some good stories with
Posted by Mauro | 2 Comments

When Is 'Better' Not Good Enough? -- A Tale of Effective Enterprise Search

If you follow my blog, you know that I'm a big fan of the Coveo search product. I'm shown it to several of my clients and a number have actually deployed it. In fact, I spent a good portion of last week helping one client prepare for the launch of her
Posted by Mauro | 0 Comments

Quick Tip on Additional SPS Navigation

Here's a goodie that I implemented yesterday. A client wanted to add navigation links within SPS to corporate websites... without creating a Quick Links web part. As you may or may not know, the top navigation is pretty locked down. What to do? We ended
Posted by Mauro | 0 Comments

My Biggest SPS Pet Peeve

I work with customers and their SharePoint Portal Server implementations almost every day. I've heard my share of glowing praises and angry rants around what SPS can and can't do. I've been a good listener and have agreed with folks... most of the time.
Posted by Mauro | 2 Comments

Business Scorecard Manager Online Resources

I've had a few folks ask for additional information on Business Scorecard Manager (BSM) fundamentals. I have an introductory article on BSM coming out in the July TechNet Magazine but until that hits your mailbox here are some very good on-demand webinars
Posted by Mauro | 1 Comments

Interesting Read on Driving Business Intelligence Success

Here's a quick article on business intelligence that is a must-read for anyone struggling to define clear objective for kicking off an enterprise BI initiative. It's a reprint on bizintelligencepipeline entitled “Smarter Use of Business Intelligence”
Posted by Mauro | 0 Comments

Add a DataGrid to a SharePoint Web Part -- with Sortable Columns

Ok, this one drove me crazy for a couple of hours... I built a custom web part and wanted to add a datagrid to bind to my employee details dataset (easy!). I also wanted to make the columns (last name, first name, email address, etc.) sortable.. this
Posted by Mauro | 9 Comments

SharePoint Portal Server Restore with SQL 2005

I came across this problem today... I tried to do a SPS restore using the Data Backup and Restore Utility. I was using SQL Server 2005 as the backend. The restore failed with a 'GetDatabaseByName failed' error message. It turns out that there is a hotfix
Posted by Mauro | 1 Comments