Make Text Easier to Read when Presenting

If you’re ever using Windows 10 to present to a group and they are having trouble reading your text.

Experts recommend a minimum text height of 1 inch (25 mm) for every 15 feet (4.5 m) between the screen and the most distant viewing position in the room.

Luckily, this is easy to do on the fly by pressing <Windows> + <+> to zoom in on the part of the screen with the mouse cursor (just for fun, say “Computer, Enhance” when you do this to wow your audience). 

The default zoom amount can be changed in settings, and conveniently pressing <Windows> + <-> will zoom back out.

This is also a handy tool to know about if you ever need to look at something with precision – such as the detailed alignment of pixels on a screen or the alignment of walls in an architectural drawing.

Salvaging OneNote Notes

Recently my employer switched Office 365 tenants and the migration process they used caused some issues.  One of which was that OneNote notebooks that had been synchronized via OneDrive were no longer synchronizing properly.

The only place I had access to these important notes was in the OneNote App on my work machine.  They failed to synchronize.

Luckily, it’s not hard to recover from this kind of problem, though depending on the number of notes you have, it can take some time.  These steps generally work as a last resort for any kind of OneNote notebook corruption.

The first step is to create a new notebook in a place that can be synchronized.

I recommend a OneDrive (Personal notes) or SharePoint (Team notes) location depending on whether the notes are primarily for personal use or shared with a colleagues.

Open the new notebook in the same OneNote app that contains the notes you wish to move.  To make it even easier, drag the new notebook to the top – and make sure it’s a different color than the existing notebook – I like to make the old one red and the new one green to represent notebooks I’m going to stop and start using.

Now open two OneNote copies side-by-side.  You can use <Windows> + <Left Arrow> to snap one window to the left, then select the other window and snap it to the right.  You can also select it manually and use <Windows> + <Right Arrow> to snap it to the right.

Now open the new notebook on the left and the old notebook on the right.

Sometimes, you can just right click a section and select Move/Copy.

This will open a dialog to select the new notebook, then click the Move button.

Since my notebooks had gotten out of sync, I got the following message.

Microsoft OneNote
The sections you’re moving have not all been synced. Make sure you are online adn fully synced before you move sections between notebooks.
[ OK ]

Microsoft OneNote
Something went wrong and we can’t move that section.
[ OK ]

Since that didn’t work, create a matching section in the new Notebook, then select the section in the old notebook and click the top page in the list.

Then scroll to the bottom of the page list and hold <Shift> while clicking the bottom-most page.

Right-click Move/Copy and browse to the matching section in the new notebook and click the [Move] button.

The old section will now be empty so you can right-click on it and select Delete Section so you are de-cluttering as you move along.

While it is repetitive and can take a bit of time, when you’re done, you’ll have all of your notes rescued in a new notebook.

Fixing Google Home Broadcast

When setting up Google Home Broadcast recently, it worked fine from my Android device, but when I tried sending a broadcast from one of the speakers, I got an error reporting that there were no other speakers on the network.

After chatting with Google Support they were a little confused, but after calling back a second time and trying a few things, we arrived at the fix of factory resetting the Google Home Hub and Google Home Mini.

For the Home Hub, press and hold volume up and volume down for 10 seconds to perform a factory reset.

For the Home Mini, press and hold the orange button on the device base for 12 seconds.

After reconfiguring each device, I was able to say “Ok Google, broadcast ‘test message’” and it was broadcast to all other speakers on my network.

It’s a handy feature we’ll be using often – especially when notifying everyone in the house that it’s time to wake up, a meal is ready, it’s time to leave, or even remotely that you’re on you’re way home.

You can even reply to broadcasts making it a handy home intercom feature.  To learn more, check out the Google Home Broadcast documentation.

Microsoft Teams vs Cisco WebEx for Meetings

Creating a new teams meeting is as easy as clicking New Teams Meeting in the Office ribbon. It’s built-in to Office.

image

Just one click, add a Title, add attendees, and click Send.

With WebEx, you must first create a New Meeting, then add WebEx to the meeting or click Schedule Meeting in the ribbon via with a 3rd party plug-in.  Since it doesn’t fill in the meeting location field, a pop-up needs to be dismissed to send – another extra click.

Converting an existing meeting to a Microsoft Teams meeting is easy as well. Just open the meeting delete the WebEx content in the body (below the line – Do not delete or change any of the following text. –), click Teams Meeting in the ribbon, and click Send Update.

image

Doing so not only results in the Teams meeting experience, but joining the meeting is now easier too.

To join a WebEx meeting, one must first open the meeting, then click the link.  Sometimes one needs to enter their personal info before clicking Join Meeting, and if the meeting is hosted in a personal room, the meeting can’t start without the host (which is a pain if the person is on vacation).  Notifying the host requires a captcha to be entered. It’s just one hassle after another. After all of this, you’re finally able to select the means of connecting to the call. Even if the meeting starts while you’re waiting, you won’t join the meeting until this step is completed.

Contrast this to Teams. If the meeting is selected in your Outlook calendar, a Join Teams Meeting button appears in the ribbon.

 image

Clicking this takes you straight to the audio/video preview to allow you to adjust your settings before joining the meeting and simply pressing <Enter> or clicking Join now adds you to the meeting.

Meeting attendees also have the option of right-clicking the meeting and clicking the Join Teams Meeting option.

image

So there you have it. Teams meetings are easier to set-up, and easier to join than meetings in WebEx, and all of that saved time adds up – so start converting your old WebEx meetings today! Smile

Upgrading SSRS Tooling

Over the years I’ve been told that in order to support SQL Server Reporting Services (SSRS) files (RDL) that I had to install the decade-old Visual Studio 2008 product.

More recently, I came across some info that indicates that this may not be the case, so I’m sharing it here in case it is able to help someone upgrade to current tools.

VS 2008

To work on SSRS reports (RDL files) one needs Visual Studio 2008 with the BIDS extension installed.

BIDS download – https://www.microsoft.com/en-us/download/details.aspx?id=30438

Note

Historically, the Visual Studio shell used to create SQL Server content types has been released under various names, including SQL Server Data Tools, SQL Server Data Tools – Business Intelligence, and Business Intelligence Development Studio. Previous versions came with distinct sets of project templates. To get all of the project templates together in one SSDT, you need the newest version. Otherwise, you will probably need to install multiple previous versions to get all of the templates used in SQL Server. Only one shell is installed per version of Visual Studio; installing a second SSDT just adds the missing templates.

SOURCE: https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi

VS 2017

It may be possible to work on SSRS reports with Visual Studio 2017 via the Microsoft Reporting Services Projects add-on.

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio

This requires the SQL Server Data Tools (SSDT) workflow to be installed via the VS 2017 installer.

clip_image001

Git Fatal: Authentication failed for

Issue

> git pull –tags origin master

fatal: Authentication failed for ‘{repository URI here}’

Resolution

  1. Go to Control Panel\All Control Panel Items\Credential Manager in Windows
  2. Select Windows Credentials
  3. Scroll down to Generic Credentials
  4. Edit git: credentials with updated password

Authentication will now succeed