Dealing with databases and SQL I run across a lot of lists that are usually broken by either excel or line breaks. Well when you need a quick way to convert that to a single line comma separated list the fastest way to do it is a find and replace on regular expressions. This can be easily done with Notepad++ or just about any text editor
For example if you had a list like:
1
2
3
4
A find of \r\n and replace with , will give you the output of
1,2,3,4
This can save a whole bunch of time!
So I have been using Gimp for a while and wasn’t really happy with it and found it very cumbersome to use especially when I am trying to some very generic photo editing or resizing or whatnot. Well using my LiberKey on my USB drive has pointed me towards using Paint.Net instead. I love it, makes editing super fast and easy and the interface is very easy to use. I would highly suggest using this software it just requires .Net Framework to be installed which isn’t a big deal. I would highly suggest this software for basic image manipulation.
website: GetPaint.net
The other day I had to move a blog from one server to another and found out that WordPress sometimes likes to hard code the server address into things like links and images. I found this handy little SQL statement you can run to find and replace anything that you need changed:
update [Table] set [Column] = replace([column],’[old text]‘,’new text’);
This can save you a lot of heart ache dealing with moving servers and find out that you have a lot of broken images left after migration.
So this weekend we decided to plant some new bushes and flowers and trees in our newly landscaped areas in the backyard. 23 in all and lots of holes to dig and lots of dirt to move it was pretty crazy. Showed up at the plant place with pictures of what we had to work with and then talked with a plant designer for about an hour figuring out what to put where and what would work good with the exposure it receives and worrying about things like acidity levels under the trees and what would grow. She was amazing helpful as we are sort of plant retarded! Also we put in a soak line in the front so you just turn that on to water all the flowers.
Everything is in place as you can see below. If you click on the images, on the bottom it will tell you the name of the plant. Figured this was the easiest way to remember what we planted since I never remember that stuff. Chances are we will fill in some gaps with other flowers and whatnot but this was a good start.
Front Yard:
Back Yard:
Well since I am a little partial to using Notepad++ for just about everything these days looks like with a few easy steps you can change the default source editor in Firefox to use Notepad++ It is very simple:
Go to about:config
Search for “view_source.editor.external”
Change this value to “true”
Search for “view_source.editor.path”
Change this to the path of your editor “C:\Program Files\Notepad++\notepad++.exe”
Well it seems that I have had a hell of a time cleaning up my website from its recent hack. Gotta love it when the first time you find out about your site being compromised is via google.
So what happened to me is someone uploaded a whole bunch of files to my WordPress directory with links to god knows what content. So after going through those directories (numerous times!) and cleaning them up and deleting outdated random files I think it is finally clean.
I was looking for something to monitor my website directories for any file changes or any random uploads that I didn’t authorize. I came across this PHP script that you can put in your root directory and then you set a cron job to run the script every so many hours.
The script emails a specified email address and lets you know of any changes since the last run.
Download Monitor Hacked Files
Well if you have ever wanted portable apps on crack this might just be the application for you. With USB keys getting up to 128GB these days trying to find stuff to fill it is about half the fun! Well just ran across this application the other day, it puts Portable Apps to shame and has over 200+ applications that are easily updateable and easy to download new ones. It also allows you to easily add applications that are not part of the general install package.
The ultimate package comes with over 200+ applications and download at about 200MB and unzips to about 600MB. I finally have everything I could ever want on my work laptop without having to worry about actually installing software on it!
I thought that I wrote about this a while ago…but I guess not. Sometimes between working from home and working at the office sometimes I am missing my network mappings to get to the shared folders that I need. Well with the easy command of:
Net use DRIVE: \\SERVERLOCATION
You can map your network drives via a batch script. Also if you are at your office you can just run ‘Net Use’ and see all the drives you are mapped to and their locations. This can make creating your batch script much easier. All about the efficiency!
Well I ran across a reason to look for this the other day. I was downloading some stuff and ended up downloading an ISO, because I didn’t really want to go upstairs and get a CD and deal with burning one I figured I would try to virtually mount the ISO to a drive. After about 3 software attempts I found that this was the best solution.
MagicDisk allows you to mount up to 4 virtual CD drives and then you can mount the ISO to the drive letter. Very handy and super easy to use.
So Laura and I decided to go on a little hike this past weekend. The weather was great and it was a really nice temperature out. The hike was about 6.5 miles round trip the turn around point is where they were going to build the Summer White House in 1911 but never decided to
