SharePoint Dev Toolbelt

Great set of links for any SharePoint Developer:

https://www.nothingbutsharepoint.com/sites/devwiki/articles/Pages/SharePoint-Dev-Toolbelt.aspx

SharePoint 2010: The List Cannot be Displayed in Datasheet view.....

The list cannot be displayed in DataSheet view for one or more of the following reasons:

- A datasheet component compatible with Miicrosoft Sharepoint Foundation is not installed.
- Your web browser does not suport ActiveX controls
- A component is not propelry configured for 32- or 64-bit support.

If you're a SharePoint Dev/Admin/Enthusiast using a 64bit system with 64bit Office / IE, chances are you will run into this issue. I was combing for a solution when I came across this MSDN SP2010 General Q&A forum post.

Special thanks to Jennie E [MSFT] for pointing us to the 2007 Office System Driver: Data Connectivity Components

SharePoint 2010 - PDF Security

IE8 and PDF files in SharePoint don't necessarily play nice together for a reason - security. By default you'll click on your PDF and get an option to either Save or Close. Here's a good explanation and the reason you should use an ‘Inline Download’ exclusion as opposed to the common (but not recommended) Browser File Handling setting in Central Admin.

Quick link to share via JB's Just Saying...

PowerShell Script:

$webApp = Get-SPWebApplication http://webapp.domain
 If ($webApp.AllowedInlineDownloadedMimeTypes -notcontains "application/pdf")
 {
   Write-Host -ForegroundColor White "Adding Pdf MIME Type..."
   $webApp.AllowedInlineDownloadedMimeTypes.Add("application/pdf")
   $webApp.Update()
   Write-Host -ForegroundColor White "Added and saved."
 } Else {
   Write-Host -ForegroundColor White "Pdf MIME type is already added."
 }

In addition, if you want your PDFs to open in a new window or even in Adobe Reader you'll want to change your local Adobe Reader client settings:

Open Adobe Reader
Select “Edit” –> “Preferences” from the menu system.
Select the option on the left called “Internet”
Either select or de-select the option called “Display PDF in Browser” depending on your preference.

SharePoint Administrators, don't forget your PDF iFilter for searching those PDFs!

Download SharePoint Server 2010 Service Pack 1

Download SharePoint Server 2010 SP1
http://support.microsoft.com/kb/2460045

SharePoint 2010 - Content Query Web Part (CQWP) Slow Loading New Items?

We've recently implemented several Content Query Web Parts (CQWP) which I love. However, I noticed that new items weren't showing up so quickly. I did a couple of quick checks to make sure items weren't checked out or unapproved but to no avail.

Then, after some digging, I came across the following article from Michael Nemtsev: Why Content Query Web Part (CQWP) doesn’t return all results.

The workaround is a simple one:
set “UseCache” property to “false”.

Interesting note from the SharePoint Team:

Cite from SharePoint Team:

“You are only seeing your items in edit mode because the caching infrastructure of the CQWP does not cache checked-out items of individual users and we disable cache in edit mode. You can disable caching on your Web Part by setting the "UseCache" property to false”

Just a handy note in case anyone else has trouble with that very useful (but sometimes pesky) Content Query Web Part.