Because ASUS Eee PC S101 is coming out next week! I’ve held MacBook Air and it’s as heavy as my EeeBox. My 701 with cover on is still lighter than MacBook Air. In UMPC standards, that’s like a desktop heavy. For $1000 less, I would go with a thinner and lighter S101. Though it comes with Microsoft’s Windows XP Home, I can always install another OS that I favor. What I love with the Eee series is boot time. Not much of a wait time when booting (on/off).
I can buy 3 S101s with one MacBook Air.
I will not be preaching or discussing the current state of world economy. It’s still happening and I’m not an expert in it. The point I will be relaying in today’s entry is the sense of being economical in projects.
I am currently developing an application in a few spared hours of my dull life. I’m a few months delayed because of improper planning. The application I am developing requires massive information storage. Information that is improperly organized is simply garbage in a storage bin. Therefore, I will be using a database to organize the information. According to my projection, I can’t afford to use flatfile or filebased database system. I need an engine to run and manage the database system. There only a few RDBMS out there that’re stable enough to handle megabytes of information daily.
If you are talking about software, which company would first pop-up in your head? Microsoft. Since we are all used to Microsoft’s softwares, a programmer would easily decide to use MSSQL Server. In my case, I’m very picky when it comes to database management. I am not loyal to anyone because I choose according to my needs. However, I would avoid MSSQL.
The few reasons I have for ignoring MSSQL Server are (1) there’s a cheaper solution that can offer the same or superior quality, (2) difficult to use [not intuitive]. I can’t say never, but I don’t overestimate my needs because they cost a lot. I’m a Filipino and Filipinos always (not often) believe that the more expensive the product, the more superior it is. I don’t value something because it costs a lot. In database management system industry, it surely is not true. I always use MySQL for my large scale database needs. It’s free, easy to use, portable, and you have unlimited support from the community. And if you are upgrading to enterprise-scale data, then you can purchase an enterprise version for a handsome cost.
I honestly believe that’s economical. At work, I have MySQL deployed so that I can store needed information anytime I want without asking for a budget. The reason why I wrote this is that I’m running source install on my Western Digital MyBook and it’s been hours since I sent a Make command. It’s my way of killing time I guess.
I borrowed my father’s notebook computer so that I can watch high quality video while I’m lying down on my bed. It’s running on Vista that I stripped off of every silly things Microsoft added. Anyway, I installed an MSNM and during the installation I was asked if I wanted to install the Writer which can be used to jot down offline entries for a blog. I wanted to try, so I installed the software. Here I am on my first entry using Windows Live Writer.
For a Windows user, it’s a great piece of software. Especially for me; I sometimes write my entries while on the ferry. I don’t have Windows in my Eee PC so I had to install an offline instance of Wordpress in it. With Windows Live Writer, it’s pretty straightforward. No web server or database engine to run, just let MS do the work for you. I must admit, it may be one of a few software that I like from MS.
I’m already praising the software even before saving and publishing this entry. So here we go…
I’m currently working with MSSQL Server 2005 and why does Microsoft have to make everything difficult? With MySQL, a multiple insert is as simple as INSERT INTO table (columns) VALUES (array of values), (another array of values), … (last array of values). This way works in MS SQL 2008, but that’s another expense.
My current assignment in the office is to export and import MS Access data into a completely different schema in MSS. I will pose a problem at the end of this entry and if someone has a solution, I would be grateful to you.
Multiple insert in MSSQL 2005 Thanks to Pinal Dave for this
USE database_name GO INSERT INTO table_name (column1, column2, ... columnN) SELECT 'value1a', 'value2a', ... 'valueNa' UNION ALL SELECT 'value1b', 'value2b', ... 'valueNb' ... UNION ALL SELECT 'value1n', value2n', ... 'valueNn'
Problem: How would I do a SELECT…INSERT in the middle of an insert because one or more columns are foreign keys. That way I don’t have to verify my data before inserting. Have the machine do it for me. For instance:
USE database_name GO INSERT INTO table_name (column1, column2, ... columnN) SELECT 'value1a', [SELECT...INSERT], ... 'valueNa' UNION ALL SELECT 'value1b', [SELECT...INSERT], ... 'valueNb' ... UNION ALL SELECT 'value1n', [SELECT...INSERT], ... 'valueNn'