-
Efficient use of COUNT()
The other day I was trying to figure out how many records there were in my DB I found in a website that I needed to use COUNT(*). The example given went something like this: SELECT COUNT(*) FROM ‘table’ and while this worked as advertised, I got a very inconvenient side effect. The query was…
-
Editing your shared IP in WHM
Today I decided to add a new site to our company VPS. As it turns out, the VPS shared IP was configured in an internal IP, I tried searching the Interwebs for a way to change this IP to one that is accessible to the out side with no luck so after some looking around…