#SQL
Latest Posts
First Impressions of Microsoft SQL Operations Studio
1
First Impressions of Microsoft SQL Operations Studio

Microsoft recently unveiled their new Microsoft SQL Operations Studio (in preview) application for Windows, Linux, and Mac. SQL Operations Studio is a lightweight and free management software for SQL Server much like SQL Server Management Studio. Nowadays, any full-stack developer will spend about half of their dev time in the database. Whether it be updating sprocs or generating reports or removing unused data, a solid database management system is key to perform well and to not waste too much time.

Continue reading
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
Preventing SQL Injections With Parameterized Queries
Preventing SQL Injections With Parameterized Queries

In my previous post I wrote about a few steps that you can take to better secure your website. One of those steps, probably the most important on that list, was to use Parameterized Queries whenever you're mixing SQL and user input in order to avoid SQL injections. We all want to trust our websites visitors and in a perfect world we could save precious time by not worrying about such silly things. However, in our current world we have to spend this extra time. If there is a flaw somewhere, someone will eventually try to expose it and some may even attempt to abuse it.

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