If you’re into blogging and host your own blog, you are aware of the need for MySQL databases when you install most blogging platforms, and this is because most blogging programs, and indeed most content management systems store their data in a database. This is generally not a problem because most web hosts offer […]

read more from " Flat File Blogging with FlatPress "

I just read this from the BBC News website:
Microsoft has announced that it will open up the technology of some of its leading software to make it easier to operate with rivals’ products.
The technology giant is to publish key software blueprints on its website.
It also promised not to sue open source developers for making that […]

read more from " Microsoft going Open Source? "

Microsoft is offering free developer and design software for students all around the world. Students can download professional-level Microsoft developer and design tools.
The downloads currently (as of this posting) listed are:

Microsoft Visual Studio 2008 Professional Edition
Microsoft Windows Server 2003 Standard Edition
Microsoft SQL Server 2005 Developer Edition
Microsoft Expression Studio
xna Game Studio 2.0
xna Creators Club Online
Microsoft […]

read more from " Free Microsoft Developer Software and Tools for Students - Full and Professional Editions "

I ran into an interesting situation the other day when trying to import some data into Excel. I had a text file with words and definitions that I needed to have in two columns in Excel, one for the word and one for the definition.
The words and their definitions were separated by a hyphen […]

read more from " A delimiter with non-delimiter uses during data import in Excel "

I am pleased to announce that I will be starting a guest post series. I am inviting programmers and coders from all languages and platforms to share their coding tips and tricks, snippets, and stories. It doesn’t matter what your level of experience is, anything you have to share is a welcome addition, […]

read more from " Share your Programming/Coding Tips and Tricks "

In response to my post on importing large files into Excel by first splitting them, one of my readers, JP pointed out to me that you can bypass the splitting step by using a VBA macro to do the import.
As you may know, Excel has a cut off of 65,536 rows, and so if you […]

read more from " Importing large CSV files into Excel Using a Macro "