Mike Rodey is a technical consultant in the Milwaukee, Wisconsin area
I provide programming and computer services to businesses and individuals in-person in the Milwaukee area and remotely throughout the world. My goal is to exceed expectations while providing excellent customer service. Read about services offered.
Submitted by Mike Rodey on September 19, 2012 - 7:17pm
The Capital Master Android app is now available from Google Play. Capital Master is also available as a Chrome app in the Chrome Web Store or directly through your web browser as a HTML5 app. Use the links below to get Capital Master now!
I have released a new project called Capital Master to the public. The title is self-explanatory, it is a game/learning tool that quizzes the user on their capital city knowledge. I plan on maintaining it so please feel free to provide feedback.
Drupal can be heavily customized, but developers should not modify any of Drupal's core code. A common phase within the Drupal community is Do not hack core. Drupal uses a modular architecture and allows customizations to be isolated and deployed within individual modules. In the Services section of this website I wanted to provide a list of my programming skills so that customers would know which technologies I can work with.
Submitted by Mike Rodey on March 28, 2012 - 10:27pm
The SQL Server Agent and database maintenance plan wizards are unavailable in SQL Server Express, so a quick and easy way to backup all databases on a schedule is to call a T-SQL script using Windows Task Scheduler. The sqlcmd program can be called from a task to execute the script on SQL Server 2005 or greater and osql can be called on SQL Server 2000. To get to Windows Task Scheduler open the Run dialog box in Windows and enter "control schedtasks".
Submitted by Mike Rodey on March 25, 2012 - 9:27am
In the article Oracle PL/SQL - Search for String in All Tables of Schema I promised to show how to search for a string in all tables of a SQL Server database using T-SQL. Replacing the @SearchStr variable in the script below will perform a case-insensitive search for the string in all tables not shipped with SQL Server in the current database. The script searches every column and will report the exact column where a match is found, but this could run quite slowly if you have many large tables.
Submitted by Mike Rodey on March 10, 2012 - 10:14am
By default the Windows command line does not support a UNC (Universal Naming Convention) path, or network path, as the current directory. Sometimes you may want to quickly make a UNC path such as \\ComputerName\SharedFolder the current directory from the command line so you can easily run commands or just explore the file structure with dir and cd commands.
Submitted by Mike Rodey on March 7, 2012 - 11:48pm
When doing database work I may have a string that I want to search through all tables for, especially if I am unfamiliar with the logical schema I am working with and I only have a string to help lead me to the proper table(s).
The following Oracle PL/SQL script can perform a case-insensitive search for a specified string in all tables under a specified schema owner on Oracle Database 11g or greater.
Submitted by Mike Rodey on February 26, 2012 - 10:28pm
The collaborative nature of Wikipedia has always been a controversial component of its character. Critics question the ability for a resource that can be edited by anyone to be taken seriously, warning that truth by consensus makes it too easy for misinformation to spread.
Submitted by Mike Rodey on February 1, 2012 - 12:29am
I just moved this site to a new hosting provider and I am pleased with the switch so far; the site is loading much quicker. The main reason I switched was because I was unhappy with the performance of the site with my old host. I am using more expensive business class shared hosting, but I am willing to pay more for the better service. I will continue to monitor the site and if I continue to be pleased with the results, I will publicly recommend the web hosting provider.