Thursday, April 21, 2011

Back To School

I've been taking classes on and off for a number of years now, and about two years ago I finally settled on this program at UT Brownsville which is offered through McLennan Community College here in Waco:

Bachelor of Applied Technology (BAT) in Computer Information System Technology (CIST)
The University of Texas at Brownsville (UTB) Degree Plan in PDF
The BAT CIST track prepares individuals for various employments in industry, business, banking, and other services or fields where computer related knowledge, competencies and skills are essential. The student will complete the core curriculum plus up to an additional 35 credit hours in a related technical field at MCC. The UTB BAT CIST will then require an additional 36-37 upper-level credit hours from UTB, which are 100% online.
I started taking the basics on this track and only lack like two classes, then this year MCC added this program which honestly to me looks MUCH more appealing:
Bachelor of Business Administration in Computer Information Systems
Tarleton State University (TSU) Degree Plan in PDF
Tarleton is offering the Bachelor of Business Administration in Computer Information Systems. This 120-hour degree program emphasizes support courses by including a variety of business disciplines, including computer information systems, general business, finance, management, and marketing areas. Graduates of this degree program have been awarded jobs in many areas such as database administrators, network analysts, programmers, technology directors, and IT specialists. 
I haven't talked to a councilor with TSU yet but I will soon since I really hope to get back into school this Fall.  The basics are pretty much the same except that I'd need like two classes of Phys Ed (???) but I'm afraid the BBA degree won't take into account my work history like the BAT degree does which if that's the case this would mean an extra 30 hours for the BBA through TSU.  I'll find out whenever I speak with someone at TSU.

Tuesday, April 19, 2011

Woohoo -- Alexander Publishing is a Go!

Tonight I setup a Host Reseller account with Host Gator and started putting together our site on WordPress. Flip and I will spend some time going through themes and ideas on how to customize the site, plus I'm working on some plug-ins for WordPress since a few of the projects we're planning on tackling need functionality that I haven't been able to find available as a WordPress Plugin.


So check AlexanderPublishing.Net often!

New Web Publishing Venture

My wife and I have tossed around the idea of creating a side business creating websites, and we've finally decided to take the plunge.  We've had AlexanderPublishing.net for a number of years with that goal in mind, and given we've already created a site for our HOA and now are working on two projects for Flip's work I think we're off to a good start.

For now below is our short list of business things to get going for the new business:
  • Setup a business phone number through Skype
  • Get DBA, Tax ID, plus learn as much about the taxes on web services in Texas so we're as legit as possible
  • Get PO Box for Business (not sure if this is really needed but might keep it on the back burner)
  • Setup Bank Account for Business
 And here are the technical things we need to start looking at:
  • Setup Reseller Account with HostGator (I love those guys)
  • Start drafting our website and some sample sites
  • Get pricing scheme together
  • Get list of 'technologies' we can support, which will probably include custom sites from scratch or canned sites using WordPress and Joomla along with mobile apps given I can get some proof of concept apps going for iOS and Android
So lots of stuff, but it'll be fun and hopefully lucrative in the end.

Friday, April 15, 2011

Test from cell

This is a test with pic from my cell.

Reload Server -- Not sure which OS

My home server is using Ubuntu 8.04 Server which has been running great since I installed it in 2008, but I'm thinking of reinstalling the operating system to something alittle newer even though with LTS I have support for another I think 2 or 3 years.

Some operating systems I'm looking at are:
  • OpenBSD 4.8
  • FreeBSD 8.2
  • CentOS 5.6
  • Ubuntu Server 10.04 LTS or 11.04
 I know Linux better than any of them, but talking to the Devio.us folks for a few months now I'm seriously thinking of moving to OpenBSD given its security and stability.  I'll have to verify all my websites will port seamlessly to it if I go that route, but I don't think that'll be a problem.  I also like the idea of running FreeBSD, but likewise that'll take some testing before I'll run with that.

As for sticking with Linux, Ubuntu Server is definitely a tried and true operating system, but I'll need to see what the major differences are between 10.04 and 11.04 because I really like the idea of running a LTS version which I'm on now.

I'll post some updates as I run my testing.

Loading data from old website

Before Blogs were all the rave I had a website that I posted some thoughts to, and I'll probably start loading some of that data here soon.  These are posts going back to 2001, so it'll be neat having all this in one place.

I have copies of the website someplace, but what I'm posting is from Archive.org which is amazing it still has copies of my old site :)

As for posts after 2005, that's when my wife and I got together and setup a family website at http://www.samandflip.com and we blogged from there mostly so check there for the happenings in our lives after 2005.  In 2010 I found this blog on Blogger which I had actually forgotten about and started using it more for a personal Tech blog.

Also in 2002 I bought a 1955 Chevy 210 I hoped to fix-up, and I setup a blog for that project at http://sams55chevy.com.  I worked on it for about a year then it sat idle for another 3 or 4 and eventually got sold on EBay. You can view the Blog posts for it here on Archive.Org though I'm not sure I'll copy these into this Blog though who knows.

Wednesday, April 06, 2011

Setting-up Windows Development Environment virtually on Linux

My laptop runs Ubuntu Linux 10.04 Desktop, but given I hope to start tackling some C# projects at home on Microsoft Visual Studio 2010 I needed to setup an environment to code under. I'm a huge fan of virtualization and given I already run a few Operating Systems on my system via VirtualBox I decided to just install Windows, SQL Server, and VS 2010 that way.

Though I haven't taken classes in a year or so my account on Microsoft Dreamspark is still active so I downloaded Microsoft Windows Server 2008 R2 Standard, SQL Server 2008 R2 Developer, and Visual Studio 2010 Professional. After this I setup my Virtual environment in VirtualBox and got busy installing.

Windows Server only took about 15 minutes to install, but it took probably 2+ hours to install all the updates. Then after installing SQL Server then Visual Studio likewise the updates took forever. I also found this MSDN Blog posting showing how to use Windows Server as a 'Super Desktop' so I went through some of these tips to setup Windows Server 2008 R2 more like a Windows Desktop so I wasn't bothered by all the security crap.

After all this plus installing a slightly older version of Microsoft Office (I think 2005) I was ready to go! I grabbed the ASP.Net AJAX Toolkit which added some NICE tools to VS plus I'm reviewing two different sites to find some open source C# tools:

I need to find some open source tools for reporting and also for saving content to PDF.

So all and all my environment is now setup and ready to go, so now I just need to find time to actually start coding :)

Tuesday, April 05, 2011

Excel Macros -- Oy Vey!

I'm working on a project right now where I'm creating a VERY lengthy Excel Macro in VBA to recreate a spreadsheet in a specific format. It's definitely a learning experience since I've never messed with Excel Macros, but quite frustrating none the less. I'm now almost a month working on the project, and I can honestly say I wish I knew 4 weeks ago what I know now since I've had to recreate the same logic a few times as I'm learning more efficient ways to do it.

The biggest catcher now is getting IRR and XIRR to work in VBA.

Friday, April 01, 2011

Pivoting a large table, like Cash Flows, in TSQL

I often have to pivot large amounts of data, but the Pivot option in TSQL can be VERY limited especially when there is a large amount of data. The TSQL query below will create a sample Cash Flow table then pivot it on Date, but this can be modified to pivot the data in any number of ways.



The output will look similar to this:

AccountID [2010-1] [2010-2] [2010-3] [2010-4] [2010-5] [2010-6]
123 117.89 515.86 205.81 516.29 387.64 30.84
390 363.94 992.20 197.64 516.29 248.20 172.05
687 129.86 562.17 839.67 790.28 790.28 898.51

I've used a query similar to this for pivoting LARGE cash flow tables for reporting, and given you have no objections to using Dynamic SQL this is a great way to pivot large amounts of data.

Have fun and please post comments and suggestions.

Wednesday, December 29, 2010

Been months since my last post --- lots of changes

It's been about 5 months since my last post, and there've been lots of changes on the home front since then.  The biggest being our son was born in September, and being 3 months old now he's an amazing little guy.



Some drama though is the week we brought him home we found our new house to be overrun by Fire Ants!  Our bug guy has been awesome, but given they're coming in through the foundation where the pipes enter the house inside the wall voids it's hard to really stomp them.  So 3 months later and they're still around, but thus far they're isolated to the master bath.  I'm hoping we'll find some combination of something that works since their presence is driving me nuts.

Also our washing machine sprung a leak in October which flooded a small portion of the house.  Though financially we took at hit we decided to just upgrade all the floors in the house to something nicer than what we had plus we tiled the kitchen and entry hallway which is SUPER nice.

But all and all the new house is working out great and granted we can get the ant problem resolved I can't wait for 2011!

Tuesday, July 06, 2010

New Dad in a couple of months ... amazing!

Flip and I toured the hospital labor and delivery department today, and it really made it feel concrete that in just about 8 to 10 weeks we'll have another little person under our roof.  I can't wait to meet him, and it's very surreal.

We're getting things ready, working on a birth plan, we're working with a Doula, and things thus far are going as well as can be expected.  But it's hard to see these quiet late nights coming to an end since we'll probably get zero sleep for those first few months.  But ya know what?  It'll be worth every minute...  We had our late nights and early morning with Willow, and looking at her now, a little ball of inquisitive energy, I wouldn't change a thing.

Moved to 64-bit Ubuntu 10.04, and loving it!

About a year ago I retired my aging G4 iBook and moved to a System76 Pangolin Performance laptop. Though I've been using Linux since the mid-90's, I veered more towards Mac OSX around 2005 and mainly used Linux Server with OSX on my desktop and laptop. Last year I went back to Linux, and honest I haven't looked back. The laptop ran 64-bit Ubuntu 9.04, which ran great, but last week I ordered a 1TB USB drive to backup my laptop then ran a clean install of 64-bit Ubuntu 10.04.

My first impression was WOW! Most people said the boot times were impressive, but where 9.04 booted in about 45 seconds, 10.04 boots in under 20 seconds. Also shutdown, suspend, and hibernation work MUCH better under 10.04, which is good to see since early adapters of 10.04 had complaints about this.

As for the interface, I wasn't a huge fan of the stock theme, but after some customization plus using Screenlets I was able to get the desktop looking great, or looks good to me anyway. Here's a screenshot to the left using one of the stock wallpaper images.

I've used Thunderbird with Calendar plugins, but this go around I decided to try Evolution, which I haven't used since since Ximian was bought by Novell. I like it, but I've had to go back to Pan for NNTP since Evolution doesn't appear to support NNTP, or at least not that I've seen anyway. But all and all Evolution syncs rather well to my Google Mail, Calendar, and Contacts.

Though I don't generally post much to Facebook, Twitter, etc, I've setup all these accounts on Gwibber. It's nice, and I may start posting some quick updates in the future using it. I've also setup Skype, Gimp (doesn't come preloaded with 10.04 anymore), plus Flash (blah, have to use Ndiswrapper) and the Restrictive plugins to get support for DVD, MP3, QuickTime, RA, etc.

All and all it's amazing, and well worth upgrading. I read lots of hiccups with Ubuntu 9.10 when it was released, but I think they got lots of problems ironed out with 10.04.

Thursday, June 24, 2010

Test from cell.

Wow! 6 years later!

While working with GoogleCL I saw it supported posting to a Blog, so I figured I'd create one to see how it worked. Putting in my username samalex I saw one already existed, and low and behold it was a blog I setup in 2004!

Google gave me the option to reclaim it, which was nice of them, so I now have it back... and this is Post 2 almost six years later.

Looking at the "ventures I'm working on" the biggest one that did come to fruition is "getting a life" which I feel like I've found thanks to my wonderful family. Back then in 2004 I was a lonely sole, but now I feel like I'm living a dream every day.

As for the other things, after the '55 Chevy sat in the garage for 3 years untouched I sold it on EBay. Also we did end up remodeling the house but sold it about 5 months ago, and we've since built a new house which is MUCH nicer. And the Colo for web hosting is still something I'd like to do, but chances are I'll go with a VPS if I go that route since it's cheaper.

So things are going great. I'm not sure if I'll keep this Blog going, but I'll play with it using GoogleCL for a while and see where it goes.

Sam

Thursday, August 12, 2004

Hi Everyone!

Welcome to my first Blog posting. WOOHOO! I had one of these running on my personal website -- www.totallynerd.com -- but I'm working on a total rewrite of that website so it's offline.

Let's see, some stuff about myself. I'm a nerd at heart, but now that I'm getting older (28) I'm trying to get away from the nerd personna. I created Totallynerd some 4 or more years ago, but I'm concidering a change. Idea???

Other ventures I'm working on --
- Setting up a colocated server to do web hosting (getting hardware costs now)
- Restore '55 Chevy 210 to a somewhat driveable state
- Fix-up house (been in it 18 months and haven't done crap beside replace a toilet)
- Get a life...

Well that's it for my first blog. Take care... Sam

Saturday, June 05, 2004

Hi..

Hi.. Yup, if you are one of the few people that actually monitors my site, you've probably noticed I don't update my blog very often. The past post was almost 10 months ago, but I'll try to do better :) Not too much has changed over the last year, but I have added some new toys. For one, I bought a 1955 Chevy 210, and yes, it has it's own website -- http://www.sams55chevy.com. Other then that, still in my house and loving it... still single (but looking), and still working with and loving Linux.

Speaking of Linux some things have changed in that area. Last year Red Hat, who I've used for years, moved to a total Enterprise platform and dropped their freely available version. There's still a community project called Fedora Linux that has taken over the project, but I don't care much for it. I moved to Slackware shortly after and used it until about 3 weeks ago when I bought SuSE 9.1 Pro, which is now on my laptop and desktop computer. I love what SuSE offers, and I've found some great folks in irc.freenode.net/#suse.

Outside of the new OS, I've started playing with Qt3 and C++ to develop GUI apps for Linux. I figure I use Open Source Software so much, why not contribute. My first programs to write -- a bowling league score tracker and video/music catalog program. It'll be a while before learning enough of Qt and remembering my C++ to have anything productive... but I'm looking forward to the challenge.

Another non-computer related hobby I'm starting to get into are ham radios. One of my most awesome friends Chris Erlanson has been in Ham radios for years, and I'm finally taking his advice and working toward my technician-class license. It'll take a few weeks to read through and memorize the questions, but maybe.. just maybe I'll have the license before summer's end.

Well that's it... in a nutshell that's my life over the last months. Oh, I've also gotten a webcam set back up, and yes, it runs PERFECTLY on Linux :) Click Webcam on the menu above.

Take care...

Saturday, August 30, 2003

New House

Nothing new... I'm still trying to get stuff situated into the new house. It's been almost 7 months since moving in, and I still have my spare bedroom full of boxes of crap. Yes... Crap! But luckily I have plenty of closet space to get rid of it all in. I am looking forward to going though the old boxes from my parent's house. Finding things like my old cub scout hat and belt, old school work, computer magazines advertising New 486 systems for only $999. :) Funny stuff.

Future plans for the house... fix mailbox (my first attempt at replacing the damn thing is about to fall over), get everything put-up, expand patio and cover, then build a garage. After that, I'll be ready to remodel what I want in the house. Two garage plans I'm looking at - Garage 1 and Garage 2. With some help from family and friends, this shouldn't take long to put-up. Once this is all done, which I hope will be within a year or so... I'll be ready to remodel. WOOHOO!!

Hmmm, what else. Dang I have a boring life. LINUX AND DALLAS STARS RULE!!!

Saturday, August 09, 2003

WOOHOO!! I've finally gotten Google Search added to my personal site.

WOOHOO!! I've finally gotten Google Search added to my personal site. I started searching for a way to do this earlier (while watching Star Trek VI), and I found some awesome resources on how to integrate the search via Google API, PHP, and Soap. Here's the link I used for the API's: http://phpclasses.promoxy.com/browse.html/package/920.html. The example3.php was the ticket, and all I had to do was integrate it into my web theme. About 30 minutes of learning the script and 30 minutes of PHP coding... and it's done. I have the Next 10 and Previous 10 setup, but I'd like to add 1.2.3.4.5... in between. One bummer is Google limits the total search to 10 entries per search. I generally pull 100 at a time. Oh well.

Other then that, not much else going. Oh, I did add a script to capture webcam shots every hour. Check out the webcam page and choose Archived Pics. I'm using WebCam32, and for some reason it has issues FTPing every 10 minutes or so... so some pics don't update properly. But this is cool when it works.

Whelp, time to clean a bit. My sister and family, Blak and family, and other friends are coming over tonight. Later.

Tuesday, August 05, 2003

I haven't updated my site in almost 10 months

I haven't updated my site in almost 10 months, so there's a lot to add. The most recent change was buying a new house with a pool. It's not a huge pool, but big enough for me and friends to hang-out in. Plus with 1.2 acres of land, mowing is a pain.. but it's mine. No Landlord, which is great.

The webpage is being updated slowely but surely. I finally have my webcam backup, but I need to do some more tweaking to make the overlayed text easier to read. Also, the new host has a problem reading my PHP includes, so I need to change my code to fix the bugs. If you get a 'Stream does not support....' error, ignore it. I'm working on getting these resolve. Oh, and I've added a newer message board. Check it out and post some messages while you're here.

As for computers, I've finally set-up a reseller's account at www.page-zone.com and I'm hoping to start doing web programming for folks. I'm working on getting the business in order and writing some canned code to create dynamic content for folks. M$project is to rewrite my work webpage - www.hillcrest.net - in PHP and MySQL. It's currently Cold Fusion and MS SQL on Windows... but shouldn't be too hard to rewrite it for Linux.

As for me personally, nothing has changed. I dated one girl earlier this year, but it was a long distance relationship that didn't work out. Oh well.

Well, that's it for now. I know my small life is probably not worthy of a webpage, but hopefully someone will find something here to keep them occupied for a few minutes. Take care. -- Sam

Sunday, October 20, 2002

This is my first update to my website in almost 7 months

This is my first update to my website in almost 7 months, and many things have changed. The last post was when my grandfather died earlier this year, and that event has changed many aspects of life for the family. But all and all, things have finally started to get back to norm.

Outside of the family, I've started pursuing Linux more then ever before. I've been using Linux at home off and on for many years and switched exclusively to Linux several months ago without looking back. Other then some games I liked to play under Windows, Linux does everything I need and more. Some say Linux won't support their hardware, but if anything, it's easier to get hardware working under Linux. My digital camera, webcam, dual head video card, network card, video capture card, and flatbed scanner all work without needing downloaded drivers or applications. Also, Linux gives a much fuller Internet experience with a great interface. I couldn't ask for a better OS to use. Also, the Linux User Group has started taking off, which is great. We're finally getting a Linux presence in Waco. Check out our website - http://www.hotlug.com - which is hosted on a Linux box we installed at a LUG meeting.

Well, that's it for now. I know no one reads this site, but for those that accidently run across it, I'll try to keep things updated more. Later.