Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

February 2018

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

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲