{business intelligently}

Blogs

Mac: It's Just A Computer

I've made it clear that I've decided that my next laptop purchase will be a Mac. This does NOT mean I'm "switching." Far from it. My development "core" will remain Wintel as that's where I have placed the most significant portion of my hardware expenditures. Our dedicated servers are Windows 2K3/8. I use Visual SVN, VS.PHP, and Visual Studio 2005/8, all of which integrate together in a smooth and seamless harmony, getting out of my way so that I can get things done.

MySQL Search and Replace Stored Procedure

I frequently need to do global search and replaces across a single database, so I wrote a stored procedure to do this for me:

####
# CALL THIS SP USING THE FOLLOWING SYNTAX
# sp_DbSearchReplace('oldText','NewText');
####

DELIMITER $$

DROP PROCEDURE IF EXISTS `YOUR_DB_NAME_HERE`.`sp_DbSearchReplace` $$
CREATE PROCEDURE `YOUR_DB_NAME_HERE`.`sp_DbSearchReplace` (IN oldString VARCHAR(255), IN newString VARCHAR(255))
BEGIN

# regular vars
DECLARE nDone INT;
DECLARE sTable VARCHAR(64);
DECLARE sColumn VARCHAR(64);

#cursors
DECLARE cTables CURSOR FOR

Mac: I'm Going To The Dark Side

I've decided that my next laptop is going to be a MacBook Pro. Now, if you'd told me 10 years ago that I'd be making this move AND be excited about it, I'd have laughed at you.

But lots has changed in a decade. Mac moved to Intel processors and released what everyone else says is an amazing OS in Leopard. And well, they just look REALLY cool. Also, Windows has started to really suck. I've got to repave my laptop. Again. It takes a million years to boot. It takes even longer to shut down. Applications take forever to load.

Syndicate content