N739BN – 1978 CESSNA 172N aka “Skyhawk”





N739BN – 1978 CESSNA 172N aka “Skyhawk”
Hybridizer: Kordes
Year: 1964
Type: Hybrid Tea
Color: Lavender
Frafrance: Slight
Height: 24-28″
Disease: Susceptible
Zone: 7a-10b
Scott Hanselman at Ignite (session 9/23/2020) said: if you are at the beginning of your career, certification is important, but if you have experience – experience matters, not certs. In other words – certification shows what you learned, experience shows what you know.
Good news!
On Sep, 18 during the SIG community call, PnP Team shared their plans on PnP Sites Core library and PnP Core SDK.
“PnP Sites Core v4” library and “PnP Core SDK v1” with .net core support (.net Standard 2.0) – expected in December 2020!
PnP PowerShell v4 for SPO library built for .Net Standard 2.0 / PowerShell 7 will be released in Dec 2020 as well.
Scenario: You have a large (>5k items) list in SharePoint Online.
You need to delete this list. “Remove-PnPList” fails with a message “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator“. Deleting with UI fails too.
Try this:
Get-PnPListItem -List $list -Fields "ID" -PageSize 100 -ScriptBlock { Param($items) $items | Sort-Object -Descending | ForEach-Object{ $_.DeleteObject() } }
or this:
$batch = New-PnPBatch
1..12000 | Foreach-Object { Remove-PnPListItem -List $list -Identity $_ -Batch $batch }
Invoke-PnPBatch -Batch $batch
for me both methods get same results: ~17 items per second ( ~7 times faster than regular).
With a new PnP.PowerShell we can perform some operations against an SPO list with batches! My measurements:
Time elapsed, seconds | with batches | with scriptBlock | without batches |
Add-PnPListItem (100 items) | 4.33 seconds | 42 seconds | |
Add-PnPListItem (500 items) | 21 seconds | 234 seconds | |
Add-PnPListItem (7000 items) | 314 seconds | ||
Remove-PnPListItem (1000 items) | 58 seconds | 58 seconds | 429 seconds |
Remove-PnPListItem (7000 items) | 395 seconds | 397 seconds |
References:
A new cozy family-owned hotel “Aryn” is ready to welcome you and your friends!