Ron Sparks Author, Poet


Password Validation Class Using RegEx in C-Sharp


I have a client that recently asked me to add password validation on a web application.  Their existing application had no password validation and users could enter any password into the system with no regards to how secure it was.  I was asked to implement the following password constraints: Passwords must be at least 8 characters in length Passwords must not have the login username in the...

Windows 7 “Command Prompt Here”


Before Windows 7, I had to muck with the registry to get right-click context in Windows Explorer to open a DOS prompt in the folder I was viewing.  Windows 7 does it for free.
Simple hold SHIFT and RIGHT CLICK within Windows Explorer to view the option to open a command prompt in that folder.

Running SQL Server Management Studio Aliased as a Different User


I connect to a client VPN often to work on their servers, their code, and their databases. My development machine is not a part of their domain, although I do have a domain account on their VPN. My problem; when I connect SQL Server Management Studio to a client database on their domain I cannot get in. They do not have SQL Authentication (which is a good thing) and rely on Windows auth. My...

A View of Anonymous and #OpOrlando


(Quite a few of you have come to me for explanation of Anonymous and OpOrlando, so this is for you.) If you’re unaware, Orlando is currently under cyber-attack by the digital group known as Anonymous.  The reason they are attacking Orlando is in protest of the recent arrests of members of a group called Food Not Bombs that feeds Orlando homeless people in downtown Orlando in violation of a...

Searching Contents of Files Via MS-DOS


I log into a lot of client production servers and do not have the luxury of installing my favorite GUI tools, such as UltraEdit, which (among other things) easily allows me to search within files.  On these servers I am limited to what is already installed.  Just today I was forced to search an entire website on a client server for a file that that might contain the string “bill”. So...

Removing all .svn folders from a folder via Windows batch


I needed to delete all .svn subversion folders and the files within them and did not want to take the time to do it manually. This little command prompt script will recurse a folder and delete all folders names “.svn” and all the files within.
for /d /r . %d in (.svn) do @if exist "%d" rd /s/q "%d"

Executing multiple SQL scripts against a MySQL database from a DOS batch file


[updated 2011-06-10 because a friend  pointed out a flaw in my assumption that I needed to enter the password every time – see bottom for updates] I am architecting a project that is a C# front end, hitting SOAP web services, that communicate with a C# core, and has a MySQL database backend (accessed using a buddy’s custom ORM solution).  I use MySQL Workbench to manage the schema and...

Ron Sparks Author, Poet

Select a Category to Browse

Ron Sparks

Ron Sparks is a technology professional, science fiction and fantasy author and poet living in Zurich, Switzerland. His latest book "ONI: Satellite Earth Series Book 1" is available on


A man of many passions, I lay claim to a myriad of interests and hobbies. Among them, I am an amateur astronomer, an avid motorcycle rider, a whiskey aficionado, a (poor) surfer, a scuba diver, a martial artist, a student of philosophy, a proponent of critical thinking, a technologist, an entrepreneur, a cancer survivor, and I harbor a lifelong love of science fiction and fantasy. Feel free to strike up a conversation on the social networks below.

Site Pages