Monthly Archives: August 2019

VIDEO – Demo of “SPGo” Visual Studio Code Extension

Wanted to show how SPGO extension can help with local folder editing for remote SharePoint files.   Local save (Ctrl+S) will automatically run upload in the background to destination Document Library.  Configuring JSON for workspace, populate first run, download files, and upload files.  Cheers!  shades_smile

Video

Code

{
    "sourceDirectory": "src",
    "sharePointSiteUrl": "https://spjeff.sharepoint.com",
    "publishingScope": "SaveOnly",
    "authenticationType": "Forms",
    "remoteFolders" : ["/SiteAssets"]
}

References

VIDEO – Reduce SPFX Node Modules from 50,000 files to 1,000

Recently discovered an efficient centralized node package manager (PNPM) which leverages “symlinks” or symbolic linked folders to reduce disk storage duplication.  Recued from 50,200 to 1,000.  Demo video below.   Cheers!   shades_smile

Code

# Install the package globally:
npm install -g pnpm
# In each SPFX project (or nodejs project i believe):
pnpm install

Video

Cool Chart

image

References

What’s in that patch? August 2019

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 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 – Aug 2019.PDF

VIDEO – Create and connect to Oracle in Azure

Wanted to record a demo of how to create Oracle 12 instance in Azure and connect with GUI tools from Windows client.   Video shows full processing (including troubleshooting) with TCP firewall, DBCA create command, system password, and all.    Great way to build personal dev environment to learn Oracle connection strings and syntax, while staying out of live production corporate Oracle system.

Cheers.  shades_smile

Video

Code

ssh adminUser@publicipaddress
sudo su - oracle
lsnrctl start
# Find file
find / -name sqlplus -print
# Environment variables
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=cdb1; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
# Connect Oracle SQL Developer GUI
system
OraPasswd1
# Display Version
SELECT * FROM v$version

Screenshots

image

image

image

image

image

image

References

Return to Top ▲Return to Top ▲