Archive

Latest Posts

How to Filter a SharePoint Date Column by a Specific Value

Adding a date filter is usually a fairly trivial task, and using the [Today] technique is a great way to get dates in and around today ([Today]-1 for yesterday, [Today]+1 for tomorrow, etc.). But what about when you want to filter against a specific date? As it turns out the date format in a filter …

Read on

The Reality of Connecting SharePoint to Oracle using BDC

What? A while back I had a customer ask about connecting SharePoint together with an Oracle data source, and using the BDC service to act as the intermediary in that exchange. So What? The reality is that unfortunately connecting SharePoint to Oracle isn’t as simple as connecting SharePoint to a SQL Server data source. In …

Read on

Microsoft MVP Virtual Conference

Join me and piles of others in the MVP vConference (online). See below for more details. Here is a high level overview of the event: World-class free online conference that features technical content presented by Americas’ region MVPs that is open to the public More technical content (Level 200, 300, 400), less marketing 5 tracks: …

Read on

SharePoint and the User Interface with JavaScript (Slide deck)

Below is a link to a slide deck of a presentation I gave last month at our local SharePoint user group (vSharePoint). The main theme of the presentation was in regards to how to combine together JavaScript with the SharePoint UI to add some sweet, interactive behaviours that truly add value to the end consumer. …

Read on

How PowerPivot Works with SharePoint (and How it Doesn’t)

A while back a customer wanted to combine external data sources and SharePoint together, and they thought the best way to do it was with Excel PowerPivot. Their intentions were in the right vein, but the possible path of execution didn’t actually exist. The idea being that they wanted to use a tool (Excel PowerPivot …

Read on

JSLink Working with URLs in SharePoint Lists

About a month or so ago we were working on a client project with the requirement to create a mechanism for displaying links to URLs that were too long for hyperlink column in a SharePoint Links List (that column has a 255 character max). The solution was fairly straightforward. We used JSLink to create a …

Read on

Special Characters!

I got a surprise last week when I discovered that you can upload MS Word files to Office 365 SharePoint online with special characters in the file name! (NOT that I’m recommending it 😉 ) That will make life easier for business users, especially those that work in languages other than English.  

Read on

Content Database Status Error in Central Admin

I recently ran into an issue at a client site where one of their content DB’s was in an “Error” state (Database Status).   The Database name below was found to be in “Error”   The simple resolution to this was to click on the database name in question, and in the dialog that opens, …

Read on