The Secret of MIM(2016). A Ballad of UPS.

5 06 2017

We have come full circle with UPS and SharePoint. The year is 2017. The players are the same. We look back fondly at 2010 where we battled with the toddler known as the User Profile Service. 7 years later, that toddler is a full blown teenager and the battle begins again.

A worthy oponent this was, yet as true as the warrior is to war, I am to the UPS. I will be blogging about my hard fought battle with SharePoint 2016 with MIM 2016, custom attributes, and yes, custom connection to SQL to bring back User details.

The story shall be told. Battles where lost, but the war  was won.

Very special thanks to Spencer Harbar and Todd Klindt for their infiniate morsels of wisdom. That dude Spencer slayed that dragon way before I did.

Stayed Tuned. For in the morrow i shall regale thee with the Secret of MIM!

see what i did there….

nando





Forgotten WFM Autogeneration Key? I got your back!

8 02 2017

You ever forget that stupid autogenerated certificate password to join a SharePoint Workflow Manager Farm? Did you ever inherit a SharePoint farm with no passwords and you need to leave and rejoin a wfm farm(happens alot). Or perhaps you want to scale out your WFM farm and do not have the password.

I struggled with this one myself, and I am here to show you the way.

There is no way to retrieve it, that i know of. But I can show you how to change it.

Step 1 – DO NOT LEAVE THE WFM FARM! YOu can do this if you do leave the farm, but it will take the full DB Connection string to get this to work.

Step 2-Open powershell on your WFM machine and run these commands to update WFM Auto generated key.

PS C:\> $autoGenerateKey = convertto-securestring 'CertAutoGenKey123'  -asplaintext -force
PS C:\> Set-WFCertificateAutoGenerationKey  -WFFarmDBConnectionString 'dbConnectionString' -key $autoGenerateKey -Verbose
This will change the certificate generation key most people set when they run WFM the first time.
Step 2- Update the Service bus key as well. You can’t do one without the other. From powershell type this:
PS C:\> $SBGenerateKey = convertto-securestring 'CertAutoGenKey123'  -asplaintext -force
PS C:\>Set-SBCertificateAutogenerationKey-WFFarmDBConnectionString 'dbConnectionString' -key $autoGenerateKey -Verbose


That’s it. You should now be able to join the server to the WFM farm.

Microsoft does not make it easy to find this stuff, so i decided to help you all out.

Love

Nando





Workflow differences….way over due!

26 01 2017

I have been a way for a long time. But now i am back with a useful list of SharePoitn 2010 vs 2013 workflow actions.
Enjoy.wfa





REST API? More like UNREST! Duplicate list names break you!

8 06 2016

Lesson learned! So for the last two days i have been tackling what i thought was a powerpivot issue. But it wasn’t.
Suddenly all powerpivot refreshes broke. Why? Because of a migration. Why? Now that is the million dollar question.
Going through all the troubleshooting steps for powerpivot, I came across this gem of an error:
Error Message: ============================ The remote server returned an error: (500) Internal Server Error. ============================ Call Stack: ============================ at Microsoft.AnalysisServices.Common.DataSourceBasic.UpdateDataFeedParameters(ConnectionStringBuilder connBuilder, IDataSource dataSource, Boolean checkFeedValid) at Microsoft.AnalysisServices.Common.DataSourceBasic.GetCurrentConnectionString(Boolean checkFeedValid) at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl) ============================

So naturally i googled the bejesus out of this and found some reference to illegal characters. But that wasn’t the answer. It was close but not quite.

It turns out that you CANNOT have duplicate List names in the same site. This includes Document libraries and list combinations. During the migration, a list was brought over that had the same name as an existing library.

This was a tough one to diagnose and worthy of a DOJO post.

Enjoy

Nando





SharePassion Creed

16 12 2015

The argument goes as follows,” I can’t find anything in this mess of a file share.” The answer I give is, “SharePoint can help with that!”. The reaction to that is, “SharePoint is too complex!” or “I have too much stuff to sort through!”, or something to that extent.

Bro, do you even SharePoint?

Why do I even bother? I’ll tell you why. Because I love what I do. I love SharePoint and what it can do. I enjoy watching the light bulb in people’s heads go off when they see what this amazing piece of technology can do for them. Yes, I am a geek and damn proud of it.

No joke, I have not gone to work since 2005, when I first started working with SharePoint. Why am I telling you this? Because, I want you to know what SharePoint means to me and the many other passionate folks in the SharePoint community. These people, put in ungodly amounts of their free time, to speak and help anyone understand what it is to SharePoint. Some go under the radar and others like Todd Klindt and Christian Buckley go above and beyond to help us all out. Honestly, I am proud to know them and even call them friends. So guys, from the bottom of my ShareHeart, ShareThankYou for what you ShareDo.

Shameless plug for you buddy: You wanna know SharePoint….

https://t.co/fKNpd7jWyA

Which brings me to the reason I was suddenly motivated to write this. Passion. It is funny that a stupid (well actually pretty good) movie about a Chef that opens a food cart in Miami, choked me up enough to tickle the keyboard.
So, passion, it is why I do what I do. Anything worth doing should be done with passion. SharePoint is one of those things. It allows the technical and analytical boring side of me to merge with my goofy creative side. I love that! It makes me excited to go to work every day.

It made me spend hours on google trying to find out why the UPS service gets stuck on provisioning.

It made me figure out how to do an accordion mega menu for universal navigation.

It even made me spend a week trying to figure out how to write a workflow that creates sub-sites on demand by using JSON calls. I feel like a dev.

SharePoint is that amazing. Three completely different problems, in the same framework. It is both a science and an art and if that doesn’t get you going in the morning, then you must live in Lotus Notes land or something.

On-prem or in the cloud, it doesn’t matter to me. There is a solution that needs to be crafted for someone, somewhere and I intend to make it.

Us SharePoint people, we are grinders. We grind every day and I dig that about you all.
Thank you very much for being there for us all and if I can be of any service, you can count on me.

Here’s to more SharePassion in 2016 and beyond!

I bequeath to you all the SharePassion Creed.

This is SharePoint. There are many like it, but this one is mine.

SharePoint is my best friend. It is my life. I must master it as I must master my life.

SharePoint, without me, is useless. Without SharePoint, I am useless. I must configure SharePoint true. I must not use the configuration wizard. I must use powershell, I will…

SharePoint and I know that what counts in the farm is metadata, not the folders they want, nor sub sites they say they need. We know that it is search that count. We will search…

SharePoint is human, even as I, because it is my life. Thus, I will learn it as a brother. I will learn its weaknesses, its strength, its web parts, its accessories, its workflow engine and its API. I will keep SharePoint clean and ready, even as I am clean and ready. We will become part of each other. We will…

Before God, I swear this creed. SharePoint and I are the defenders of the information. We are the masters of our data. We are the saviors of documents.

So be it, until there are no more folders and there isn’t 1 content database that holds 5000 sites, but clean flat metadata.

Thank you Microsoft for keeping it On Prem!

Nando





Keynote notes

4 05 2015

Satya says mobile first cloud first. Not sure how I feel about that yet. He did say devices don’t matter. Only experiences. 

Create more personal computing. Investing heavily in personal data. Building trust into the kernel? Can I build that into my mortgage? 

Super stoked for holographic computing. 

Most profound change is windows 10. WAS. Windows as a service. 

New capabilities for windows update. Not sure what he meant by that. Please god make it not break SharePoint. 

Satya said skizm. I heard it. 

Satya says compliance is built into all collaboration platforms. So that end users choose what they want and have it pros be able to lock it down. 

Driving application agility. Devops in visual studio. 
  
Real Madrid was introduced as a transformative example with social awareness and player analytics.  


Windows 10 is the center of the keynote.   
  

Windows 10 looks cool and is aimed at windows 7 users for upgrade. 

Task view will show old win 32 and new 10 apps. Familiarity is key

  
A lot of cortana love. Siri is not jealous. Cortana with local index for searching files is awesome. 

Cortana connected to powerbi!!!

  
  

New Delve helps you work better by showing you what you are spending the most time in.  

  

 





So Much Tech, So much

4 05 2015

The keynote convention center is cavernous. Like a huge hangar where the Dallas Cowboys seem to have lent their jumbotron to Microsoft. It is quite incredible, jaw dropping incredible. Several Ignite events coordinators usher us in like cattle to our designated seats. I am definetly in the splash zone1
There is a DJ. He is not young. But he is getting groove on.