I found this amusing, it is long. It is like watching Southpark except it is the cast of Mortal Kombat as kids at school.

Read More

This past weeks adventure has been working with Python to import an Excel CSV file. I like a recipe format when I am looking for how to do things and I was not able to find a lot of “recipes” for importing Excel CSV files into MySQL. After working through the issues, I decided this would be a fine blog post. So here you go.

Read More

As a “high level DBA type”, I do get to see strange things occasionally. On a previous occasion it was the duplication of records in a database. Let’s talk about how to get rid of those records.

Read More

The last part of this series on working with strings in SQLServer will focus on operators that you can use. As a developer working in SQLServer, we understand that we do not have access to powerful regex methods. We instead get access to a few string operators.

Read More