-
Category re-org
I re-organized my post categories a bit, so readers can pick and choose what you want more easily. Some people don’t care about technology, while others only like the technology part of this blog. This will make it easier for people to read things they want to read. Here are some examples on how to…
-
When does grant statement take into effect
In both Sql Server and Oracle, permission changes to a user take into effect right away, even when said user is connected at the time you made the change. In MySql, it is a little different, depending on how the permissions are given. If you use the GRANT statement, then it takes into effect right…
-
Refresh lost wireless Internet connection
I have WEP wireless connection at home. Sometimes, after waking up my computer from its hibernation state because of inactivity, I would lose internet connection. The wireless bar in system trey would still show excellent connetion, though. Here is how I solve this problem: 1. Go to command prompt; 2. Run this command: ipconfig /renew
-
Five things you don’t know about me
Prince Roy tagged me for this blogging game, where I am expected to reveal 5 things the world doesn’t know about me. Here goes: 1. I suck at important exams, for a variety of reasons, chief among them are not studying hard enough, not being able to concentrate during study, or lack of interest. There…
-
Total row counts of all tables in a Sql Server database
Sometimes you may want to know the total row counts of all tables in a database. The script below will give you a rough idea. However, it is not guaranteed to be accurate, though. It works in both Sql Server 2000 and Sql Server 2005. select sum(rowcnt) from sysindexes inner join sysobjects on sysindexes.id=sysobjects.id where…