Skip to main content

Here's to One of Many Blog Posts

As the end of 2017 neared I decided there had to be some changes in my professional life.  I wasn't sure exactly what kind of changes were needed but after 22 years of software/web development (17 with my current employer) it was time.

At my first place of employment, I developed primarily in Visual Basic with Access as our database.  We eventually transitioned to SQL Server right before leaving there.  I'll cover more about what I accomplished there in a later Blog post.

And now after about 17 years with my current employer, I transitioned into more into web programming as we have developed our own internal intranet with software fit to meet the needs of our business.  We still use Classic ASP, yes I know, but when something's not broke, don't fix it right!?  Working for a smaller company, not as many changes are needed when it comes to software development.  So, we still use Classic ASP, and I have pretty much becoming an expert in it using VBScript, JavaScript, and various pieces of jQuery.  We also use SQL Server and I have become pretty verse in Transact SQL as well. (I will touch base on the detail of my work here later)

So that brings us to today!  January 2018.  Sometimes you get in a rut of doing the same thing over and over.  Writing queries for reports, troubleshooting small bugs, etc.  Then as you get another year older, you're like, wait, is this what I'm going to do the rest of my life?  The same ole code, the same ole routine. 

I consider myself a self motivated individual but sometimes we are comfortable with what we know.  So, I decided it was time to learn more coding languages, read more books in the field of software and technology, become involved in networking groups, and try to grow more professionally not just in the field of software development, but as an all around business person.

So, I did some research and made some goals for 2018.  One of those goals was to read more books in the software/tech industry. I came across the book called Soft Skills - The Software Developer's Life Manual by John Z. Sonmez.  First, let me say that this book is really good!  It doesn't talk about code but it does talk about the intangible skills necessary to succeed.  It definitely help show me a different perspective for software developers.

And, one of the suggestions in the book was to start a blog!  So, here I am starting my blog, and hopefully it's my first post of many!  So thank you John Z. Sonmez for the great book and the great ideas within it!  You can find John's book (along with some other books) and his blog by clicking here


Comments

Popular posts from this blog

Alexa Is Listening, Recording, and Sending!

Check out this story where a couple in Oregon was having a private conversation and Alexa recorded and sent the conversation to one of their contacts!  They were not aware until the contact contacted them about what had happened.  The couple contacted Amazon and they verified the series of events.  But what's even more bizarre is the couple wanted to return their Amazon home devices but Amazon has not agreed to return the costs for the devices! Check out the article here  by Bruce Brown on  Digital Trends

Nonclustered Index in SQL Server

So, I've run into an issue with one of my queries because it takes about 40 seconds to run and according to the Recent Expensive Queries section of the Activity Monitor in SQL Server, there is a section of code taking up about 51% of the query.  First, let me say that I've been writing Transact SQL for quite awhile but have never ventured into the Clustered and NonClustered areas of forming Indexes.  I do use indexes on all my tables but that's just the regular Primary Unique key.  We've been using this query for awhile and it does work but when the result set is about 5K records it takes a little while to run.  So here's the actual query itself SELECT PartNo , SerialNo , HeciCode , ScanDate , OrderType , PoNo , po . IssueDate , SoNo FROM ScanHistory sh WITH ( NOLOCK ) LEFT OUTER JOIN trkRWPOHeader po WITH ( NOLOCK ) ON sh . PoNo = po . PONum WHERE len ( PoNo ) > 2 AND ScanDate >

Staying Fit As a Software Developer

One of the things I love about John Sonmez's book Soft Skills is that he has an entire section dedicated to Fitness! Fortunately, I've always been someone who has been active.  I played sports in high school, intramural sports in college, and still stay active playing golf, basketball, softball, skiing and more.  I also workout almost every weekday.  How does this help me? Well, for starters it helps me stay in shape.  As a software developer you're sitting at a desk a lot!  You can't burn many calories sitting at your desk!  My usual weekly routine is to workout every weekday for about 45-60 minutes.  I'll mix in free weights and some circuit training.  I might run a few miles here and there, but usually when I run it's on the weekends.  I try and play basketball every Wednesday night, and this is the best workout ever!  (just try and not get injured!)  You can lose a lot of calories playing basketball! (if you don't like basketball try racquetball)