We needed an ’emergency’ night due to an issue with a part of our ‘main’ holiday booking. Found this on Booking.com and the photos and location looked good and near to the port in St Malo so decided to take a punt.

Top tip #1 though - book direct with them - not through a third party. It was nearly 60euro more expensive through Booking. Apparently rules have changed recently where the venue had to match the 3rd party price and this no longer applies - so the venue can now charge what they like and it seems the 3rd parties haven’t caught up.

As an aside to my other post on SSRS in SharePoint integrated mode, this is a niggly little issue I encountered.

If you find yourself needing to edit a published report and, for whatever reason can’t go back to source to make the change, then a reasonable option is to download a copy of the report from SharePoint and then open it up in your Visual Studio of choice and make the edits. RDL files are pretty great at encapsulating everything they need to run within a single file (they are just XML files, after all) so this is a workable approach.

Visual Studio is a good option for designing SSRS reports. Now, that is. But years ago we had a different toolset. One of those around the 2009/2010 time was ‘Business Intelligence Developer Studio’. This was effecting a Visual Studio shell that had report templates for the various SQL Business Intelligence suite (e.g., SSIS, SSRS, SSAS.) and was installed from the main SQL Server installer. This then morphed in to SQL Server Data Tools which was available as a standalone package.

Q: Does SharePoint 2013 work on SQL Server 2016?
A: No and no.

#mvp (minimum viable post.)

(* Except, it actually does work - it’s just not officially supported by Microsoft.)

Continuing the theme of obscure SharePoint gotchas you’re unlikely to encounter (unless, I assume, you’re reading this) here’s another. One environment was experiencing an issue whereby the SharePoint Tracing Service was constantly getting set to disabled. No amount of editing it in services.msc to set it to Automatic would ‘take’ - that is, you could enable it and start it and it would work - but then at some miscellaneous point later it would mysteriously revert to being disabled.

We were on a long weekend (2 adults, 2 young kids) from a neighbouring island. Looking for a little somewhere to hide and relax for a few days. We might normally have considered somewhere more - what we would thought would be - ‘upmarket’ - but given the prices decided to take a ‘risk’ on this - a so-called 3* property. About the only thing was a must for us was an indoor pool and this does limit your choices somewhat.

I recently had some fun and games trying to fix a broken SharePoint Search Service Application. Although I’m not entirely what caused the issue (other than, you know, SharePoint) although it may be to do with changing the Farm Passphrase but one way or another it was, fooked.

I opted to just delete it and create a new one. This didn’t go well. A new application was created, but it, also, was dead.

As many people have found, Central Admin and Remove-SPServiceApplication have a habit of doing entirely nothing when it comes to remove broken Search Applications.

I’m adding this here in the hope it may save someone a few hours of pain and hair-pulling. (i.e., what I’ve just been through.)

If you use solution management in Central Administration in SharePoint - you’ll be fairly used to the whole add-spsolution / install-spsolution / uninstall-spsolution / remove-spsolution stuff that you either run from Powershell or the GUI.

You will also be familiar with the fact that solution management depends on both the SharePoint Timer Service (SPTimerV4) but also the SharePoint Administration service. If either of those services are not running, you will not be able to deploy or retract any solutions. In normal operation, solutions will go in and out like a greased piglet, but, from time to time, things mysteriously stop working. (This is SharePoint after all.)

This had been bugging me for a long time. I have an HP M377DW laserjet printer and after setting it up on my wifi network there was a spare ‘HP-Setup’ network hanging around in my local area. When I recently added an HP Envy 500 photo printer which did the same thing I resolved to hide them.

I assumed it was something to do with Wifi Direct - a wifi-like protocol that allows you to printer directly to the printer without going through the main LAN. The idea is simple - you connect to the printer’s wifi network and away you go.

I’ve wittered on before about how much I like the content organiser in SharePoint. It’s really pretty handy. Even creating rules that target other content organisers is possible. (With a little trickery.)

But since it’s SharePoint, it’s not without its quirks. I like to do as much as my dev work programmatically as possible. Every now and then you think maybe you’ve hit something you can’t script and you’ll have to resort to adding a deployment step. I was close with this.