1. it matters is when PowerShell needs to talk to or use something outside itself. When that happens, the versions have to match.
2. if you are running 32-bit PowerShell and you try to use a module that calls a 64-bit .dll, it will fail. Or if you are running 64-bit PowerShell and you try to create a 32-bit COM object, it will fail
How to detect which Bit is available:
Links
https://www.consumerreports.org/products/mattress/recommendations/
https://www.consumerreports.org/cro/mattresses/buying-guide/index.htm
https://www.tuftandneedle.com/downloads/consumer_reports.pdf
https://www.sleepjunkie.org/find-your-best-mattress-the-top-10-and-worst-10-beds/
https://www.mattressnerd.com/stearns-and-foster-review/
https://www.goodbed.com/mattress-model/stearns-foster-hannah-grace-luxury-plush-euro-top/
https://www.consumerreports.org/cro/mattresses/buying-guide/index.htm
https://www.bestmattress-brand.org/best-mattress-reviews-plus-beds-avoid/
Top Mattresses
Compare: cloud or on-premises? What SharePoint version is more suitable?
Lets compare MS SharePoint Online and MS Office 365
What SPO offers:
Microsoft manages the installation and deployment of updates for SharePoint Online.
OnPrem: We have control of availability if you operate a dedicated datacenter.
SPO: MS guarantees 99.9 percent availability of services (including Exchange and SharePoint), provided you have an SLA.
OnPrem: Up to U
SPO: Microsoft creates regular backups of the entire farm for SharePoint Online.
6. Connection of external users
OnPrem: You need to create your own infrastructure (and it’s quite a lot!) to connect external users if you run SharePoint On-Premises. If that weren’t enough, you will have no choice but to set up security features (e.g. logging and multi-factor authentication) yourself.
SPO: comes with the ability to connect external users. This feature can be expanded simply with a variety of Azure services, so that features such as two-factor authentication and others can be implemented quite easily.
Range of functions
New tools are made available at a later date
Ported initially by MS to the online version
Modern collaboration tools
You are responsible for implementation
Microsoft works intensively on these tools
Updates
Managed and installed by you
Managed and installed by Microsoft
Availability
You are in charge of availability
SLA with 99.9% availability
Backup
You need to create backups
Microsoft ensures backup and redundancy
Connection of external users
Infrastructure required on your side
Already included
Scaling
Responsibility for detecting and rectifying bottlenecks lies with you
Microsoft looks after scaling
Management
Central Administration and PowerShell
SharePoint Admin Center and PowerShell
Ask:
When is SharePoint Online the better option?
- If you want to get things up and running quickly: in most cases it will only take minutes to set up an Office 365 account. SharePoint will be at your fingertips in no time at all
- If you are keen to reduce the costs of your dedicated infrastructure
- If you want to collaborate with external employees, partners or customers
- If you would like to use new technologies like Office Delve and Sway
- If you want to provide your employees with state-of-the-art tools for mobile deployment as well
When is SharePoint On-Premises the better option?
- If you already have a dedicated infrastructure for SharePoint
- If you have integrated external employees and customers in your infrastructure already
- If you require so-called farm solutions – so programs that penetrate deep into the system
- If you are required to do so for data protection reasons
- If your Internet connection does not have sufficient bandwidth
More here
Although Power BI has two versions (Online and for Desktop), I suggest using the Desktop version to create the dashboard, then publish it through Power BI Online to share the dashboard with your colleagues.
When opening Power BI, click on the "Get Data" button to access the data sources that are available.
As you will see, there are 3 types of available SharePoint data connectors; Folders, Online Lists and regular lists. Pick your object type and add your SharePoint URL.
On the left site, select the relevant folder or list. You will see a preview of the data that can be loaded.
More here
Some really cool stuff we can do using Google Developers Dashboard, some references here:
https://gist.github.com/balupton/9800939
and
https://www.mikecr.it/ramblings/marking-gmail-read-with-apps-script/
for my case I need to purge the Trash every Sunday, to do this:
function deleteForever() {
Logger.log('START ');
var labelName = "Trash"
var threads = GmailApp.search("in:trash label:" + labelName);
for (var i = 0; i < threads.length; i++) {
Logger.log('Delete id ' + threads[i].getId());
try {
Gmail.Users.Messages.remove('me', threads[i].getId());
}
catch(e){}
Logger.log('DONE Delete id ' + threads[i].getId());
}
}
If new to G Scripting, use logging per this spec
A basic approach to logging in Apps Script is to use the built-in Logger. Logs created this way can be viewed by selecting View > Logs in the script editor. These logs are intended for simple checks during development and debugging, and do not persist very long.
For example, consider this function:
function emailDataRow(rowNumber, email) {
Logger.log('Emailing data row ' + rowNumber + ' to ' + email);
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getDataRange().getValues();
var rowData = data[rowNumber-1].join(" ");
Logger.log('Row ' + rowNumber + ' data: ' + rowData);
MailApp.sendEmail(email,
'Data in row ' + rowNumber,
rowData);
}
When this script is run with inputs "2" and "john@example.com" the following logs are written:
[16-09-12 13:50:42:193 PDT] Emailing data row 2 to john@example.com
[16-09-12 13:50:42:271 PDT] Row 2 data: Cost 103.24
The Logger.log() method expects a string or other JavaScript object. The logs can only hold a limited amount of data, so avoid logging large amounts of text.
Normally when we copy/paste excel function, on paste the cell reference is adjusted for the
context of where we are pasting to.
For example:
Copy : from K3: =RANK(J3,J3:J25)
To: to K4: =RANK(J4,J4:J26)
Well I want my rank to go over the ENTIRE range from J3:J25, not from a relative range of
J(n) :J25, so how do we do this? Using fixed cell references:
Change our rank to:
If u have fiddler capturing traffic and yoiu receive an error:
NET::ERR_CERT_AUTHORITY_INVALID
Then perhaps you need to export Fiddler cert and import into Browser:
1. Export
2. Import into IE
Detail:
Fiddler 4.6.1.5+
More Info Here
https://www.dropbox.com/s/dfc3mlwhtgrpg93/2018-11-16_01-04-58.mp4?dl=0
