Presentation from SharePoint Saturday Virginia Beach

A big thank you to the organizers, sponsors, and attendees of SharePoint Saturday Virginia Beach! The event was well put-on, and it is a great location, with a great layout! I cannot believe it took me 4 years to get down there, I wish I had gone much sooner!

I am looking forward to the next #SPSVB, but in the meantime, you can find my presentation from my session, Planning and Configuring Extranets in SharePoint 2010 below… please leave any questions you have in the comments!

 

Internet Explorer Registry Shortcuts for Enabling and Disabling Scripting Error Notifications

If you develop for websites, such as SharePoint, you probably are often enabling and disabling the Display a notification about every script error in Internet Explorer (especially version 9) often when testing and debugging JavaScript code in sites (see image below for reference).

SNAGHTML518bd738

While it is not the end of the world, it can be a few tedious extra clicks to enable and disable this as it is needed, as with IE9, it does not have the small icon with the Error on page text in the task bar like it did in previous versions, that will just allow you to click on it and view the error image.

To change this option in IE, you are required to go to Tools > Internet Options > Advanced > scroll down to Browsing, and check or uncheck this option.

To save a few clicks to make my life easier, I’ve created two registry files to turn this option on and off, you can see them below, along with the contents of the file below if you would rather just copy and paste it into your own .reg file.

Disable Script Debugging.reg: https://skydrive.live.com/redir.aspx?cid=b06529fd3fc75473&resid=B06529FD3FC75473!1527&parid=B06529FD3FC75473!134

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
"Error Dlg Displayed On Every Error"="no"

Enable Script Debugging.reg: https://skydrive.live.com/redir.aspx?cid=b06529fd3fc75473&resid=B06529FD3FC75473!1526&parid=B06529FD3FC75473!134

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
"Error Dlg Displayed On Every Error"="yes"

Simple, but effective! I actually have a custom toolbar on my Windows 7 desktop that links right to here, to make them even easier to access:

image

The one caveat however, is that you need to click on two confirmation boxes:

SNAGHTML5194f37e

SNAGHTML51952db0

I find this less intrusive to debugging than having to click through to the internet options screen, your mileage, however, may vary.

SharePoint Search and RTF File Indexing

image

Found out today while answering a #SPHelp question for my buddy Eric Harlan, that SharePoint 2010 does not natively index RTF files, it requires an iFilter.

Luckily, there is an easy answer to it, which came back in a Google Books preview of Pro SharePoint 2010 Search. Click the link for details – http://go.gvaro.net/tLqruO

I also learned that FAST search does however index RTF files by default, thanks to @NauplisTrevor

image

The good news is – you can still learn something new every day! And by all means, if you do learn something new about SharePoint, share it with the rest of the world by blogging, tweeting, or, the old school method of writing it in sidewalk chalk on your driveway (you may want to put a tarp over it if it rains however, as it will wash away. I found this out the hard way…).

The New England SharePoint Community List

New England is a bustling SharePoint community, and I am happy that I just happen to live in the area, and can experience most or all of what the New England area offers as far as SharePoint is concerned.

Since this is the season of giving, being the holidays and all, I thought this was a great time to inventory the resources in the New England area to allow people to give and to receive SharePoint community goodness. In building this list, I also learned that there are more SPUGs in New England that I did not even know existed – so I hope this does the same for you!

Please feel free to add to the comments on this post with any other resources I may have missed, I know I must have! Also please feel free to send any updates for information below. All group and event information has been culled from their respective websites and other various sources.

 

Massachusetts

Boston Area SharePoint Users Group (BASPUG)

ABOUT: The Boston Area SharePoint Users Group (BASPUG) was founded to bring together like minds to network and share their experiences, triumphs, and tribulations​ around Microsoft SharePoint, to provide a community platform for Boston area SharePoint users, administrators, developers, architects, of all experience levels, even those brand new to SharePoint, to share their knowledge with the community. We (usually) meet the 2nd Wednesday of every month at either Microsoft’s New England Research & Development Center in Cambridge, MA, or at the Microsoft Office in Waltham at 201 Jones Road.

MEETING FREQUENCY: Monthly, second Wednesday of the month

MEETING LOCATION(S): Microsoft New England Research & Development Center (NERD), 1 Memorial Drive, Cambridge, MA and Microsoft Waltham, 201 Jones Road, 6th Floor, Waltham, MA

WEBSITE: http://www.bostonsharepointug.org

Boston SharePoint Salon (BoSS)

ABOUT: While there are a plethora of after-hours SharePoint events and user-groups in the Boston area, we felt that what was missing was something a little less formally structured and a little more convivial. With the Boston SharePoint Salon, we hope we’ve created a leather armchair forum in which local and visiting SharePoint enthusiasts can partake in a spirited and meandering discussion of current and looming business, technological and cultural issues. Thus far we’ve discussed cloud, mobile, self-service BI, cigars and small batch Bourbon.

MEETING FREQUENCY: Various

MEETING LOCATION(S): Various (Boston Area)

WEBSITE: http://www.bostonsharepointsalon.com

 

New England Regional SharePoint Users Group (NERSUG)

ABOUT: The New England SharePoint Users Group (NESharePoint) was founded in August 2001. Our mission from inception has been to share deep SharePoint experience with individuals who are interested in learning, sharing and growing their Microsoft SharePoint knowledge and capabilities. The group’s vision is to provide members with a forum to hear top industry experts present, learn and teach others who are interested in the same technologies as you and are facing the same challenges.

MEETING FREQUENCY: Monthly, fourth Tuesday of the month

MEETING LOCATION(S): Microsoft Waltham, 201 Jones Road, 6th Floor, Waltham, MA

WEBSITE: http://www.nesharepoint.com

 

SharePoint Saturday Boston (SPSBos)

ABOUT: SharePoint Saturday Boston is a free community‐focused SharePoint event dedicated to educating and engaging members of the local technical community. SharePoint Saturday draws upon the expertise of local SharePoint IT professionals, developers and solutions architects who come together to share their real world experiences, lessons learned, best practices, and general knowledge with other like‐minded individuals.

MEETING FREQUENCY: Yearly

MEETING LOCATION(S): Microsoft Waltham, 201 Jones Road, 6th Floor, Waltham, MA

WEBSITE: http://www.sharepointsaturday.org/boston

 

The SharePoint Technology Conference (SPTechCon Boston)

ABOUT: The SharePoint Technology Conference is the world’s premier independent event for Microsoft Office SharePoint Server technology and services. The format includes 90+ technical classes, workshops and breakout classes with content geared to IT professionals, business managers and developers.  It features a top Microsoft MVPs, dozens of expert MS speakers and solutions from 50+ exhibitors.

MEETING FREQUENCY: Yearly

MEETING LOCATION(S): Various

WEBSITE: http://www.sptechcon.com

 

Connecticut

Connecticut SharePoint Users Group (CTSPUG)

ABOUT: Coming soon… will update when completed! See the SPUG link below for details!

MEETING FREQUENCY: Monthly

MEETING LOCATION(S): Microsoft Farmington CT Office, 74 Batterson Park Rd, Farmington, CT

WEBSITE: http://ctdotnet.org/CTSPUG.aspx

Fairfield County SharePoint Users Group (FCSPUG)

ABOUT: The mission of this group is to establish a local community for the FCSPUG members to discuss and collaborate on SharePoint best practices and evolving technologies. The vision is to empower the users with the resources and better understanding of how to build applications/solutions for their organizational needs leveraging Microsoft SharePoint.

MEETING FREQUENCY: Monthly, second Wednesday of the month

MEETING LOCATION(S): Bigelow Tea, 1 Constant Comment Way, Fairfield, CT

WEBSITE: http://www.sharepointusergroup.com/FCSPUG/

 

SharePoint Saturday Hartford (SPSHFD)

ABOUT: SharePoint Saturday Hartford is a free community‐focused SharePoint event dedicated to educating and engaging members of the local technical community. SharePoint Saturday draws upon the expertise of local SharePoint IT professionals, developers and solutions architects who come together to share their real world experiences, lessons learned, best practices, and general knowledge with other like‐minded individuals.

MEETING FREQUENCY: Yearly

MEETING LOCATION(S): New Horizons Learning, 340 West Newberry Road, Bloomfield, CT

WEBSITE: http://www.sharepointsaturday.org/hartford

 

New Hampshire

Granite State SharePoint Users Group (NHSPUG)

ABOUT: We’re about tip sharing and making connections in the industry without having to head south of the border.

MEETING FREQUENCY: Monthly, second Thursday of the month

MEETING LOCATION(S): Daniel Webster College, 20 University Drive , Eaton Richmond Center, Room 122, Nashua, NH

WEBSITE: http://www.granitestatesharepoint.org

 

SharePoint Saturday New Hampshire (SPSNH)

ABOUT: SharePoint Saturday New Hampshire is a free community‐focused SharePoint event dedicated to educating and engaging members of the local technical community. SharePoint Saturday draws upon the expertise of local SharePoint IT professionals, developers and solutions architects who come together to share their real world experiences, lessons learned, best practices, and general knowledge with other like‐minded individuals.

MEETING FREQUENCY: Yearly

MEETING LOCATION(S): Southern New Hampshire University (SNHU), Manchester, NH

WEBSITE: http://www.sharepointsaturday.org/nh

 

Vermont

Vermont SharePoint Users Group (VTSPUG)

ABOUT: The Vermont SharePoint Users Group is an open and independent forum for evaluating and extending the knowledge of the SharePoint Products and Technologies architecture, technologies, tools and business applications for its membership. Its purpose is to provide information and guidance to the full breadth of its capabilities.

MEETING FREQUENCY: Monthly

MEETING LOCATION(S): White River  Craft Center, 50 Randolph Avenue, Randolph, VT

WEBSITE: http://www.vermontspug.com

 

Maine

SharePoint User Group of Maine (SPUGME)

ABOUT: Swap tips and tricks with other local SharePoint professionals. Share problems and solutions at an old-school user group, meant to support everyone’s knowledge of this extensive application. Our goal is to bring the local SharePoint community together to share tips, tricks and ideas on the uses of the various SharePoint products and technologies.

MEETING FREQUENCY: Monthly

MEETING LOCATION(S): Winxnet Offices, 5th Floor, 84 Marginal Way, Portland, ME

WEBSITE: http://www.winxnet.com/spugme

How much storage space is my site collection using?

NOTE: This post is just covering SharePoint 2010, and not earlier versions of the product.

imageA common question administrators have in their SharePoint environment is “How much storage space is my site collection using?”

Well, fear not, trusty SharePoint administrators! There are a few ways to skin this cat – and we’re going to take a look at them.

 

SharePoint Designer

SharePoint Designer – what was once something administrators and power users shuddered at the mere mention of the tool in prior versions of the product, has gotten a makeover. And, also has a lot of additional functionality. For today’s lesson however, we are only going to look at one specific feature of it – the ability to view the storage used for an entire site collection!

If you open up SharePoint Designer to the root site of your site collection, in the main window, once the site is opened under Site Information, you will see, as highlighted below, that it will conveniently display the Total Storage Used of your entire site collection! There! As the big red button on my desk often says after a good firm press… “That was easy!”.

image

Let’s look at a couple of other methods of getting this information, shall we?

StorMan.aspx – SharePoint 2010 Service Pack 1+

This one requires Service Pack 1 to be installed to be able to utilize this feature. It was not in the RTM version. At the root of your site collection, if you go to Site Actions > Site Settings > Site Collection Administration > Storage Metrics, this will give you details on the usage – such as what sites, lists, libraries, and items are taking up the most space, however, it will not give you a total like our trusty SharePoint Swiss Army Knife – SharePoint Designer does, but, it will allow you to drill down into the usage.

image

I will also urge you to view Bill Baer’s article on Storage Metrics in Service Pack 1 – which has some great screenshots of the functionality, as well as an overview, available here: http://blogs.technet.com/b/wbaer/archive/2011/06/28/service-pack-1-storage-metrics-storman-aspx.aspx

PowerShell

imagePowerShell, one of the other power tools in SharePoint 2010, much more akin to the Ginsu knife, can also serve up the details, and, like the Ginsu knife, allow you to slice and dice the information in a myriad of ways.

Below is an example script to connect to your site collection, and read out all of the usage information.

$site = Get-SPSite http://my.sitecollection.com
$site.Usage;
$site.Dispose();

Which gives the following output (storage shown highlighted below in bytes):

image

To view just the Storage property, and not Bandwidth, Visits, Hits, and DiscussionStorage, you can call this:

$site = Get-SPSite http://my.sitecollection.com
$site.Usage.Storage;
$site.Dispose();

And only the Storage property with the total bytes will be displayed. You can also do some other cool tricks, such as calculating kilobytes, megabytes, gigabytes and terabytes right from the command line as well, to make the results a bit more readable:

image

Want more? OK! We can give it to you! Keep reading! (Because, reading is fundamental, you know.)

Web Analytics

Another option to view the storage used, as well as some additional metrics around it, if you have Web Analytics enabled, you can view your usage over time. To see this, go to Site Actions > Site Settings > Site Actions > Site Collection Web Analytics reports

image

Once there, in the main screen, you can view a summary of the Total Storage Used under Inventory.

image

And if you click on Storage Usage under Inventory within the quick launch navigation on the left, you can then view reports on storage utilization for your site collection, with a graph of the values so you cane easily visualize the trend in storage usage.

image

image

As well as a daily breakdown of the storage used, so you can see how this grows or falls over time.

image

You can also run reports for any date range since Web Analytics have been enabled, as well as run workflows against this data for alerting and reporting.

image

I hope you were able to learn something new today… have another method in which you get your site collection storage metrics? Leave it in the comments below for everyone else!

Stay away from my search result pages [insert search engine name here] bot!!

imageNow, this is a bit overkill, but, there are almost as many different ways a search crawler makes use of a robots.txt file as there are search engines (this may be highly over-exaggerated, but anyways…).

Now, one thing you probably do not want with your public facing site, is for the search engine to waste it’s time crawling your search pages. You don’t exactly want a high page rank for your site’s search results, do you?

What to do, what to do?

Well, if your search results pages happen to live under /search/pages/results.aspx, here is an example. This again is a bit overkill, but it should get the job done. Now the search engines can focus on what you want to be getting searched for – your content!

Some search bots allow for wildcards, some are case insensitive, some are case sensitive – hence the number of variations below. Add this into your robots.txt, and you should be good to go.

Disallow: /search/pages/results.aspx
Disallow: /Search/Pages/Results.aspx
Disallow: /Search/Pages/results.aspx
Disallow: /Search/pages/Results.aspx
Disallow: /search/Pages/Results.aspx
Disallow: /search/pages/Results.aspx
Disallow: /Search/pages/results.aspx
Disallow: /search/Pages/results.aspx
Disallow: /search/
Disallow: /Search/
sallow: /search/pages/
Disallow: /Search/Pages/
Disallow: /Search/pages/
Disallow: /search/Pages/
Disallow: /*Results.aspx
Disallow: /*results.aspx

Any additions? Please share them here in the comments!

Office 365 + Outlook + My Site Social Connector – Hotfix Released 12/13/11!

One of the features I have grown to love in Outlook 2010 is the Social Connector – that window below your emails which you can enable to view aggregations of social network updates (My Site, Facebook, LinkedIn, to name a few) as well as past conversations, calendar items, attachments, and more.

image

Up until this month however, if you were a user of Microsoft Office 365, then you could not connect to your My Site hosted on SharePoint Online, you would get this lovely error after entering in all of the credential information:

image

Being a user of Office 365 – this was an issue for me, especially since I use the Social Connectors in Outlook daily.

I am pleased to announce, that as of December 13th, 2011,  that it has finally been fixed! You can download and install the hotfix from here (Outlook x64 only): http://support.microsoft.com/kb/2597051/

Works perfectly now!

Are you suffering from TMSTGNS (Too Much Security Trimmed Global Navigation Syndrome)?

Is your site collection acting sluggish? Seeing load times of 5-15 seconds on any page or resource? Are other web applications and site collections in your farm acting just fine? Are server resources not over utilized? You may be suffering from Too Much Security Trimmed Global Navigation Syndrome (TMSTGNS). We will walk through some background information, symptoms, diagnosis, as well as ways you can bring your site collection back to life, and still allow your users to get where they need to go.

What is the “Global Navigation”?

Also known as the Top Navigation, or the Top Link Bar in SharePoint. You see it as the horizontal navigation at the top of your pages. See the image below as a reference (highlighted in yellow):

image

What is the cause of TMSTGNS?

The global navigation in SharePoint is generally used to get around to sites and pages within your site collection -  based on the configuration from the Look and Feel groups in the Site Settings page for each of your sites. This is found under Site Actions > Site Settings > Look and Feel > Navigation

image

And once there, you can configure the dynamic nature of the menus (to automatically show subsites and pages for each of the sites, and whether or not to inherit navigation from those sites)

image

Also, by default, there are some settings which are not displayed on this page, which affect your navigation. Those settings are found at the site collection level under Site Actions > Site Settings > Site Collection Administration > Site collection navigation

image

The settings found within this little-used configuration screen are the root cause of TMSTGNS, and give the syndrome part of it’s name, Security Trimmed (ST).

image

As you can see in the highlighted sections above, in this screen are options to Enable security trimming, and to Enable audience targeting. What do these do you ask?

Security trimming, as the description above implies, will hide navigation links for sites or pages the user does not have access to. For instance, if only the Finance department had access to the Finance department team site, then with this option enabled, people who are in Human Resources would not see the navigation node for Finance. Now, this sounds like a great idea, right?

Audience targeting is similar. Under Site Actions > Site Settings > Look and Feel > Navigation, when you are adding a link or a header, you have the option to specify a targeted audience, so only those who are within those audiences can see those links.

SNAGHTML13964a3f

Yes, it is a good idea, keep things hidden that shouldn’t be seen if you do not have access, however, as your site collection grows to hundreds of sites, each which hang off of the Global Navigation, either directly there, or, which are found one or two levels below in navigation flyouts (see image below)….

image

SharePoint needs to iterate through EACH AND EVERY NAVIGATION NODE, and check if the current user has access to the site, as well as if they are in the audience for that link, EVERY TIME THE NAVIGATION LOADS! That is a lot of recursive security checking, and can take time. The more sites you have, the longer this will take.

You can see this in action especially with the Developer Dashboard running when your site has one or more team sites enabled (while the example below is minimal, I’ve seen this go on in some instances for pages and pages and pages):

image

Now, you see for each of the navigation nodes, it takes roughly 20ms for each link (the area above with the hidden sections to protect some private data) to be checked for access and audiences, which is the EnsureListItemsData method calls shown below each link. Multiply this by the number of navigation nodes you have, and you can probably come pretty close to the amount of time it takes for your pages to load. I have literally seen CPU spikes on servers 25% and higher utilization than normal with the W3WP.exe worker processes for IIS while this operation is taking place as well. It utilizes a lot of CPU to accomplish this task.

The quick fix for this? uncheck those two boxes under the Site collection navigation configuration screen. You will notice a huge performance improvement. This means however, that all of your users can see all of the links within the Global Navigation.

 

But what if I need to hide links, and keep them available to the users who need them?

This is a great question, and one that I can use the classic consulting phrase on – “it depends”. You may find that you can add these links to an audience targeted web part underneath the main site they are on. This may take an extra click, but, security is not transparent. Just compare the time it takes to go through an airport now than it did before 2001. If you need security, and performance, than a small subset of your users having to make an extra click might not be so bad. Ultimately it is up to the decisions you make within your organization, and how these work-arounds can and will be carried out and implemented.

What else can I do?

There are many options other than just disabling the security and audience trimming on the global navigation. Those might be building a custom navigation control (development), to implement security trimming for links in a different manor, such as checking a list which has ONLY the links to be trimmed from the Global Navigation, rather than having to check each link.

Using a list-based navigation source with item permissions enabled – this is also security trimming, however, it is only within a single list, so performance should be better, but, it will be slower than a navigation source without any security trimming.

You may also implement multiple navigation layers, one without security trimming, and one with a custom source that is security trimmed in the master page.

As I said, there are many options – you may need to think outside the box a bit to get to the best resolution for your organization, but at the very least, your pages will be loading a lot faster when you are not suffering anymore from TMSTGNS, thus giving your end users, and yourselves, a better SharePoint experience.

 

Are you a survivor of TMSTGNS?

Then share your story with everyone else in the comments below about how you were able to defeat this horrible performance degrading disease.

Speaking at SharePoint Saturday Austin

I am pleased to announce that I will be presenting at SharePoint Saturday Austin on January 21st, 2012, presenting my session on Planning and Configuring Extranets in SharePoint 2010, with my colleague Donal Conlon.

Information on the session is below:

Planning and Configuring Extranets in SharePoint 2010

Session Level: 300
Session Type: IT Pro / Admin
Most companies, large or small, require contact and collaboration with external entities, whether they are vendors, clients, or contractors. SharePoint gives us the ability to open up portals for collaboration with these external entities – this session will show you how to accomplish this using SharePoint 2010.

We will review what is required to make SharePoint “open” to the external world, discuss scenarios regarding security and privacy, as well as walk through configuring Forms Based Authentication, Claims Based Authentication, as well as using Business Connectivity Services in SharePoint 2010, to authenticate, and manage our external users.

Once completing this session, you should have a firm grasp on how to configure an extranet environment using SharePoint 2010, as well as what should be considered during the planning of your extranet scenarios.

I will also be giving away 2 copies of the book I am working on of the same subject.

About SharePoint Saturday Austin:

SharePoint Saturday Austin is a joint effort headed up by Jim Bob Howard and Matthew Lathrop, but made possibly only through the dedication and commitment of our volunteers, sponsors, the local Central Texas SPUG, the speaker community, and all of our attendees.

If you have any questions or would like to volunteer, please us the contact form on this page.

SharePoint Saturday Austin is part of a national and international calendar of free events, organized and overseen by the SharePoint Saturday Board of Directors. For more information about SPS and other events, visit: www.sharepointsaturday.org.

When and where will this magical event be held, you ask?

SharePoint Saturday Austin (#SPSAusTx)
Saturday, January 21, 2012
AT&T Executive Education and Conference Center, Austin, TX
8AM – 5PM
SharePint following ’til 7PM

Hope to see you there!

Registration Open for Boston Area SharePoint Users Group on 1/11/12

Registration is now open for the January 11, 2012 Boston Area SharePoint Users Group Meeting in Waltham, MA.

January 11th, 2012 Meeting Information – Waltham

PRESENTER
The presenter for our next meeting is Scott Jamison, Chief Architect and CEO for Jornata. He will be presenting "Making SharePoint 2010 ROCK by Increasing Findability".

Session Abstract
Want to make it easier for users to locate the right content, whether they’re browsing or searching in SharePoint? In this session, Scott shows you real-world ways to get the most out of key features like metadata, content search, people search, cloud tags, status feeds, list views, and content contribution.

About Scott
Scott Jamison is a SharePoint MVP and MCM. He’s also the Chief Architect and CEO at Jornata, a top-tier SharePoint consulting firm.

MEETING SPONSOR – CubisOne
CubisOne provides consulting and IT services to clients globally. CubisOne delivers unmatched business value to customers through a combination of process excellence, quality frameworks and service delivery innovation. By leveraging our onshore, offshore and onsite capabilities, our customers enjoy decreased costs, increased profitability.


RAFFLE PRIZES

We will be handing out raffle tickets at the BASPUG meetings.

LOCATION
We will be meeting at the Microsoft Waltham office, located on the 6th floor, at 201 Jones Road, Waltham, MA.

LINKED IN

Join our group on LinkedIn today to connect with the rest of the BASPUG members, and spread the word!


FACEBOOK

We are also on facebook! http://www.facebook.com/#!/pages/Boston-Area-SharePoint-User-Group/113652405354617


TWITTER
Follow news about the Boston Area SharePoint Users Group on twitter by following us @BASPUG, and by using the hashtag #BASPUG


WEB
Visit the Boston Area SharePoint Users Group website at http://www.bostonsharepointug.org

Follow

Get every new post delivered to your Inbox.

Join 35 other followers