FYI : Starting A Part-Time Degree

Yup , you read that right. My part-time degree program is going to start so there might be days when I might not have the time to post any new tutorials or examples. Don’t worry , this is still my main site where I am supposed to get most traffic and most ad $$ so I won’t be abandoning for some time. Unless perhaps I get married or something. Anyway , the degree will have a lot of Database stuff so the good thing is I won’t have to think alot to post. :)

Cheers
Administrator

Added Ads

I added some ads , for making some $$ obviously. Lets see how it goes. If you like my blog , pls do click of them. If you don’t , click on them anyway , pls tell me why you don’t like it. Thanks!

EDIT : I have removed them. I find them pretty distracting to be honest. So I placed them on the right side. You are here to read my posts not to get distracted by the ads. I be glad if you click on the ads but there is no point in annoying the visitors who come to read.

Disk IO and XCache

Well , I been getting emails about my disk IO thrashing above 1000 so I went to see how I can reduce it. As always , the answer is short and sweet. XCache. There are tons of tutorials on how to install it , 90% of them right on its own website , so no problem with documentation. Thank you to the XCache team from me!

Moving Forward

I think more or less we are done with SQL for now. For 90% of the time using a database, what we been doing would suffice. The process of Creating , Reading , Updating , Deleting information is aka ‘CRUD’ in some programming and database textbooks. What we havn’t covered would be

  • ORDER BY
  • In-Depth details of SQL Functions
  • SQL Programming , eg T-SQL and PL/SQL
  • Database Administration
  • SQL Security

Before we go into those , I would like to take a detour around the whole ‘Relational Database’ and explore the shallow water of programming. Of course , both topics will overlap eventually. For example , Microsoft LINQ or Ruby on Rails require that you understand both the programming side , such as loops and functions as well as database statements such as SELECT. You will eventually have to know both. The higher you go , both are inseparable. In fact , you could say Google is nothing more than a giant database full of information on the websites. How do you extract data out of it? By using programming languages , Google uses Python extensively , if you want to know.

So here is what I plan to do for foreseeable future…

  • General Programming Topics , eg functions , loops ..
  • Dive deeper into 2 or 3 languages
  • See how both programming languages and database can be integrated
  • Have Fun!

Added a new page

Hi Peeps ,

This site being SQLHack and well there isn’t much excitement , yet , so I thought why not add some cool stuff. I read the Hacker’s Manifesto about 10 years back when I was actually playing with black orifice on some noobs in dalnet. If you didn’t catch what I said , nvm. Those days are history. Anyway , back to today , I thought it would be interesting to put it on my own site. So what do you think?

regards
Administrator