Why you do not use GRANT ALL ON .?

Why you do not use GRANT ALL ON *.*? I was with a client today, and after rebooting a MySQL 5.0.22 instance cleanly with /etc/init.d/mysqld service, I observed the following error, because you always check the log file after starting MySQL.

Read more

To www or not www

Domain names historically have been www.example.com , written also with the protocol prefix http://www.example.com , but in reality www. is optional, only example.com is actually needed. www. is technically a sub-domain and sub-domains incur a small penalty in search engine optimization.

Read more

Patience and Passion at Web 2.0 NY

Gary Vaynerchuk spoke next at Web 2.0 NY on Building Personal Brand Within the Social Media Landscape . He was hilarious. His video presentation is available online , to share with others.

Read more

Integrity, clarity and responsibility – Web 2.0 NY Keynote

Next on the Web 2.0 keynote speaker list was Maria Thomas of www.etsy.com with her talk The DIY Guide to Growing a Company . If never heard of Etsy before – Your place to buy & sell all things handmade, interesting site.

Read more

What if software was a physical object – NY Web 2.0 Third Keynote

Some points of reference from the next Web 2.0 keynote by Jason Fried of 37 Signals Software business is a great place to be. You can build anything you want. All you really have to it type, it’s not easy to do, it’s just not that hard to do.

Read more

Technology changes, humans don’t. – Web 2.0 NY Second keynote

I needed a rest from my opening keynote review NY Tech 1995-2008. Opening Web 2.0 Expo NY Keynote but a few siginificant points from The Death of the Grand Gesture by Deb Schultz.

Read more

NY Tech 1995-2008. Opening Web 2.0 Expo NY Keynote

Web 2.0 Expo NY keynotes are happening today. Technology in use included CrowdVine which I’d not heard of, and plenty of Twitter feeds such as w2e_NY08 . The opening keynote was Fred Wilson from Union Square Ventures with his presentation New York’s Web Industry From 1995 to 2008: From Nascent to Ascendent .

Read more

Web 2.0 in NY

I will be attending next week’s Web 2.0 Expo 2008 in New York. Garys Guide has a schedule of the key events and off site associated event parties. It will be a bit of a change from the typical MySQL Conferences and recent OSCON Conference I have attended this year.

Read more

A neat trick for a row number in a MySQL recordset

While working for a client, I had need to produce canned results of certain different criteria, recording the result in a table for later usage, and keep the position within each result.

Read more

Securing your OS for MySQL with JeOS

Do you have a full time System Administrator? Do you have only a part-time SA, or none at all? Packet General’s Data Security and PCI Compliance solutions run on a dedicated appliance, based on a “Just Enough Operating System” (JeOS) to minimize exposure.

Read more

Domain name trends

It started with del.icio.us/ (which now ironically redirects to http://delicious.com ), and now it’s becoming more the trend to create a domain name with the extension included for effect. With unique .

Read more

How to secure MySQL data and achieve PCI compliance

This week I will be the moderator for a MySQL Webinar How to secure MySQL data and achieve PCI compliance being held Thursday, September 11, 2008, 10:00 am PST, 1:00 pm EST, 18:00 GMT.

Read more

What is Google’s direction?

Tonight over discussion was Android and what is Google’s ultimate direction. Have they lost their way, or are they just planning to explode with so many new things that will revolutionize what and how we do things.

Read more

Naming standards? Singular or Plural

It’s important that for any software application good standards exist. Standards ensure a number of key considerations. Standards are necessary to enforce and provide reproducible software and to provide a level of quality in a team environment, ease of readability and consistency.

Read more