#Database
Latest Posts
When To Use Code Vs When To Use SQL
When To Use Code Vs When To Use SQL

Just recently I spent a few hours attempting to make an overly complex SQL query into a reality. From the beginning, it didn't really feel right. The data was slightly off, and there was this nagging feeling hovering that it wasn't going to end well. It wasn't that the query itself was complex. But more that the data wasn't very well stored, formatted and queryable. But nonetheless, because I began to solve it with a data-based mentality and because I had dedicated so much time on a query that would take years to describe I decided to continue the relentless battle. At the end, I ended up with a query that would be forgotten within a 15 minute timespan and with a dataset that might or might not be correct. There was very little I could do to verify whether a 2 paragraph query was valid or not.

Continue reading
Database Normalization Is Good And Bad
4
Database Normalization Is Good And Bad

Every developer does it subconsciously nowadays. We create a database schema and we normalize it without thinking about it. At least I hope we do. We let the data speak for itself. Sometimes that doesn't turn out so well, and sometimes it isn't terrible. There are several goals when designing a database that I try to keep in mind. A few include reducing the amount of duplicate data, making the data clear and readable and reducing the number of changes needed to the code whenever new data sets are introduced. It's always nice coming back to an old project and having it make sense without having to relearn how it works.

Database Normalization is

Continue reading
Guest Posts
creating your own it crowd
creating your own it crowd

“Have you tried turning it off and on again?” Thus goes the punchline of one of Britain’s most entertaining and often surreal sitcoms of the 21st century, The IT Crowd. But while the zany antics of Moss, Roy and Jen may belong squarely in the realm of fiction (and rarely have much, if anything at all to do with IT) they do capture what it’s like to work in IT support in broad terms every now and then. There’s a whole lot more to IT support than asking people if they’ve tried rebooting their thin client (although you will likely do it at least once). If you have entrepreneurial ambitions you may come straight out the gate wanting to start your own IT crowd, delivering bespoke IT and communications systems to small businesses and making the world a better place one query at a time.

Read more
3 ways to start a freelance career with programming
3 ways to start a freelance career with programming
3 Ways To Start A Freelance Career With Programming

Want to make money with your programming skills but don’t want to work for someone else? There are many ways in which you can go freelance as a programmer and be your own boss. Here are just three options to consider.

Read more
minigame: adding interactivity to a new website
minigame: adding interactivity to a new website
Minigame: Adding Interactivity To A New Website

Being able to keep your users hooked on your site for as long as possible is very important in modern business. The more they shop around your website, the more likely they will be to spend money, but achieve this goal can feel impossible. One of the best ways to do it is through interactivity. By providing a user with a game to play on your website, you will keep their attention for a long time. To help you out with this, this post will be exploring the process of building your own web-based game.

Read more
tips on making your work set-up more ergonomic
tips on making your work set-up more ergonomic
Tips On Making Your Work Set-Up More Ergonomic

Unless you have been living under a rock for the past few years, you will have heard about the term ‘ergonomics’ in regards to our work and office set-ups. This is all about designing a workspace so that it suits you and the tasks you are carrying out, benefiting your health in the process. With that being said, read on to discover some useful tips on making your work set-up more ergonomic.

Read more
the art of becoming a self-taught financial guru
the art of becoming a self-taught financial guru

If there is one thing that is worth understanding in more detail which is going to help you out in a big way in the future, it is finances. Unfortunately, many people simply don’t put in the required amount of effort to understand issues like investing, debt, savings etc.

Read more
break a leg: how to get started in the healthcare sector
break a leg: how to get started in the healthcare sector
Break A Leg: How To Get Started In The Healthcare Sector

Year after year, thousands of students graduate medical school one goal: become a doctor. Grad school is one element of the role, and the rest is yet to come. Are you ready for blood, guts and tears? You better be or else your career is going to circle the drain quite quickly.

Read more

About Me

Walter Guevara
Walter G.
Walter G. is a software engineer with over 10 years of professional experience. When he isn't blogging or being a CTO he enjoys coding randomly complex things that he hopes many people will get a chance to use one day.
Podcast

Snake High Scores

"sometimes you have to delete, to find your answer"
Copyright © 2018 thatsoftwaredude.com
humans.txt
Start
Score: 0
snake left
snake up
snake down
snake right