iPads and Kids

If you had kids, and an iPad, they may try to unlock it themselves. You may run into a situation where you see something like this

Image result for ipad is disabled
This is a representation of what my iPad just looked like.

In this case, there are two things you can do. Well, besides waiting 1 million years.

  1. If you have find my iPhone set up you can remotely wipe it. That works if the iPad is connected to Wifi.
  2. If you have your computer, you can connect it, open iTunes and hard reset it. iTunes will ask you to update or restore. Restore it. You can then set it up fresh or restore from backup once it comes back up

Seems like this is a problem that should be solvable somehow 🙂

What I’m Using – January 2019 Edition

I like to change up my setup and process on a regular basis. Android, iPhone, Windows, Mac, Apps & Services, etc. Here is what I am using, January 2019 Edition

Devices

Phone – iPhone Xs Max 256 Gb AT&T running iOS 12.1.2. Backup: OnePlus 2 running the latest Android OS it allows.

Work Machine – MacBook Pro 15 in 2015 Edition (no dongles required!) running macOS Mojave (Beta). Bonus: Windows 10 Enterprise Oct 2018 edition VM in Parallels.

Home Machine – Surface Pro 3 running Windows 10 Insider Edition. Have an OLD 2011 iMac that is on it’s deathbed.

Bonus: iPad Air 2 used for reading books to myself and the kids, and just playing with iPad stuff

Gaming

Nintendo Switch – playing Super Smash Bros Ultimate, Mario Tennis Aces, Mario Kart, Mario Party, as well as NES games on Nintendo Online. Looking forward to new Mario game and Metroid! I am Supernova on Nintendo Online

Playstation 4 – playing God of War, Last of Us. Just finished Red Dead Redemption 2 recently. Have Spider-man on queue for the winter! I am ScaleOvenStove on PS Network.

Xbox One – haven’t been playing much here. Unravel. Was doing the Telltale Walking Dead series, waiting for the last chapter to come out after the layoff drama. I might get Red Dead Redemption on Xbox as there is backward compatibility. I am ScaleOvenStove on Xbox live.

Other – SNES classic – been playing some SNES Zelda as well. on iOS played a little Fire Emblem Heroes but haven’t gotten much into it.

Entertainment

Apple TV 4 – this is my go to entertainment device. We have cable since we moved into our new house but I don’t watch cable, I just hook up all the apps on the Apple TV to stream. Mostly sports there.

YouTube is my main viewing channel though, I do have YouTube Premium as I hate ads!

MoviesAnywhere is also a great service as I have videos on Google Play, Amazon and iTunes, but can watch them anywhere.

Apps & Services

Home: iMessage, Gmail, Google Photos, Google Maps, Dark Sky, Nest, YouTube, Apollo (Reddit), Twitter, Apple Music. Lots more niche or specific apps, these are just the highlights.

Work: Slack, Microsoft Teams, Yammer and Outlook, OneDrive and a few others.

Notables: Deactivated Facebook and Instagram. Deleted the apps, and Snapchat app. WeChat as well. Facebook has too many privacy issues. My phone battery life and my attention span thanks me. Maybe someday I will go back.

Wishlist: Apple Music on Google Home devices. I used Google Home devices around the house, and Google Play music is OK, but their implementation on iOS is bad.

Summary

There are a bunch of different devices and services out there, I like to move things around. Going full on Android might be something soon, with a Pixel 3 or something, but iMessage is such a pull back into iOS. A little cross device and platform compatibility would really make things easier for people that aren’t tied to any platform. We can only hope one day things are better for consumers!

The State of Parental Controls going into 2019

Kids are now growing up in a digital age. Screens are part of their lives from day one. As they grow, they want to use devices and play games and do whatever everyone else is doing. I am not going to debate if this is a good or bad thing – but it is a reality. 

Major tech companies have taken notice and they have been (and still are in progress) releasing ways for parents to keep tabs on their kids’ device and screen time usage. 

Of course, the big three – Apple, Google, Microsoft – have their solutions. Also other players like Facebook, Nintendo, Sony have solutions for their products as well.

Apple

Let’s start with Apple. There are few different things Apple has had and now just recently came out with to help parents. Up until iOS 12 they had “Family” groups you could create – not so much for managing screen time, but for creating a group where family members can share purchases, location, etc.

As a parent you can set up an Apple/iCloud account for a minor and then incorporate them into your “Family”. A parent also had to set up “restrictions” in iOS settings for each device for a kid. Kids can ask permission to install apps, and parents devices get an alert to allow or deny. 

What NOT to do: I have seen too many parents just sign in as themselves and give their kids a device. Please DON’T do this! Kids can really mess up your accounts. Another thing would be just giving kid unmanaged device with no account. You lose a lot of shared benefits of having an account for your kid under your family.

With the latest release Apple came out with “Screen Time” – for users to manage their own digital wellbeing on their own devices, but this also lets parents manage screen time on kids devices under the family group. 

Screen Time - Kid Device Management

You then get a weekly report of Screen Time for your kid and can change settings etc through Screen Time on what apps are allowed, etc. 

So, what’s missing? Well – for one – some devices have TouchId or FaceId – how does a parent set that up and still get into a device physically? Up to you. For now on my family devices, no passcodes or 2 factor auth – it is just too much overhead and messy to manage with kids. 

Google

Google has something similar for managing kids devices – it is called “Family Link” – but you need to install and configure it. Similarly to Apple screen time you can manage what apps and time spent and other settings on devices. It works on Android devices so if you are running a Google Android device but your kid has an old iPad or iPhone you are out of luck. 

Google Family Link App

Recently they announced you can run Family Link on Chromebooks (ChromeOS) as well – but I have yet to get this working. It is supposed to work similarly to Android where you can manage the apps and see usage, set screen time etc.

I have found that Google support around Family Link is more responsive than other Google support I have tried to reach out to, but I still cannot get it working on my daughters Chromebook.

One thing to note as well, and maybe I can follow up on this one after I get it working – but you need to create a google account for your kid (just like Apple). If you manage it, it should be okay. But – your kid might already have a Google Account through their school district. It starts getting tricky here. You as a parent cannot “manage” that account. I think there is a way to link them. So the kid would login to your Chromebook with their kid google account, and then still be able to get to google classroom or login to chrome (google docs, etc) with the school account. Time will tell. It is messy right now.

YouTube (owned by Google) is another story. YouTube is really a cesspool of crap if you get down the rabbit hole. There have been many articles and cries for help to Google/YouTube to let parents better regulate what their kids see. YouTube STILL doesn’t let you block entire channels. This is a big miss.

Also, if you have shared devices (like an Apple TV, etc) with YouTube and you login as the adult – the kids sees your recommendations. What kids watch screw up your recommendations. Switching between accounts is not easy (Netflix does this pretty well).

YouTube Kids is an app that is made for “kids” – and is supposed to filter out junk – but it isn’t foolproof. Parents are usually going to take the easy route, and YouTube website/main app etc are going to be the go to. In my opinion – the filtering on YouTube and parental control is one of the big problems Google needs to tackle, and soon.

Google also has a bunch of features, not so much parental controls, that they are coming out for around Google Home around reading books with your kids, stories, etc. Try them out sometime if you can, they are pretty cool. With four kids in the house, reading to one of them, while one reads themselves, while the other says “Hey google, tell me a story” is a lifesaver, especially when one parent is away for an evening.

Microsoft

Microsoft has very similar setups to Apple and Google – but of course a little different. With Microsoft, you can setup an account for your child and tie it to your “family” – but you can use an existing email (so if you have a gmail or icloud from Apple or Google you can use that).

Microsoft Family Home Page

The only real devices you can manage from Microsoft are Windows devices and Xbox.

You can allow a child to login to a Windows device and restrict time and apps. One big miss here though is that you can only manage web browsing with Edge, and not other browsers. My kid uses Chrome – because they are used to it with Google Chromebooks at school, but I cannot manage their browser usage, etc. Big bummer

Managing Screen Time for Microsoft Devices

With Xbox you can manage screen time and game limits and ratings, etc. Works pretty well

Nintendo

Nintendo has an app you can download and tie it to your Nintendo switch. You can use it as parental control and set time limits and game limits etc. I don’t use it for that as I manage that pretty close directly with my kids but a nice feature of the app is it tracks play time, and that is good even to see for myself!

Nintendo Parental Control App
Nintendo Switch – Play Time

Facebook

Facebook. Not sure on this one as I deactivated my account recently and I am about to jump ship due to their creepiness, scandals, privacy issues, etc.

I did try out Facebook Messenger for Kids this summer. It lets your kid sign up just for Messenger for Kids, not Facebook. They can add their friends, but both kids parents have to allow it. Also, parents can limit usage time and also install the app on their device and see all messages, etc.

This app works well if your kid wants to message their friend from their old iPhone using iMessage – but their friend has their parents old Android device and it won’t work.

Netflix & Hulu

I mentioned it earlier, but Netflix does have a way to create a “profile” that is deemed “kids” and is pre-filtered to kids specific shows. You can set it for “little kids” or “older kids and younger”. This works fairly well in practice.

It is easy enough for kids to just change profiles though. Maybe having non kid profiles pin controlled would be a good addition? Also, we have one for “Family” that has things we might all watch together vs just Paw Patrol episodes 🙂

Profile for Kids in Netflix
Edit Profile – Kids – Netflix

Hulu has a very similar setup. Profile for kids, can see kids shows.

Choose Profile Screen on Hulu – Web
Set Programming to “Kid Friendly” – Hulu

Sony

Sony has a way to set up parental controls on Playstation. You can set up a profile for your kid – but you need an email address. You can restrict games and screen time, etc.

I have a Playstation but haven’t set these up myself as my kids don’t play on it. Yet.

Amazon

Amazon has a way to set parental controls, I really can’t speak to them as I have no real Amazon devices where you set this up – but here is a link to assist if you’ve read this far.

Summary

Okay, so there is a lot going on here. Your mileage may vary. Your family is going to be different than mine. More or less kids, different ages. Also, your tech profile won’t be the same. Different devices, platforms and operating systems.

As you can see, for the big companies, you need to set up an email address for your children and manage their profiles, and connect them to your family. Then they offer you ways to restrict time on devices and also different types of content, etc.

There are also ways some of the smaller or ancillary players let you manage children use time and parental controls. I hope you found this useful, hit me up in the comments with any questions!

Shut Up And Dance: Scammers using hacked passwords to extort money

Below is the email I received yesterday. Posting here so hopefully others will google and find and know this is a scam. Do not pass go, do not transfer 200 bitcoin.

For those that have watched Black Mirror – this reminds me of this episode.

Let’s cut to the chase. I do know is your password. Most importantly, I do know about your secret and I have proof of this. You do not know me and nobody paid me to examine you.

It is just your misfortune that I discovered your misadventures. The truth is, I actually setup a malware on the adult vids (porno) and you visited this site to experience fun (you know what I mean). When you were busy watching video clips, your web browser initiated functioning as a Rdp (Remote control desktop) having a keylogger which provided me access to your display screen as well as webcam. Just after that, my software gathered your complete contacts from messenger, social networks, as well as mailbox.

After that I gave in more hours than I probably should have into your life and generated a double display video. 1st part displays the recording you had been viewing and second part shows the capture of your web cam (its you doing inappropriate things).

Frankly, I am ready to forget about you and allow you to move on with your regular life. And my goal is to offer you two options that can accomplish that. Those two choices are with the idea to ignore this letter, or perhaps pay me $2700. Let us explore these two options in details.

Option One is to ignore this e mail. Let us see what will happen if you take this path. I will certainly send out your video recording to your entire contacts including relatives, colleagues, etc. It does not shield you from the humiliation your family will feel when relatives and buddies uncover your sordid videos from me.

Option 2 is to send me $2700. We’ll call it my “privacy tip”. Let me tell you what happens if you choose this option. Your secret remains your secret. I’ll destroy the recording immediately. You keep your lifetime that nothing like this ever happened.

At this point you may be thinking, “Let me call cops”. Let me tell you, I have taken steps to ensure that this e mail can’t be traced returning to me and yes it will not stop the evidence from destroying your health. I’m not looking to steal all your savings. I am just looking to get compensated for efforts and time I put into investigating you. Let’s hope you’ve decided to produce all this disappear and pay me my confidentiality fee. You will make the payment by Bitcoins (if you don’t know how, search “how to buy bitcoins” in google)

Transfer Amount: $2700
Receiving Bitcoin Address: 1HbpwLWbk4a*WjTsB272WquDq1eRnoxsHaA ( You must Remove * from this string and note it carefully)

Share with nobody what will you use the bitcoin for or they will often not give it to you. The procedure to have bitcoin may take a couple of days so do not procrastinate.
I have a special pixel in this message, and at this moment I know that you’ve read through this email. You now have two days to make the payment. If I do not get the BitCoins, I will definitely send out your video to all your contacts including relatives, coworkers, and so on. You better come up with an excuse for friends and family before they find out. Nevertheless, if I receive the payment, I’ll erase the recording immediately. It is a non-negotiable one time offer, so do not waste my time and yours. The clock is ticking. Let me remind you, my software is going to be sharing the actions you take when you’re done reading this email. Let me assure you that If you do something suspicious I will send out your sextape to your friends and family, co-workers before time finishes.

I wonder how many fall for this scam. The password was a password I used, maybe 7 years ago on a site that got hacked, before I used a password manager and had unique passwords on every site.

My feeling is that reporting as SPAM or Phishing in gmail isn’t enough here. There should be some way to report this to a broader type of scam.

Thoughts?

Internet Explorer YouTube Embeds Duplicate Closed Captions

Ran into a funky issue recently with Internet Explorer, YouTube embeds and duplicate closed captions (CC)

subtitles

Videos that you use closed captions (CC) on work fine in Chrome, Firefox, even Microsoft Edge, but some videos, some times, in some areas of the video would duplicate closed captions in Internet Explorer 11.

The fix for this is to use an iframe embed for Internet Explorer and you will no longer see duplicated CCs. The more you know!

Garmin 1000 – USB Mass Storage Mode

This past weekend, I decided to do a bike ride from Sun Prairie to New Glarus.
https://connect.garmin.com/activity/embed/816793841

I have ridden my bike from Sun Prairie to Madison plenty of times so I knew the route about half of the way. What I didn’t know was the best route from Madison to New Glarus, as there are many routes.

So I got a few routes from @chdbrwn via MapMyRide. I exported them out and tried to get them on my Garmin 1000. No dice. Hooked up to the computer, Garmin wouldn’t show up. Tried a few different computers, nothing.

Then it dawned on me.. am I using the right cable? Well, turns out I wasn’t. I have a ton of USB cables and I was using one of the many, which with the Garmin 1000, would charge it if hooked to the computer, but it wouldn’t show up as a device or sync with Garmin Express. Syncing is fine since I usually sync over wifi or via the phone connection.

I found my “official” Garmin cable and it showed up right away. Now, to get the files on there. Previously on the Garmin 810 you could just copy into “Courses” or “Rides”, etc and files would show up. Turns out on the 1000 you need to put the files in “NewFiles” folder on the device and reboot, and when it comes back it, the Garmin will process them and they show up on the device. Great!

But, the file I exported from MapMyRide turns out didn’t have any cues (basically turns), so I was riding just looking at the line on the map the entire ride.  I could have used RideWithGPS to add cues, but I tried their “Write to Garmin” and it wasn’t working, not sure it was putting things in NewFiles either.

Seems like turn by turn and mapping/routes shouldn’t be this complicated in the year 2015.

Bottom line, make sure you have the right cable, and also set up your cues on the route file before importing. Happy Riding!

Microsoft Business Intelligence Now and Into The Future

10 years ago, it was SSIS/SSAS/SSRS

Then in 2007 SharePoint, PerformancePoint/SSRS

Then in 2010 Power Pivot in Excel/SharePoint, then Power View in SharePoint

Then in 2013 Power BI … Power Pivot, Power View, Power Query, Power Map.. In Excel and Office 365.

Now in 2015 Power BI Version 2. Not in Office 365, separate. Power BI Designer, or use the Power BI web site to set up your dashboards, mobile, etc.

All the while, the existing solutions that have been available previously are still there and available, making things… well, confusing to say the least.

Most shops .. It all depends on when they started going heavy BI with the Microsoft tools, on where they land. Also, how well they could move when things change, as well as how much they want to stay up to date with the tools.

If you started 10+ years ago, you probably have a good base of ETLs written in SSIS, as well as many multi-dimensional (MD) OLAP cubes in SSAS, and SSRS reports off your cubes and data warehouse, running in SSRS Native Mode. You started with SQL 2000 if you were lucky, with cubes and dts packages, but then SQL 2005, then 2008, 2008 R2, 2012, 2012 R2 and now are on 2014. You really liked 2005 SP2 and 2008 R2 for the BI features :). This setup is like the VB6 or .NET Winforms of BI. It will probably be around forever in some way shape or form but not a ton of updates and Microsoft has moved on.

If you started a little later you might have SSRS in SharePoint mode, and some Performance Point dashboards. You might have even used Performance Point for planning/budgeting (and loved it?) until Microsoft killed it. Then you had to look for alternatives for that, or use OLAP Cube Writeback. In my opinion, SSRS in SharePoint and Performance Point are dead. Not dead as in they don’t work or won’t be supported, but I see them as the wrong path, life supported direction. If you are still using these heavy I would look for alternatives.

Now it gets interesting. You started with Excel 2010 and PowerPivot (no space!) and had SharePoint 2010 setup and Power View in SharePoint. You created V1 Power Pivot models, they were limited, you could do some things, but still it was limited. You still needed to get data somewhere so SSIS ETL’s or something to get data in tables you can use. If you are using Power View in SharePoint, I would hurry up and look for alternatives, it is dead (my definition of dead like SSRS/PP in SharePoint). Excel 2010 is long past and V1 PowerPivot is dead too. Seems like this era was short lived and just a stepping stone.

Then, in 2013, Power BI. So they added a space to Power Pivot 🙂 .. And made it better, v2. Added missing features, Tabular SSAS cubes even! And Power View could be used in Excel. They both came by default in Excel (depends on version) but turned off. Power Query came out of nowhere and is awesome and Power Map, while buggy, was better than nothing. But what do you do with all these solutions you build? Where to publish? Not SharePoint on prem? But Power BI in SharePoint Online.. So you need Office 365 and Power BI subscription. You set up Data Management Gateway so you can get to your on prem data sources. You can refresh once a day or manually. You can do some pretty cool things, create workbooks with pivots and Power Views.

But you are missing things. Missing things like the ability to schedule a report to run and email someone, like SSRS. You are missing awesome formatting abilities for every pixel like SSRS. You wonder when SSRS is going to come to Power BI or what your options are… you hope you see iterations and features released to Power BI as that is the path, but then..

New Power BI Preview comes out in 2015. It has a standalone Power BI Designer (reminiscent of the Performance Point designer) that lets you create reports, dashboards and save a file to publish to the NEW Power BI portal. So you have two Power BI portals.. New and old. They don’t overlap or talk to each other, the licensing is different, etc. The old Power BI lets you connect to SQL on prem with refresh with the DMG and other data sources, etc. The new one does not. The new one lets you connect to GitHub and SalesForce and Marketo, but not other data sources that the old Power BI did. The new Power BI lets you connect to on-prem TABULAR SSAS cubes with refresh, but not MD ones (yet). The new Power BI lets you connect to excel data in OneDrive/OneDrive for Business. So could one publish a data file out to ODFB to faux refresh? I have yet to try. The new Power BI lets you publish dashboards to the iOS Mobile apps and also  embed (up to 10 MB – which needs change to be bigger) on websites. New Power BI has an API that lets you create your own connectors / REST API for things. And the list goes on and on.

So where does that leave us? Well, of you invested time and money in BI the last 10 years, you might feel like Microsoft is abandoning you. It kind of seems that way. You need to change or get left behind. But what do you change to? Change your MD cubes to Tabular? Rethink your architecture? Sync data to Azure?  Power Pivot/Power Query? Abandon SharePoint as a BI tool? Move your reports from SSRS to something else or Power BI (if you can?) I am unsure. Still trying to figure it all out.

One thing for sure is, it will always keep evolving. Me, I would say, tabular first if you are on prem. Try to use Power BI where you can. Minimize SSRS reports. Use SSRS native instead of SharePoint. Stop using PerformancePoint if you are still using it or thinking about it. I bet at some point SSRS comes to the new Power BI – there is an item on the UserVoice forum already asking for it. Try the Power BI Designer and Website and see what you can do. Always be trying to get something going in the newest and latest technology/tools available.

Have Fun with Microsoft BI now and what is yet to come!