Technology Lessons Learned: About this blog

An attempt to give back to the programming community; this is my way to share knowledge.

As you search for similar issues, I'm hoping that my posts will come up in the search results - thereby allowing you to learn from my mistakes, and see the solutions that I chose to implement.

This blog focuses on coding issues, however there will occasionally be other topics (specifically: entrepreneurship and non-programming app development issues).

My personal website can be found at www.stevesohcot.com .

SSRS report permission error – rsAccessDenied

One of my users couldn’t get to an SSRS report.  I thought I had given permissions correctly to the parent folder it was in, but they got the error “An error has occurred during the report processing. (rsProcessingAborted) … the permissions granted to user [user-here] are insufficient for performing this operation (rsAccessDenied)”

The solution

This particular report was using a “Shared Dataset”.  In the Shared Dataset folder, I had to grant the same permissions – even though the report folder already had the required permissions.

Read the article

mouse pad not working orange light

On my work laptop, I was asked about the mouse pad not working.  There’s an orange light at the top left of it (I guess indicating it was “off”).

Double tapping the orange light (with my finger) activated it.

Read the article

MS Outlook keeps crashing

I’m sure this is related specifically to how the computer was set up through my company, but ever since I got a new computer (upgraded to MS Office 2013), my MS Outlook crashes at least once a day.

 The issue was that I have a PST file stored on a network drive (as opposed to my local drive).  Removing this PST file coincidentally solved the issue of my MS Outlook crashing daily.

Read the article

mysql update field to random string

I needed to update all fields in my database to a random value.
RAND() returns a random number between 0 and 1
MD5() creates an alpha-numeric hash, that is 32 characters.
I ended up with:

select MD5(RAND())

…You can add a SUBSTRING() on there to ensure you get only a certain number of characters.

Read the article

Error notifications for users who cannot log in to a site

I recently read an article about notifying users when they have an invalid username/email or password.

The thinking is, if there’s an invalid username/email or password, you shouldn’t even acknowledge that the username/email was correct.  This will confirm to a hacker that the username/email does exist, thus they have part of the credentials needed to log in.  I even mentioned this as a “best practice” in my PHP book.

The article I just read though is against this concept, thinking that most hackers can already determine the username/email just by trying to sign up with that same entry.  When they find that they cannot, they will have confirmation that the username/email is in use.  As such, the article suggests you should be more explicit in your reasons for not being able to log in.

However I recently found another alternative for this.  There was a service that I wanted to sign up for, and I not only didn’t know my password, but I didn’t know if I had an account.  Upon signing up, I received the following text (on the website).

“Your request has been processed. In order to maintain the security of your account, you will receive an email containing a verification code and a link that will allow you to set a new password. You must follow the instructions in the email in order to set a new password.”

Then in the email I received, I was told that I never had an account!  Yes, the original article had some other tips, but I thought this was a clever work-around for that specific point.

Read the article

Word Press homepage to display latest blog posts and introduction

On this very blog you’re reading, I wanted the homepage to have a description of what it was about; basically, the contents found in the “About” section. I tried changing the “appearance” of the Word Press theme to have a specific “static” page as the homepage, but then I needed to add in the latest blog posts (dynamically).  I was able to do that, but then I couldn’t have the pagination.

This article started me off, but I ended up doing everything in PHP code.

Solution:

Appearance >> Editor.  Edit the “Main Index Template (index.php)”

Check to see if you’re on that page AND you’re on “page 0”, then you display the desired content (lines 4 – 13):

By the way: if you thought this blog post was helpful, check out the book I wrote on PHP, geared toward intermediate web developers.

Read the article

  • 01.07.2018
  • PHP

Design Tips for a web developer

I recently had the opportunity to work with a web designer, and I was able to see his screen as he worked.

During our session, I saw him to go to the following sites that seemed pretty helpful:

  • TinyPNG.com – reduce the file size of images without reducing the quality
  • GradientFinder.com – gives the CSS of a color-fading gradient (where you specify the colors)
  • Coolors.co – color scheme generator
  • FreePik – free art/stock images

Read the article

Excel REF error

I recently received an email:

i’m trying to combine 2 files i received and everytime i delete a row i don’t need it messes up the calculations. what did you do that time to keep the numbers and not have them change to REF…….?

The data happened to be filtered, and there were some calculations; and my coworker had issues.   The solution was to copy and paste special >> values.  Doing this preserves the “values”, and even if you delete other rows/columns (that a formula would have relied upon), the values will remain intact.

Read the article

SSRS reports not showing null values

I had an SSRS report that was not displaying the right data.  I narrowed it down to, that the NULL values were not showing up; even though I did LEFT JOINs, and used the ISNULL() function in both the SELECT and GROUP BY clauses.  The issue though was with my WHERE criteria.

My criteria was something similar to:

WHERE field_name LIKE @parameter + ‘%’

The solution was to put the ISNULL() function in the WHERE clause!

WHERE ISNULL(field_name,”) LIKE @parameter + ‘%’

What made it harder to troubleshoot was, the SQL worked fine in Management Studio (it gave the expected results) … however only in Reporting Services was it not showing the right values.

Read the article

ssrs no dependent items for shared dataset

And the other thing I searched for was “ssrs The reference for the shared dataset not valid

I was having trouble with my Reporting Services reports (specifically, the shared dataset).

The Solution:

On the deployed server, manage the specific report.  Under “shared datasets”, you’ll see (one of) the shared data set that is giving the error.  “Browse” too it, and re-link too it.  I haven’t checked yet if re-deploying the specific report will mess it up (as, re-deploying the report AND the shared dataset didn’t solve it in the first place).

Read the article