What’s your password security score?

Once you’ve added your passwords to LastPass, you’re able to check your “Security Score” which combines your individual passwords’ strength, your LastPass master password’s strength and your ranking compared to others.

Once it runs through all of your saved credentials, it’ll provide you with your score, your standing compared to others and your master password score:

You can improve your score by changing duplicate passwords, reviewing those that are known to have been compromised, strengthening those that are too weak, or haven’t been changed in a long time.

From the list they provide, you can auto-change passwords on some sites (it’ll generate secure passwords, update your profile on that site, and then update LastPass for you). Others you can launch the site from within LastPass to change your password manually.

This has helped me to cut way back on my duplicate passwords and I’ve created much more secure, and unique, passwords using LastPass. Start with a free trial, and after that it’s only $2/month. Well worth it in my opinion.

Also, if you’re using other solutions to store passwords, I’d recommend cutting back and choosing one central (and encrypted) solution. The more you multiply your passwords across various services that you use on multiple devices and networks, the more you increase your risk of being hacked.

Read more about how I deleted synced passwords from Google.

Forget my password, Google!

After having my identity stolen a couple weeks ago by someone who went on a Twitch spree, I decided to get more serious about my password security.

Having a Google Pixel XL, it was easy to say “yes” every time I was prompted to save a password. And being a Chrome user, I only kept adding to the Google vault. In no time, I had saved 200 passwords.

I’m not saying anything here about Google’s security (I can only assume it’s sufficient), but I am saying you should consider the number of times you perform the “save my password” action. Multiply it a few times (Google, Edge, IE, Chrome, Norton, etc.), acknowledge that those vaults are then shared across devices, and those devices are used on several wireless networks where we don’t necessarily control security.

Also – if you repeatedly use the same password, your risk goes up exponentially. Suddenly a breach of one password is access to any number of services.

Assess your regular risk

Multiply your devices by the number of password storage solutions and then again by the number of internet access points you access and you’ll see the level of risk which with you regularly work. Imagine adding the number of passwords you’ve saved into this equation.

So safe or not, having multiple tools doing the same thing on multiple wireless networks makes no sense and increases risk simply by multiplying the amount of credentials you have stored across the virtual globe and being accessed while at, say, Starbucks.

So my cleanup began. I decided to sign up for a trial of LastPass which I had heard a lot about, and that trial turned into a subscription. I love it and won’t be turning back. Then I set to work removing password storage from all other services. Follow these directions to have Google forget your passwords so you can also consolidate your credential storage to a single source and be more secure.

From LastPass.com

To improve your security and start trimming down your exposure opportunities specific to Google, you can:

  • Delete individual passwords one-by-one (gives you a chance to see them and save elsewhere if needed)
  • Delete all synced data stored by Google including passwords
  • Delete data from individual Chrome browsers

Delete individual passwords synced across all devices

(not specific to one device’s browser)

  1. Login to passwords.google.com and click “See options”
  2. Toggle off the “offer to save passwords” and “auto sign-in” options
  3. Select one, optionally show and save the password elsewhere, then Delete and OK

Delete ALL synced data from Google servers

(doesn’t delete from individual devices)

This includes:

  • Apps
  • Extensions
  • Settings
  • Autofill
  • History
  • Themes
  • Bookmarks
  • Passwords
  • Open Tabs

Please note this only stops the sync, but doesn’t delete from individual devices. After this you’ll need to make sure you also 

  1. Log in to chrome.google.com/sync
  2.  Scroll to the bottom and click “Reset sync”
  3. Click OK

Delete browsing and saved data from individual Chrome browsers

This isn’t unlike clearing any browser’s history. It’s a good practice to clear browser history regularly on all browsers.

  1. In Chrome, go to chrome://settings/clearBrowserData
    -OR-
    Click the ellipses menu in the upper right of Chrome –> More tools –> Clear browsing data
  2. Click the “Advanced tab”
  3. Change time range to “All time”
  4. Check all boxes
  5. Clear data

Register for the most affordable, premium conference for SharePoint, Office 365 & Azure

As information technology professionals, it’s critically important that we stay up-to-date and practiced in our respective technologies. The North American Collaboration Summit allows you to do just that, and at a fraction of the cost of other premium conferences.

Why you should be registering for the North American Collaboration Summit 2019

One of the greatest things about this conference is that you get to interact with the best and brightest minds in our industry. The very same speakers that you’d meet at other big-name conferences.

A 60-second preview of 8 North American Collaboration Summit 2019 speakers

Oh, and did I mention I’ll be speaking there for the first time? I’m honored to be speaking alongside some incredible professionals and am excited to share a favorite session of mine, “SharePoint Wizardry for Content Management, Archiving, and Retention.”

A 60-second preview of my session at the North American Collaboration Summit 2019

What are you waiting for? Register now, and I’ll see you in March.

MS-100 & MS-101 Exam Study Guides

Update 10/14/2019: My MS-101 exam guide is now available for pre-order. Also, the courses previously listed below are no longer available and have been removed.

If you’re pursuing the M365 Enterprise Administrator Expert certification, you’ll need to pass MS-100 and MS-101, as well as a prerequisite certification (see link for more info). The following study materials will help with preparing for these two exams.

Also, if you haven’t heard, the current MCSA exams 70-346 & 70-347 have retired so the exams below may very well be part of your new path:

Order exam prep books

My exam guide covers every MS-101 exam objective, helping you prepare for taking and passing the MS-101 exam. Includes:

  • Self-assessment example questions at the end of each chapter
  • Further reading recommendations for each objective
  • Exam tips throughout
  • Two 20-question mock exams with detailed answer explanations

Other exam prep books

Order the MS-100 exam prep book (release date May 6, 2019)

Order the MS-101 exam prep book (release date June 27, 2019)

Courses

  • Check LinkedIn Learning for MS-100 and MS-101 topics. You may have better luck searching for specific exam objectives than exam names.
  • Check Microsoft Learn for specific exam objectives.

Note: Previous OpenEdX courses have been archived and are not open for enrollment as of this post’s last update. If you had previously enrolled, you may review the archived course content by logging in.

Other blogs and pages

Ignite overview video


From Ignite 2018: Microsoft 365 Enterprise Admin role-based exam prep: MS-100 Identity & Services – BRK3385

Ready to take the exams?

  1. Buy exam voucher + replay (extra try if needed) on MindHub
  2. Schedule an exam:

Add a new OneNote notebook to a SharePoint site

If your SharePoint site doesn’t currently have a notebook (most likely stored by default in “Site Assets”), you can add a new one in any of the following ways:

In a document library

This is the best option for end-users or site owners adding a new notebook at any time.

  1. Click the “New” button
  2. Select OneNote Notebook
  3. Name Notebook
  4. Click OK

Via Site Feature

This is a good option for administrators creating a new site for a team.

Note: Adds Notebook to Site Assets or default library, but not a particular document library. Also adds a link to Quick Launch.

  1. Site Settings –> Site Features
  2. Site Notebook –> Activate
  3. Notebook is automatically named after the site’s title (e.g. Site Title Notebook)

Moving a pre-existing notebook to SharePoint from a local location

See detailed instructions here.

  1. Select “file” in the upper left
  2. “Share to web or network location”
  3. Navigate to SharePoint library by URL within the move dialog
  4. Rename (if applicable) and click “Move”

By dragging and dropping from a local location or using the “Upload” button in a document library

While not an ideal method, it may sometimes be your only option.

Note: This makes a copy of the Notebook you’re adding – this will not be connected once added and you’ll have two copies of the Notebook (the copy and your original still in its local location).

  1. Drag Notebook from local location
  2. Drop into a document or asset library in SharePoint

Or

  1. Click “Upload”
  2. Navigate to and select the existing Notebook on your computer

If using this option, I recommend deleting/closing the Notebook from your local location, opening the copy from SharePoint and syncing that one so you don’t inadvertently make changes to the old copy.

Move an existing OneNote notebook to SharePoint

Many of us have been there. You have an awesome notebook, your committee wants access, but you stored it on your OneDrive for Business or local machine. How do you move it to your team’s SharePoint site?

In the following tutorial, I’ll show you how to replace the “default” Notebook on a SharePoint site with your pre-existing notebook.

Delete default notebook in SharePoint

(if applicable, and if unneeded. You could also just “overwrite” it by saving your new notebook with the same name, in the same location.)

  1. Go to the library in which the SharePoint site’s notebook is stored (e.g. Site Contents –> Site Assets)
  2. Delete Existing Notebook (check and delete, or use the ellipses menu)

Move pre-existing Notebook

  1. Copy URL from Site Assets or library in which you’re placing your notebook
  2. Open existing notebook on desktop (client)
  3. File –> Share –> Other Web Locations –> Browse
  4. Paste copied URL in save dialog’s address bar, deleting everything after the library’s name
  5. Hit enter to navigate to the library
  6. Rename notebook if you wish
  7. Click Move

Update any navigation links

(if applicable)

Depending on your settings, there are two ways you might update a URL. If you don’t see “Edit Links” on the menu where you’re placing this, you’ll need to go through site settings:

  1. Copy URL of new notebook
  2. Site Settings –> Navigation
  3. Select Notebook –> Edit
  4. Paste new URL
  5. OK

OR

  1. Copy URL of new notebook
  2. Click “Edit Links” on the menu on which you’re placing the link and modify the existing Notebook link (or add a new one)
  3. Paste URL and click Save

Where your OneNote notebook actually “lives”

It can be tricky when you have many notebooks to keep track of where they all live. And nobody wants to be maintaining multiple copies of the same notebook in a save-as nightmare.

Take the time to learn where your notebook is actually saved, and move it if that’s not where you want it without needing to create a copy or break your client’s cached connection.

  1. Open the Notebook in your OneNote client (desktop app)
  2. Click “File” in the upper left
  3. Note the location that matches Notebook name

If you “Share on Web or Network” you’re actually moving the Notebook and its location will be updated immediately. You can still use your Desktop/client OneNote application to edit as usual. Others will just be able to access it now as well.

Note: If you’re moving your Notebook to SharePoint, make sure you save to a complete URL location like above and not a “synced”/OneDrive for Business-type location mapped locally.

“Unable to connect” error when accessing SQL database in Power BI Desktop

When attempting to access a SQL server/database in Power BI, you might get the following error message:

Unable to connect

We encountered an error while trying to connect.

Details: “An error happened while reading data from the provider: ‘Could not load file or assembly ‘System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=…..

Error message received when trying to get a SQL database as a data source in Power BI

Solution

You just need to run Power BI as administrator before attempting to access the SQL database as a data source.

  1. Save your work and close Power BI Desktop
  2. Right click Power BI Desktop and select “Run as administrator”

3. Attempt to access your database again – you shouldn’t have an issue.

“Sync” button greyed out on SharePoint library

If the “Sync” option is not available for a library on SharePoint, it could be a couple different things.

Note: Media and Form/InfoPath Libraries will not sync but you can still open them in Windows Explorer and pin to Quick Access so they will function as a mapped drive would.

Sync button is available in one library but no another on the same site

Go to the library for which the sync button is disabled

Go to library settings

Click “Advanced Settings”

Make sure “Offline Client Availability” is set to “Yes”

Sync button is not available on ANY library on a site

Go to Site Settings and select “Search and offline availability” from the “Search” section

Make sure “Offline Client Availability” is set to “Yes”

Open a SharePoint Library in Windows Explorer and save it to Quick Access

If you can’t sync a library, or prefer not to, you can pin the web location of a SharePoint form, media, or document library to your “Quick Access” panel in Windows Explorer.

This allows you to interact with (edit, replace, delete) the files just as you would in a network drive but requires that you’re connected to your SharePoint environment – there are no offline files in this method.

Access the library in Windows Explorer

  1. Copy URL of library in SharePoint
  2. Open Windows Explorer and paste in URL, deleting everything after the library name
  3. Hit Enter

Pin to Quick Access

You could then right-click “Quick access” on the left of Windows Explorer and select “Pin current folder to Quick Access” to bookmark it for next time