Category Archives: Today I Learned

Today I Learned about Gobuster

I’ve made it a goal for 2023 to increase my security knowledge. This was based on increase in security related questions from clients. Specifically related to website security as most of my current work is maintaining websites for clients. One … Continue reading

Posted in Security, Today I Learned | Tagged , , , , | Comments Off on Today I Learned about Gobuster

Today I Learned how to Secure the Delayed Job Page with Spree Users

A client has an online store that is powered by an older version of Spree. I’m in the process of upgrading it and adding features to it at the same time. It’s a slow process as upgrading to newer versions … Continue reading

Posted in Today I Learned | Tagged , , , , , | Comments Off on Today I Learned how to Secure the Delayed Job Page with Spree Users

Today I Learned Altering a SQL Column Removes it’s Default Value

This one I actually already knew but temporarily forgot about it so got to relearn it. In MySQL, and many other databases, updating the column with an ALTER statement will remove any properties not explicitly listed. For example, say you … Continue reading

Posted in Today I Learned | Tagged , , | Comments Off on Today I Learned Altering a SQL Column Removes it’s Default Value

Today I Learned About GitHub’s Dependabot

Recently I created a CI build for the Introduction to ORM for DBAs presentation example code. One of the reasons I picked this code base was so I could try out Dependabot for the security alerts I’m getting. The security … Continue reading

Posted in Today I Learned | Tagged , , , | Comments Off on Today I Learned About GitHub’s Dependabot

Today I Learned How to Setup Azure Pipelines CI

Our last EDMUG meetup was an excellent presentation about Azure DevOps. Azure DevOps reminds me of GitLab where it is more then just continuous integration (CI). It includes issues tracking, repositories, and continuous delivery. All pretty standard stuff. However, one … Continue reading

Posted in Today I Learned | Tagged , | Comments Off on Today I Learned How to Setup Azure Pipelines CI

Today I Learned How to Create a React-Rails App

A working example can be found here in the Saturday MP Examples GitHub. First thing you need to do is create a basic Rails app as outlined in my previous post.  My setup is the same as creating Rails app: Ubuntu 18.04 LTS host … Continue reading

Posted in Code Examples, Software Development, Today I Learned | Tagged , | Comments Off on Today I Learned How to Create a React-Rails App

Today I Learned how to Generate a ERD for Rails Application

Back in the day Rails apps didn’t add foreign keys to database tables.  Believe it or not this was a feature not a bug.  The idea was that you shouldn’t “repeat” the relationship between you models in the code and … Continue reading

Posted in Code Examples, Software Development, Today I Learned | Tagged , , , | Comments Off on Today I Learned how to Generate a ERD for Rails Application

Today I Learned how to Create Rails Docker Container Without Ruby Installed

I was curious to see if I could create a Docker container for a new Rails project without having Ruby or Rails installed on the host machine.  To do this I created a new Ubuntu 18 virtual machine with the … Continue reading

Posted in Code Examples, Software Development, Today I Learned | Tagged , , , , | Comments Off on Today I Learned how to Create Rails Docker Container Without Ruby Installed

Today I Learned how to Run SQL Server on a Mac using Docker

Working on my code example for my upcoming SQL Saturday 710 talk I ran into a performance issue.  My laptop is an older MacBook Pro and I was trying to run my example on a Windows virtual machine… What is … Continue reading

Posted in Software Development, Today I Learned | Tagged , , , | Comments Off on Today I Learned how to Run SQL Server on a Mac using Docker

Today I Learned how to Run SpinRite on a UEIF Motherboard

I have a Synology NAS that has starting acting up.  By acting up I mean I can’t connect to it and it requires a unplugged reboot to fix it.  Power button no work.  After doing some detective work I’m not sure … Continue reading

Posted in Hardware, Software Development, Today I Learned | Tagged , , | Comments Off on Today I Learned how to Run SpinRite on a UEIF Motherboard