Skip to main content

Posts

Don't switch to Teksavvy

After learning that I actually have a choice when it comes to Cable Internet besides Rogers, I decided to switch over to Teksavvy two weeks ago. As it turns out, out of the two weeks, I was kept offline for 10 days. Now I regret switching over dearly! Having to live offline was bad enough, the support I was given by Teksavvy was even worse. As soon as I went offline, I made a call to their technical support line. I was told since it was weekend on Saturday morning, someone would be sent over to look into my issue on Monday after 5PM. I was still offline till Tuesday when I got a call from Teksavvy telling me that they cannot make it on Monday and they can only send their support staff on SATURDAY after 5!! Having no choice, I agreed and despite having pre-arranged plans on my Saturday evening, I had to stay home for 3 hours waiting for a support guy to show up. As it turns out, no one came knocking in my door till 9PM and then I decided to call again. Now their story got interesting a...

why it's a good idea to answer forum questions

A lot of people use google and forums to figure out technical programming questions, but we are often too lazy to answer people's queries even if we knew the answer. Well today I had a question on how to close window from GWT and by instinct headed to google only to find a reply: http://markmail.org/message/qqr3r7ji6hl7k5vp#query:+page:1+mid:insr656lelc5kebx+state:results that I happened to post myself 3 years ago!

Eclipse issues with JDK 1.6 update 21

A lot of users seem to be having issues running Eclipse with the latest update of Java from Sun/Oracle. Apparently they changes the metadata in the dll that shows Oracle instead of Sun. Here are the details and workarounds to fix it: https://bugs.eclipse.org/bugs/show_bug.cgi?id=319514

Automate SQL Dumps for SQLServer

The backup mechanism in SQL Server may be fine for many cases, but there are limitations with it (like restoring to a different server). I really like how I can just dump the database SQL with mySQL which can be easily processed with custom scripts. I was looking around for a mysqldump equivalent for SQLServer. I know you can do this with the SQL Management Studio through GUI in 2008 version, but I need this to be automated. This lead me to discover the SQL Server Management API . With it, you can do a SQL Dump like: using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common; using Microsoft.SqlServer.Management.Sdk.Sfc; namespace SQLGenerator { class Program { static void Main(string[] args) { //Connect to the local, default instance of SQL Server. { Server myServer = new Server(args[0]); Database db = default(Database); db = myServer.Databases["be"]; ...