Fix: Nexus 7 Refusing to Charge

From time to time my Nexus 7 tablet battery will get drained so low that it can’t be turned on and plugging in the power cord will not wake it or even start it charging.  So now your stuck with a tablet that cant turn on, and cant be charged.  Trying combinations of buttons pressed prior and after plugging in the charging cord failed until I found the right combination.

nexus-7-tablet-charging-screen

To charge a dead Nexus 7:

  1. Plug-in you dead Nexus 7 to a wall charger.
  2. Immediately after plugging it in, press Power and Volume Down buttons at the same time.
  3. It may take several attempts till you get the timing sequence just right.  When it works, 1 of 2 things should happen.
    1. The bootloader menu should load, use the Volume Down until you see “Power Off Device”
      • Choose that option with the power button.
      • Once the device is off, unplug the charger and then plug it back into the device
      • You should now see the battery meter (pictured above) showing it is charging
    2. You should now see the battery meter (pictured above) showing it is charging.

I hope this helps you with you dead Nexus 7.  In the future, we should all make sure to not our Nexus 7 completely run out of power.  When you see it get close to 10%, start charging it.

LG G4 Camera Review

I recently upgraded phone plans with a new LG G4 smart phone.  It was a toss up between Samsung Galaxy S6 and the LG G4, but there was a sweet deal to save $200 off the phone price if you trade in a used smart phone.  So, I have been quite impressed with the phone and it’s camera (the only smart phone at the moment that can take pictures in RAW.  The camera is quite responsive and snappy (my daughter managed to take 22 pictures in 2 or 3 seconds).

From indoor still shots with low light to outside daylight scenery shots, the camera does a great job.  It is after all just a phone camera, so keeping in mind what your light source is, and where it is in relation to your subject is still important.

20151126_141942   20151126_142010

20151127_105923   20151127_110000

20151127_112424   20151127_112758

20151126_150933

Just the other day I took some pictures outside at night (with a church light up) and inside the church (with dim lighting at best) and the camera (or rather its Auto HDR setting) really impressed me.  Sure there is noise in the picture, but wow it did a great job.  Adding the ability to capture images in RAW, allowing for greater tweaks and edits of the image, just makes this camera a little sweeter.

20151129_185503_HDR   20151129_185653_HDR

20151129_190418   20151129_200755

20151129_200842   20151129_201031

Beautiful Sunrise

Beautiful sunrise while driving my sweet girl to school this morning.

20151007_070815

 

Google Photos Assistant generated this rendition of the same picture for me, I kinda like it.

20151007_070815-EFFECTS

Photography-Cross Country Runners

I recently had the opportunity to photograph the Southwest High School Cross Country runners in a meet.  This is the first time photographing a running event.  Fortunately the weather was just perfect.  The sun was at a good point on the horizon, but the light was still a bit harsh at times.  What I didn’t notice at the time of the event taking pictures was the varied differences of how the runners run and their intensity.  I put these first to pictures first because I like the expressions I captured on their faces as one runner tries to maintain his lead while the other is striving to take the lead.

DSC_8025

DSC_8027

DSC_7947   DSC_7955

DSC_7965   DSC_7966

DSC_7973   DSC_7977

DSC_7990   DSC_7997

DSC_7999   DSC_8007

DSC_8022   DSC_8036

DSC_8061

Eagles Nest and Wintertime

Near Hanover, PA, the PA Game Commission has set up a live video stream of an Bald Eagles nest.  The eagles are taking care of 2 eggs.  It is amazing and fun to take a look and watch for a while.  The Bald Eagles sure are beautiful. 

Recently a winter storm went through the area and we had the opportunity to observe the Bald Eagles taking care of their eggs while 5 or more inches began to pile up on the nest.  There was amazingly little movement while the snow accumulated.  Late in the day the other parent eagle stopped by (the male I assume), gave the snow and ice covered mother eagle a chance to stretch her legs and wings, but a few minutes later she was snuggled back down in the snow with her eggs.

I have been fascinated by checking daily (or a few times daily) and observing the Bald Eagles.  This winter storm just heightened my interest, and I just had to grab a few screen shots of the video stream.  Here is a link to the live stream and below are a few screen captures of the event.

 

Moments before the snow began to fall, it was misting and raining and the mother Bald Eagle was laying low getting ready for what the storm may bring.

EagleBeforeSnow

EagleDuringSnow01

EagleDuringSnow02

EagleDuringSnow06

EagleDuringSnow07

EagleDuringSnow09

EagleDuringSnow11

EagleDuringSnow12

EagleDuringSnow13

EagleDuringSnow14

The mother Bald Eagle is standing on the left, with snow and ice clinging to her feathers.

EagleDuringSnow17

EagleDuringSnow18

EagleDuringSnow19

EagleDuringSnow20)

EagleDuringSnow22

The mother Bald Eagle is back down in the snow and father eagle waits momentarily before flying away.

EagleDuringSnow23

EagleDuringSnow25

EagleDuringSnow26

EagleDuringSnow28

The snow has stopped…

EagleDuringSnow29

EagleDuringSnow30

EagleDuringSnow31

Mirror Lake on a cold morning

Another cold frosty morning and the lake was flat and smooth, like a mirror.  There is something about the quietness of the morning beside a lake, that begs you to stop, look and listen.  There are not flowers blooming, no green or colorful leaves on the trees, but still beautiful in it’s own way.

Unfortunately I did not remember to bring my good Nikon, I sent my self a reminder and I still forgot, so again these pictures are taken with my LG Volt camera phone. 

2015-02-12 08.00.40

2015-02-12 08.00.30

2015-02-12 08.02.53

2015-02-12 08.03.36

If you look closely at the picture above, you may notice I just so happened to capture a pair of Canadian Geese about to take flight out of the lake.  The image below I cropped to show the Geese a bit more.

2015-02-12 08.03.36-2

MERGE command in SQL

I just recently started using the MERGE command in SQL.  You would use this instead of a IF, Then, Else statement.  It doesn’t make sense to use this in place of If, Then, Else all the time, but in certain circumstances.  My example is repetition in checking, then inserting or updating data, across Development, Stage and Production servers, that for some reason may not be consistent or the same with regards to their data in the same table. 

So… If I have 20 records that need to be inserted or updated, depending if this is the first time running the command or the Nth time, this comes in handy.  The values in the USING statement, can be referred to by variable names for the rest of the MERGE statement, using the Source prefix in both the Join statement and the Insert statement.  Based on the code snippet in the image below, I can code this once, then copy it and only have a minimum amount of changes for the next attribute. 

Although this may be more verbose compared to most If, Then, Else statements, it is very handy when managing large amounts of data across multiple environment that may be out of sync (but that is another compliant for another day)

1 MERGE dbo.SurveyAttributes AS tgt 2 USING (SELECT '5CEFDA70F5A44844A254A646C9EDFC93' AS CtelAccountID, 'UseFlexScoring' AS AttributeType, 651 AS SurveyID ) AS Source 3 ON (tgt.CTelAccountID = Source.CtelAccountID AND tgt.AttributeType = Source.AttributeType AND tgt.SurveyId = Source.SurveyID) -- join condition 4 WHEN MATCHED THEN 5 UPDATE SET AttributeValue = 'TRUE', ChangeDate = GETDATE(), Active = 'Y' 6 WHEN NOT MATCHED THEN 7 INSERT (CtelAccountID, AttributeType, AttributeValue, SurveyID, DateCreated, ChangeUser, ChangeDate, Active) 8 VALUES (Source.CtelAccountId, Source.AttributeType, 'TRUE', Source.SurveyId, GETDATE(), 'GLOBAL\BLACKJR', GETDATE(), 'Y') ; 9