Axceler just released a new tool which will fit nicely into the SharePoint administrator’s toolbox, that can help answer some commonly asked questions in a SharePoint environment:

• What are my most active sites?
• What documents/pages see the most activity?
• What are the largest sites and items within my farm?

Axceler PinPoint provides you with answers to these common question – and best of all, it’s free. The only downside is that it needs to be run from one of the SharePoint servers within your farm, and cannot be run remotely, as it makes use of the object model to work it’s magic. A small price to pay IMHO for this information.

Click here for more information and to download

The folks over at Quest Software have recently released a free utility to allow you to easily integrate your Outlook 2003 or 2007 client into SharePoint via their community site – SharePoint For All.

This tool works by allowing you to upload attachments into SharePoint, and provide a link in your email to that document, helping eliminate the sending of attachments through your own, as well as your recipients’ mail servers. All directly from within Outlook.

I find this utility extremely handy for sending files to clients, and pushing the files up to their project site, as well as working with internal teams, pushing files up to my MySite.

Go here to download the software, a mini-guide, and there is also a link to their support forum to share your questions and feedback: http://sharepointforall.com/media/p/401.aspx

Usage is simple, once the add-in is configured, send an email with an attachment, and you will be prompted with the box above so you can specify the location (other than the default you have configured), click OK, and you’re off to the races.

Your recipient will see an email like this, with a link to the attachment (if the first or second options are chosen)

A word of note for Outlook 2007, which is not mentioned in the guide here: http://sharepointforall.com/blogs/team/archive/2009/06/23/the-official-quest-drop-this-for-sharepoint-mini-guide.aspx 

When I had installed (your mileage may vary), the utility was automatically set as disabled. You will know the utility is disabled if there is not a new Quest DropThis for SharePoint tab under Tools > Options. To change this, go into Tools > Trust Center, and click on Add-Ins. You should then see Quest DropThis for SharePoint underneath the Disabled Application Add-ins section. On the bottom of that screen, select Disabled Items from the Manage drop-down, and click Go. Find Quest DropThis for SharePoint in the list, and click Enable. Once enabled, it will then go under Inactive Application Add-ins, to now enable this add-in, select COM Add-ins from the Manage drop-down and click Go. Then, check the Quest DropThis for SharePoint option in the list, and click OK. You should now be ready to go!

AvePoint announced this at the SharePoint Technology Conference in Boston two weeks ago, and has issued a formal press release as of July 1st, 2009. They are now offering a FREE tool (DocAve SQL Restore Controller), that will allow you to perform full-fidelity item-level restore capabilities in SharePoint from SQL and DPM backups!

As with all of AvePoint’s products, this tool is available in their DocAve software suite (trial can be downloaded here: http://avepoint.com/resources/free-trial-downloads/). The trial gives you 30 days to try out the entire product suite, and after the 30 days period is up, you still have access to the DocAve SQL Restore Controller.

If you are querying against any list using the SPQuery method, then most likely you are using the U2U CAML Query Builder. And if you are not, why? (This is old news! It’s been around since SharePoint 2003) This utility is always one of the first installations to any of my development environments.

This utility makes your life much easier by allowing you to build and test your queries directly against SharePoint, before debugging them, through code. And you can also do it remotely via web services, so you do not have to install and run this directly from the server itself.

A newer version was released last year as well that will install directly into your farm via a feature, to allow you to build, test, and save queries all from the SharePoint UI!

However, a common issue takes place when you copy the query directly from the U2U CAML Query Builder (which works just fine in the utility itself), in that no matter what conditions you have specified for your query, you always retrieve all list items. If this is the first time you have run into this – you have no doubt done a little of the timeless developer troubleshooting method

1. Bang head against desk
2. Repeat

You need not worry however, this is a quick fix. The U2U CAML Query Builder inserts <Query> </Query> tags around the query itself. In your code, just drop these start and end tags from your query, and you should now be returning your expected results.