Monthly Archives: February 2018

New feature – SharePoint Online Social Bar

 

New feature: SharePoint Online Social Bar

Major update: General Availability rollout started

Applied to: All customers

The Social Bar is a new Office 365 feature. This feature is scheduled to roll out to Targeted Release customers later this week, and it will be available for all organizations on April 1, 2018.
This message is associated with Office 365 Roadmap ID: 23708.

[How does this affect me?]
The Social Bar will appear on all modern SharePoint Online pages with the exception of the home page of a site. It will give your users the ability to like a page, see the number of views, likes, and comments on a page, and see the people who have liked a page. This visibility will be available to anyone that has been granted access to view the page.
This feature will be launched default on. As administrator, if you wish to disable Social Bar for your organization, you can do so with the following PowerShell command:

To disable Social Bar on a tenant level:
Set-SPOTenant -SocialBarOnSitePagesDisabled $true

To disable social bar on a site level:
Set-SPOSite -Identity https://tenant.sharepoint.com -SocialBarOnSitePagesDisabled $true

[What do I need to do to prepare for this change?]
There is nothing you need to do to prepare for this change. Please click Additional Information to learn more.

If you are receiving this email because your Admin added you as a recipient, please contact your Admin to unsubscribe.
Choose the release track for your organization. Use these settings to join First Release if you haven’t already.

Microsoft respects your privacy. To learn more, please read our Privacy Statement.

Microsoft Corporation
One Microsoft Way
Redmond, WA, USA 98052

VIDEO – NEW SharePoint Admin Center

Today I  noticed a new link in the top right of SharePoint Admin Center and recorded a brief video tour to highlight new features and compare to Classic Admin Center.   URL is below in case you want to try on your O365 tenant name.  Cheers!  shades_smile

Video

Modern URL – SharePoint Admin Center

Classic URL – SharePoint Admin Center

References

‘New-SPExcelServiceApplication’ is not recognized as the name of a cmdlet

Recently I was building a new SharePoint 2016 farm and came across the below error with older PowerShell SharePoint 2013 install scripts.  Expected error as Microsoft moved the functionality to Office Online Server.  Cheers!  shades_smile

Error Message

  • The term ‘New-SPExcelServiceApplication’ is not recognized as the name of a cmdlet, function, script file, or operable program.  Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Root Cause

VIDEO – Create SharePoint Framework (SPFx) “Hello World” Web Part

The video below demo shows how to create a new SPFx SharePoint Framework web part including Gulp, Visual Studio code, project folder tour, and TypeScript import references.

Great way to start developing for Modern pages (SharePoint Online and SharePoint 2016) running localhost on a developer workstation.  No need for a SharePoint virtual machine.  Cheers!  shades_smile

Video

References

Poster – SharePoint List – When to Use What

The below visual captures ideas on SharePoint table data storage and when to use what.    Rows and columns of data are common.  Choosing the best hosting technology provides ease of support, quick time to market, performance, and scale for data growth.

SQL Server has good use cases, but comes with trade-offs including higher upfront setup effort and fewer end user controls (audit, search, version history).  Can improve performance and reporting if those trade-offs are correctly addressed.

Select right tool for the job.  Times for both.

Cheers!  shades_smile_thumb

Download PDF

Download VSDX

image

Poster – Microsoft Access to Cloud Migration

Recently I reviewed options for how to migrate Access databases to the Microsoft cloud.  There are multiple target platforms to consider.  

At a high level I see four category of MS Access databases.  Each had it’s own target platform to match.

  1. Simple (SharePoint List) – Table storage with rows and columns.  Data entry such as a tracker, log, or flat input.
  2. Relational (Dynamics 365) – Multiple entities with relationships such as one-to-many and many-to-many.  Navigate data and advanced reporting.
  3. Application (Azure App) – Advanced input, form validation, triggers, scripting, and code.   Need flexbility of Azure Web App, SQL Azure, and PowerShell runbook to accommodate all features.
  4. Reporting (Power BI) – Presentation of data into chart and table format.   Drill down, filter, merge data sources, etc.

Cheers!  shades_smile

Download PDF

Download VSDX

image

What’s in that patch? Feb 2018

NOTE – PDF format updated to include both SharePoint 2013 and 2016 notes.

Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/

If you found this helpful, please leave a comment.    shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Feb 2018.PDF

VIDEO – PowerBI Dashboard in a Day (DIAD) – Exercise 4

Recently I completed Microsoft’s DIAD workshop on PowerBI.   Below is a video of Exercise 4 from Microsoft Power BI  DIAD.PDF (pages 35-57). 

It covers PowerBI Desktop steps to Enhancing Your Model with stacked column chart, drill down, legend colors, geography relationships, Microsoft Bing Map visual, scatter plot, slicer, and more.  Cheers!  shades_smile_thumb_thumb_thumb

Video

Screenshots

image

image

image

image

image

image

References

FIXED – DISM /Enable-Feature Error: 0x800f081f

Recently I attempted to install Windows Feature Dot Net Framework 3.5 on Windows 10 and saw the error below.

The resolution was to download a different larger CAB file then execute a different DISM command line.

Instead of installing the feature by name (“NetFx3”) we should install the CAB package filename (“”)

Hope that helps someone else.  Cheers!  shades_smile

Error

DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:c:\sources\sxs
# Error: 0x800f081f

Resolution

DISM /Online /add-package /packagepath:c:\sources\sxs\microsoft-windows-netfx3-ondemand-package.Cab
# microsoft-windows-netfx3-ondemand-package (68.9MB)
# The operation completed successfully.

Screenshots

3

image

References

SharePoint – SQL Database Roles

Had a friend ask about SQL database Role Memberships that are needed for SharePoint Server on-premise.  Examined SQL roles on my dev farm.  Reference table below.

Cheers!    shades_smile

Get-SPServiceApplication

Get-SPDatabase | Select TypeName

SQL Permission Role

App Management

App Management Database

SP_DataAccess

N/A

Configuration Database

dbo, WSS_Content_Application_Pools

N/A

Content Database

SP_DataAccess

Microsoft SharePoint Foundation

Microsoft SharePoint Foundation Subscription Settings Database

SubscriptionSettingsService_Application_Pool

Secure Store

Microsoft.Office.SecureStoreService.Server.SecureStoreServiceDatabase

SP_DataAccess

User Profile

Microsoft.Office.Server.Administration.ProfileDatabase

SP_DataAccess

User Profile

Microsoft.Office.Server.Administration.SocialDatabase

SP_DataAccess

State Service

Microsoft.Office.Server.Administration.StateDatabase

WSS_Content_Application_Pools

User Profile

Microsoft.Office.Server.Administration.SynchronizationDatabase

db_owner

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchAdminDatabase

SPSearchDBAdmin

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchAnalyticsReportingDatabase

SPSearchDBAdmin

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchGathererDatabase

SPSearchDBAdmin

Search Service Application

Microsoft.Office.Server.Search.Administration.SearchLinksDatabase

SPSearchDBAdmin

Machine Translation Service

Microsoft.Office.TranslationServices.QueueDatabase

SP_DataAccess

Word Automation Services

Microsoft.Office.Word.Server.Service.QueueDatabase

SP_DataAccess

PerformancePoint

Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceDatabase

SP_DataAccess

Business Data Connectivity

Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase

SP_DataAccess

Managed Metadata

Microsoft.SharePoint.Taxonomy.MetadataWebServiceDatabase

db_owner

Return to Top ▲Return to Top ▲