Create search in SharePoint Foundations 2013 without GUID

When SharePoint Server 2013 was first released, I was curious what new things I could do with it. I saw the new search capabilities, a different look and feel, a similar management interface, and several other BI things that made me happy. I then also realized that I support SharePoint Server and also the free version SharePoint Foundations. In SharePoint Foundations you get SOME of the things that makes SharePoint great (like Search for example), but with Foundations there are usually strings attached to that functionality.

In SharePoint, if you create your farm by clicking on all the defaults and using the wizards your databases look like this:

clip_image001

With SharePoint Foundations 2013, we don’t really have the option to create search by scripting with PowerShell… or do we?

Originally my research pointed me to Gary LaPointe’s blog here.

Which is great because this is in PowerShell and I can understand this, but it still doesn’t give us what we are wanting in the end like this:

clip_image002

Fortunately I found the following post by Jasjit Chopra’s blog here.

Finally!!! What we have been searching for all along! One thing to note at this time is that I have tried this myself on two different farm configurations (a three tier farm and a single box farm) and in both cases the search service and databases were created with the clean names and the service functions just fine.

I’m doing my happy dance now… enjoy!

-BJ

SharePoint Saturday Atlanta 2014

Back on June 21st, I had the privilege of attending my first event of the year in Atlanta at the Georgia State University Student Center.

You can find out more about the event by going here.

The twitter feed for this event was #SPSATL and if you have a chance, I highly recommend you go back and check out all the content that was related to this one.

While I was there I had a chance to check out the following sessions:

“Anatomy of an Intranet” by Michael Greene Twitter Blog

“Use SharePoint as a viable Hybrid Approach to your Enterprise” by Eric Harlan Twitter Blog

“Windows Azure as a SharePoint Farm Restore Rehearsal Space” by Tyler Bithell Twitter Blog and Pablo Montequin Twitter

“The White Hat: hacking SharePoint On-Prem from Google Reconnaissance to Metasploit” by Joseph Irvine Blog

“Business Intelligence with SharePoint 2013 and SQL 2014″ by Ivan Sanders Twitter Blog

My personal favorite of the day was the session on hacking SharePoint by Joseph Irvine. It gave me chills as to some steps I should be doing with my own SharePoint farms, but also gave many examples of businesses and organizations that show they just click next, next, next and then quit maintaining their servers.

Shame on them and shame on me too! Security for the most part isn’t too difficult, it just takes extra time that most people don’t have the time for. Until they get hacked or pwned.

The folks in charge of putting on this event did a great job! I look forward to these events whenever I can go because they always line up good speakers who can give you FREE training on something you want to learn more about. If there is an event going on close to you in the future it’s worth a tank of gas and a Saturday of your time to better yourself. Now go sign up!! :)

To learn more about upcoming events for SharePoint Saturdays head on over to http://spsevents.org

-BJ

Grid View Issue Reappears with Performance Point 2013 post June 2013 CU

Hello again SharePointers!

I wanted to get the word out on another bug that seems to have reappeared in Performance Point in SharePoint Server 2013. Originally this issue popped up as a problem with the grid view being cut off towards the top. Example below:

clip_image001

This issue was corrected in the June 2013 CU for SharePoint Server here

But after testing both before SP1 (August 2013 CU) and after SP1 in my farms, I see the following issue pop up when multiple pages exist in the web part. This is referred to pagination I believe and causes a behavior that we see in our farm like the screenshot below:

clip_image002

For us it’s more of an issue about our users not being able to view the proper info they need. I have filed a case with Microsoft support and will keep everyone up to date on how it progresses.

Fortunately as I was typing out this post I got a message from someone that this is an official bug and will be submitted to the product group to be fixed.

So I am glad that it is not just my farms that see this issue… :) But I also hope that this provides some help for those of you seeing this issue as well. As soon as I get word on which CU this new fix will be in, I will let everyone know.

Thanks for visiting!

BJ

SharePoint 2013 SP1 kb2817429 fixes Dashboard Designer issue

Greetings!

I thought I would add to the hoopla currently going on around Service Pack 1 for SharePoint 2013 which was released this week. If you haven’t got it yet, go get it now and test it out on your farms! You can find it here.

One quick thing I also wanted to mention that I have verified with SP1 is that when you install this update it does fix the Dashboard Designer not loading error that I wrote about in my last two posts here and here.

One other tidbit I did notice after I patched my farms is that when you go into Central Administration and look at the patch numbers it erases all the annoying list of patches or cumulative updates applied to your farm previously. Kudos to the team for implementing this!

So a farm like this (Pardon the 2010 reference, I didn’t have a good 2013 one):

clip_image001

After the 2013 SP1 Install will look all nice and neat like this:

clip_image002

Enjoy and happy patching everyone!

-BJ

Fix for KB2825647 released and verified

In my previous two posts I focused on a problem created by the install of the October 2013 CU for SharePoint 2013 Server. It basically disabled the ability of your users to launch dashboard designer (DD) after installing the cumulative update.

In December 2013 another CU was released, but didn’t do anything to address the problem of not being able to launch DD. If anyone of you have a SharePoint 2013 farm and use BI, this is kind of important. It’s kind of like owning a cheese factory and someone comes along and disables all of your cows from giving milk.

Good news though! After checking the MSDN forums I came across the following article:

http://blogs.technet.com/b/office_web_apps_server_2013_support_blog/archive/2013/11/19/performancepoint-2013-dashboard-designer-fails-to-start-after-october-2013-cu.aspx

Originally this article listed 3 files that needed to be replaced in all of your SharePoint farms to correct the CU issue, but initially I tried this and it did not resolve the problem. But after a few days two more files were added to be replaced as well.

The great news is that I confirmed that this does fix the original issue brought on by KB2825647 and now we can launch DD with the October 2013 and December 2013 CU applied to my SharePoint 2013 farm! Oh happy day!! Smile

Maybe this will get integrated into the February 2014 CU, but secretly I hope we get to see SP1 for SharePoint 2013 before that.

We’ll just have to wait and see. Happy SharePointing everyone!

-BJ

December 2013 CU for SharePoint 2013 still has Dashboard Designer problem

KB2850024

Happy Friday again SharePoint folks! I bring you good tidings of joy in this holiday season, but all of this doesn’t come without a lump of coal from the world of SharePoint 2013.

According to this article put out:

http://blogs.technet.com/b/stefan_gossner/archive/2013/12/20/december-2013-cu-for-sharepoint-2013-has-been-released.aspx

The December 2013 CU for SharePoint 2013 has been released, but unfortunately for those of us looking for this CU to fix the broken Dashboard Designer that was a result from the October 2013 CU for SharePoint 2013, it isn’t going to happen.

I guess we all must still dream of Service Pack 1 coming hopefully next year. I hope this does get fixed eventually because if you are like me and have a Business Intelligence effort going on at your company and you use SharePoint 2013 for it, Dashboard Designer is kind of critical in this effort.

So if you are going to update your farms, feel free to, but be warned that DD is not going to function after you install it.

Everyone have a Merry Christmas and a Happy New Year! Smile

-BJ

SharePoint Server 2013 October 2013 CU Issue

 

Happy Friday everyone! Even if it’s Friday the 13th…

I wanted to post this update about an issue that is related to the October 2013 CU for SharePoint Server 2013.

You can find the summary of this issue from Todd Klindt’s patch list here.

The frustrating thing about this issue is that I have confirmed that I have this same issue after applying the patch in one of my farms and that the “fix” that is suggested from this article does not work to bring Dashboard Designer back up for me.

So I hope that in the next few days we see this fixed with the December 2013 CU, but somehow I think that if it doesn’t make it here, we may see it in SP1 which I hope comes out before the next CU.

You can read more about SP1 for SharePoint 2013 here as well.

-BJ

Follow

Get every new post delivered to your Inbox.