Like Us
Plus One
Follow Us
Search
 Name Jeff Jones  Blog @SPJeff
 Location United States  Category SharePoint
 Articles 140  Views 59196

Articles from @SPJeff

s
Check out this live coding demo of how to reference and include [angular2-datatable] in your Angular2 CLI project.  Cheers! Video Screenshots References https://www.npmjs.com/pack...
Create Communication Site – URL Trick      27-Sep-2017     186  
Recently I wanted to create a Communication site in Office 365 but did not see the “+New” menu on the tenant SharePoint landing page.   However, I switched to another tenant and watched H...
FIXED – RDP Requires Authentication Twice      27-Sep-2017     116  
Recently I had an issue where RDP to new Windows Server 2012 R2 machines required login – twice.   Saved credentials in RDP Manager were being passed, but the target machine required a se...
VIDEO – Populate Word DOCX with PowerShell      19-Sep-2017     105  
Recently I found a way to dynamically update Microsoft Word text placeholders with PowerShell script.  Because DOCX files are ZIP archive we can extract to a TEMP folder to update the internal...
VIDEO – Populate Word DOCX with PowerShell      19-Sep-2017     108  
Recently I found a way to dynamically update Microsoft Word text placeholders with PowerShell script.  Because DOCX files are ZIP archive we can extract to a TEMP folder to update the internal...
What’s in that patch? Sep 2017      12-Sep-2017     107  
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 fo...
Recently while debugging an application I needed to design REST and JSON api calls across DNS domains.   However, the client browser Chrome blocked those HTTP transactions due to CORS.&nb...
While working with SharePoint Designer and opening sites in Office 365 I came across the below cryptic error message.   The root cause is lack of permission.  Granting SCA fixed. Che...
What’s in that patch? Aug 2017      14-Aug-2017     68  
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 fo...
FIXED – SharePoint Online missing Quick Edit      03-Aug-2017     71  
While troubleshooting OneDrive I noticed an end user missing the “Quick edit” toolbar button.  The fix was to update Document Library view to display  a custom column so that we have data...
FIXED – SharePoint Online missing Sync button      28-Jul-2017     48  
While troubleshooting OneDrive I noticed an end user missing the “Sync” toolbar button.  The fix was to update Document Library settings to display “Sync” so that we could connect and take the...
What’s in that patch? Jul 2017      13-Jul-2017     45  
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 fo...
Recently I noticed the below error when viewing Workflow status on SharePoint Server 2013.   Root cause turned out to be a missing IIS binding for both HTTP: 12291 and HTTPS: 12290. ...
Office 365 – Hybrid Team Site Redirect AAM      11-Jul-2017     53  
Migrating team sites to Office 365?  Worried about broken links?  Check this out. Recently I found a helpful STSADM trick that provides HTTP redirection for hybrid SharePoint farms moving...
Continued part 2 of earlier video at http://www.spjeff.com/2017/05/31/angular-cli-todo-list-in-sharepoint-content-editor/ Here we add “spcrud.ts” library with CRUD methods to save JSON ...
SMAT – Content Database Query      20-Jun-2017     150  
While reviewing the SharePoint Migration Assessment Tool (SMAT) I noticed the high performance data gathering. Running on a farm with thousands of sites the collection of data ran quickly. Lookin...
What’s in that patch? Jun 2017      14-Jun-2017     162  
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 fo...
VIDEO – Microsoft Azure AD Portal (AAD)      05-Jun-2017     160  
Check out https://aad.portal.azure.com/.   Microsoft Azure Activity Directory admin center is open to all users and is a great tool to browse Azure AD, lookup user details, locate groups,...
PowerShell – Split CSV in 1000 line batches      02-Jun-2017     183  
I recently needed to parse a large CSV text file and break it into smaller batches.  Parsing text with PowerShell can easily be done.  The trick here was to manage two pointers $line (wit...
Angular 2 (“Angular”) brings many improvements over Angular 1 (“AngularJS”).  The CLI tools (Command Line Interface) help streamline operations so we can develop professional applications with...
MySite – Export user Quick Links to CSV      31-May-2017     167  
When migrating from MySite on-premise to OneDrive in the cloud, Quick Links are not included by third party utilities (i.e. ShareGate).  However, with PowerShell we can export the original raw...
Tried of waiting for Backup-SPSite / Restore-SPSite?  Me too.  Why not clone the SQL content database with SQL backup and restore?     Well, SharePoint requires every Site...
What’s in that patch? May 2017      09-May-2017     199  
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 ...
Office 365 – Plan For Change (May 2017)      09-May-2017     167  
Follow up post with new messages from the Admin Center.  Good to review these and stay current with Microsoft cloud changes. Cheers! MC98622 – New Feature: Edit Post in Yammer 05-06...
Use Visio?   Download this ZIP and extra 12 VSS files to your “My Shapes” folder.  Icons for everything Microsoft cloud including Office 365 and Azure.  https://www.microsoft....
SharePoint as a Service (SPaaS)      02-May-2017     166  
SharePoint is often treated as a final SAAS product to perform Microsoft native functions only.  Management can be reluctant to engage customization and development for the perceived cost.&nbs...
VIDEO – SP Editor Chrome Extension      25-Apr-2017     136  
If you’ve ever edited a JS file hosted on SharePoint, download this now.   Watch the demo video to see how easy it is to press F12 and edit JS / CSS files within SharePoint directly from ...
What’s in that patch? April 2017      11-Apr-2017     195  
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 ...
Many ways to query AD users      05-Apr-2017     212  
There are multiple good PowerShell options to query an Active Directory user object.   Below are three code snippets which all locate an AD user.   Cheers! Option 1- Get-ADUser ...
Download all Documents in a Library View      24-Mar-2017     225  
The PowerShell below will download all documents in a given SharePoint Document Library view to the local folder.   This can be safely run on end user Windows PC and does not require Shar...
Ever wanted to code a JavaScript content editor (script editor) web part that saves settings to a list?   Without jQuery? The library below “wp-settings.js” does exactly that with native ...
FIXED – Microsoft.Service Bus error 102      16-Mar-2017     242  
While troubleshooting a Workflow 2013 Farm outage I noticed the below event log errors.   The fix was to execute Workflow 2013 PowerShell cmdlets to “sync” the binary front end with SQL d...
What’s in that patch? March 2017      14-Mar-2017     226  
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 ...
Office 365 – Plan For Change 2017 Recap      10-Mar-2017     241  
Below is a quick recap of the 8 “Plan For Change” messages from O365 Admin Center so far this year.   The cloud moves quickly, if you have Tenant Admin rights please read these to be more...
Change the Oil – SharePoint Windows O/S      09-Mar-2017     228  
SharePoint runs best with regular health checks and preventative maintenance.   Often we overlook the Windows Server O/S as a key component.   Applications only run as fast as t...
Our next step in this series is cloud hosting.  Each of the local source components has a Microsoft cloud destination equivalent.   Here is the mapping: SQL Express > SQL Azure WebAPI > Azur...
Enable NPM behind corporate proxy      06-Mar-2017     211  
Running “npm install” on an enterprise workstation can often trigger an avalanche of errors.   Running the below commands helps point NPM at the corporate proxy server to resolve the issu...
Feb 2017 CU Download – SharePoint 2016      26-Feb-2017     320  
Quick post with download links for WSS and STS EXE files for SharePoint Server 2016. February 21, 2017, update for SharePoint Server 2016 (KB3141517) –  wssloc2016-kb3141517-fullfile-x6...
Recently I wanted to query Audit data from the web browser client and learned no native REST api was available.   So I created one.   Below is a demonstration video and link to ...
VIDEO – Online WebAPI Generator      31-Jan-2017     325  
I created an online service at https://spjeff.azurewebsites.net/ which generates a MVC WebAPI 2.2 project with the name you enter.   A custom ZIP file is generated server side with your c...
PowerShell – Cache Lookup AD User      28-Jan-2017     301  
Given a filter value, this PowerShell function will query Active Directory to find a matching user object and store results in a memory cache.  By default “samAccountName” is used ...
What’s in that patch? January 2017      23-Jan-2017     247  
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 ...
Replace CE / SE Web Part Content PS1      19-Jan-2017     207  
Managing front end code (HTML/JS) embedded within Script and Content Editor Web Parts can be a hassle.   With multiple instances scattered across ASPX pages, web part galleries, and many ...
Simple URL Shortener      10-Jan-2017     289  
Recently I wanted to create a URL shortening service for SharePoint 2013.  Yes, SharePoint 2016 ships with “Durable Links” but many places run older version.   Yes, there are commerc...
Live walk through of hosting “Todo List” CRUD application on the Microsoft cloud.   Continued from the first video where we coded a full local application, this video migrates the applica...
Live coding walk through of a locally hosted “Todo List” CRUD application with Breeze WebAPI 2.2 middle tier and SQL Express relational database storage.  This baseline allows deve...
Insane MOVE – ShareGate Turbo      15-Dec-2016     384  
ShareGate offers “insane mode” which uploads to Azure blob storage for fast cloud migration to Office 365 (https://en.share-gate.com/sharepoint-migration/insane-mode).     It’s ...
What’s in that patch? December 2016      14-Dec-2016     291  
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 ...
While enabling the CSSA (Cloud Search Service Application) I came across this error during first full crawl after successfully completing the on-boarding steps outlined at https://blogs.msdn.micros...
What’s in that patch? November 2016      20-Nov-2016     344  
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 ...
I want to migrate user alerts to Office 365 from SharePoint 2013 on-prem and was surprised to learn there is no client side API for creating Alerts.   Not SOAP, not REST, nothing but the ...
I wanted to create a new AIO (all-in-one) demo machine for SharePoint 2016.   However, Excel Web Services features have moved out to Office Online Server (OOS) and the guidance is to inst...
Recently I wanted to create a SharePoint 2016 lab environment.   With Excel Services moving out of the SharePoint 2016 product, we now need to plan for an instance of OOS.   Bel...
What’s in that patch? October 2016      12-Oct-2016     359  
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 ...
Watch me coding live to music.   Gets fun after the 3 minute mark. One Angular app written from scratch with Visual Studio code and NPM command line tools.  Uses TypeScript, Angular,...
Microsoft recently published SMAT (SharePoint Migration Assessment Tool) to scan your on-prem SharePoint 2013/2016 farm and prepare for Office 365 migration by reporting on potential issues. &...
Office 365 – Fast Track Tour      26-Sep-2016     339  
Today at Ignite in Atlanta Microsoft announced plans to expand the Office 365 Fast Track portal https://fasttrack.microsoft.com.   If you haven’t seen this before, take a minute to login ...
I Wanna Patch FAST      19-Sep-2016     361  
Want to patch your SharePoint farms faster?  Try running https://github.com/spjeff/sppatchify   The latest version (0.42) includes new PowerShell code for parallel execution of “Upgrade-S...
What’s in that patch? September 2016      14-Sep-2016     388  
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 ...
Office 365 – How to create a Developer Tenant      22-Aug-2016     335  
I wanted to get started with SharePoint Framework and learned that an Office 365 developer tenant is required.    Below are the steps I followed with screenshots.  Hope that he...
Recently I needed to save passwords to share across scripts and wanted to: Avoid clear text passwords Avoid updating anything in each PS1 script file Securely store in a central place Make future ...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Business Case for Minimal Downtime Patching (MDP)      07-Aug-2016     411  
After watching the ZDP TechNet video, I wanted to share my thoughts about when that is helpful and when a simpler approach is needed.   Ultimately we are given options and asked to balanc...
I came across this error when running CSOM requests to Office 365.   While troubleshooting the CSOM call worked beautifully from “powershell_ise” but not regular “powershell.”  Fiddl...
You Might Not Need JQuery – VIDEO      30-Jul-2016     452  
Today I was looking at http://youmightnotneedjquery.com/ and how that could apply to SharePoint UI elements.   Check out the video and code samples below.    Often we need ...
Desktop Icon to launch Office 365 PowerShell      26-Jul-2016     421  
Check this video out to see a Desktop Icon that launches PowerShell and automatically logs in to your Office 365 Tenant URL.   It leverages both the SPO (TechNet) and PNP (GitHub) cmdlets...
NEW – Microsoft Technical Guides      15-Jul-2016     406  
Last week many great technical guides were released on the MS Download Center.  They describe the business benefits of new technology and technical steps to implement.   Below are li...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Generate TypeScript interfaces from JSON data      07-Jul-2016     494  
Autocomplete JSON property names in JavaScript by generating TypeScript interfaces from sample JSON data.  Check out the below video for a live demo. Huge win for developer productivity. ...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Patching can be tedious and time consuming.   Why not automate that?  Who wants to be awake all night clicking “Next” and watching SP config wizard?  So  I coded a single P...
Office 365 – Baby Proof SharePoint      16-May-2016     416  
Ever enabled a Site Feature out of curiosity?  I sure have.  Great way to learn, but can make support headaches too.   Confusing menus, extra list instances, extra content types...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
VIDEO – Secure WebAPI with AzureAD      05-May-2016     497  
I recorded a quick getting started video for this Microsoft GitHub sample.   Walks through all the steps and even shows the SQL Local DB storage and how to verify security with Fiddler Co...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Video – Get Started with SPCRUD.JS      11-Apr-2016     535  
Check out the below 10 minute video for how get started using “spcrud.js” to easily connect Angular JS applications to SharePoint List data.    I created this library as a wrapper fo...
WordPress Resources at SiteGround      11-Apr-2016     485  
WordPress is an award-winning web software, used by millions of webmasters worldwide for building their website or blog. SiteGround is proud to host this particular WordPress installation and provi...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Check out this quick 7 minute video for how I configure my local PowerShell console with both Microsoft and community cmdlets.   Remotely manage Office 365 sites with Global Administrator...
How to detect if MS16-004 hotfix is installed      14-Feb-2016     546  
While managing a number of farms I needed to search and find out if the hotfix for MS16-004 bug was installed.   Stefan posted a helpful solution for the Jan 2016 CU ListView issue at htt...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Chocolately at Work and Home      09-Nov-2015     569  
If you haven’t seen http://chocolatey.org/ then go check it out!    “Chocolately is a Machine Package Manager, somewhat like apt-get, but built with Windows in mind” This simple yet ...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Connect to WebAPI from Excel      09-Oct-2015     611  
Recently I coded a WebAPI endpoint to support a JavaScript application.   A power user asked “How can I view this data with Excel”?    Given how the default format is JSON ...
PowerShell – keep SMTP in environment variable      02-Sep-2015     712  
You probably use “Send-MailMessage” across many scripts.  I sure do. Why repeat configuration in every script?   That’s a headache to update and manage long term.   I sugge...
Fake data with Angular JS services      02-Sep-2015     635  
Ever wanted to simulate JSON data within your Angular app?    The code below I found handy and wanted to share. The goal was to override a “real data” call by watching a global flag ...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Write to SPList remotely with PowerShell SOAP      30-Jul-2015     657  
Have you needed to write to a SPList on a remote target farm?    Get-SPSite works great locally, but remote scenarios need different techniques.   The below PowerShell will...
Enable Business Intelligence on any Team Site      28-Jul-2015     595  
Have you worked on a standard SP2013 Team Site then recognized a need to activate BI features.   The BI Center template comes with a lot preloaded.   I used that baseline to com...
Ready for SharePoint 2016?      28-Jul-2015     650  
As we get closer to the August release of SharePoint 2016 Preview I wanted to create a local virtual machine and try things out.   Below are steps with dozens of screenshots.   ...
Ever wondered what fixes are inside of a given CU?   Please see attached DOC/PDF with full detail. I wanted a new format for easy reading.   Show management and make the busines...
Untitled ASPX – light CEWP framing      02-Jul-2015     599  
If you need to host a JavaScript SPA in SharePoint and display on external systems with <IFRAME>.    The below empty ASPX page can host a single Content Editor Web Part to effe...
Microsoft wants to hear YOU! UserVoice      30-Jun-2015     570  
The below links are a great way to provide feedback for the Microsoft future roadmap, research & development, and cloud first releases.   Please give feedback and help the community s...
The below code will post to Newsfeed for any user account you specify.   Activity appears the same as if the user manually posted.   This could be helpful for populating Newsfee...
Custom Security Roles      23-Jun-2015     555  
Contributor is often too generic to match business needs.   Below are 4 custom security roles with more granular purpose.   Running the below PowerShell will create the roles (i...
Rename MySite “Blog” for findability      15-Jun-2015     560  
SharePoint names the blog created in a personal site “Blog.”  At scale this is confusing because everyone’s blog has exactly the same title (“Blog”). The below PowerShell will rename to “{Firs...