|
|
Prevent MySQL Injection Attacks
What this type of attack entails is a malicious user attempting to insert their own MySQL code into your database without you knowing about it. This is done through forms. Take for example, a log in form, where you type in your username. A typical statement to verify this action would be something like this.
Date: 2010-08-31
The IN Thing
Staying in fashion is often a tough proposition. If you're one of the unfortunate ones that do attempt to keep up, you likely end up with an overpriced and overstocked wardrobe.
Date: 2010-08-17
Data Integrity With Foreign Keys
In relational database design, we rely on keys in one table to relate to the primary keys of another. The InnoDB engine takes this concept and supplies the Foreign Key constraint to keep our relationships healthy and strong.
Date: 2010-08-03
Sorting By Count(*)
The other day, I was working on a fairly database-centric project, when I came across a problem I had never come across before. It seemed like such a simple task that I could not fathom why I could not write the query to get what I wanted.
Date: 2010-07-20
How To Dupe Duplicate Rows In Three Easy Steps
Repetitive information goes against good database design, and thus is reason enough to find and remove duplicate values. However, when utilizing an UNIQUE key or other types of indexes, duplications actually break or prevent statements from executing properly.
Date: 2010-07-08
Cooking With SQL: Short And Sweet
One of my fondest childhood memories revolves around my Grandmother's cooking. She was able to take out store bought hot dogs, boil them in a pot of water, and serve them up on piece of bread for many of my childhood lunches. Likewise, one my of fondest SQL memories is the first time I used conditional statements in my SQL to significantly shorten my overall code.
Date: 2010-06-22
Get Better Hosting, Get a Human With The Planet
If talking to your hosting provider feels like talking to the dead, you should be talking to The Planet.
More than 20,000 customers trust our dedicated and managed hosting services, because they're backed up with The Planet's people: people with the technical chops and training to give you the best possible hosting experience.
Date: 2010-06-21
A Uniform Query To The Community
The language of SQL is a lot like the English language. You have North American and Great Britain dialects of the language, not to mention significantly varying degrees of those dialects broken down amongst the geographical regions in which they're spoken.
Date: 2010-06-08
Teradata Releases New Database Features
Todd Walters introduced the new release - 13.10. Not every feature is equally interesting to me but a couple were important to note:
Date: 2010-05-25
MySQL Incremental Backup
Best practices encourage SQL administrators to have a system in place to automatically and routinely backup their database. Let's take a look at a line of Joe Sysop's crontab file:
Date: 2010-05-11
Get Better Hosting, Get a Human With The Planet
If talking to your hosting provider feels like talking to the dead, you should be talking to The Planet.
More than 20,000 customers trust our dedicated and managed hosting services, because they're backed up with The Planet's people: people with the technical chops and training to give you the best possible hosting experience.
Date: 2010-05-10
Using MySQL Workbench To Copy/View/Edit/Test A Remote Website Locally
This guide is designed to be used for Linux desktops and servers. For best results, use the same Linux version for the desktop as is installed on the server.
Date: 2010-05-06
Oracle Pledges To Up Investment In MySQL
An organization with a market cap in the neighborhood of $130 billion will soon be taking a renewed interest in MySQL. The chief corporate architect of Oracle, Edward Screven, has indeed indicated that Oracle will be helping MySQL in all sorts of ways.
Date: 2010-04-20
Get Better Hosting, Get a Human With The Planet
If talking to your hosting provider feels like talking to a robot, you should be talking to The Planet. More than 20,000 customers trust our dedicated and managed hosting services, because they're backed up with The Planet's people: people with the technical chops and training to give you the best possible hosting experience.
Date: 2010-04-19
Comparing NoSQL And RDBMS For Large Database Structure
The last few weeks I have witnessed a ton of passionate debate about what is better, NoSQL or RDBMS. It almost sounds like a religious battle between Windows and Mac fan-boys. To me this is like arguing that a hammer is better than a screw driver. If you need to pound a nail, I'll take the hammer.
Date: 2010-03-30
Using YQL To Connect With Large Groups Of APIs
A few days ago I spotted a Twitter conversation between Simon Whatley and Christian Heilmann which brought YQL back into my mind.
Date: 2010-03-19
DiscountASP.NET Improves Security Of SQL Server Hosting
DiscountASP.NET, a Windows shared hosting firm, has announced improved security of their SQL Server hosting platform through the support of SSL encrypted SQL communication with SQL 2008 and SQL 2005 servers in both their U.S. and U.K. datacenter locations.
Date: 2010-03-02
Microsoft Answers Calls For SQL Server 2005 Service Pack
Your wish is - at least in this one instance - Microsoft's command. The company has listened to requests for another service pack for SQL Server 2005, and in response, has decided to put something out in the fourth quarter of this year.
Date: 2010-02-19
Oracle Plans Strategy For Sun's Asset Integration
Last month Oracle executives laid out their strategy for integrating Sun's assets with Oracle. The whole event spanned over 4 hours. I'll just update readers on the section that related to Sun's open source assets.
Date: 2010-02-02
MySQL Could Be Bought By IBM
A quick review of the Save MySQL online petition stats today shows that the results are still in line with the results I reported previously. Over 90 percent of petition signees would require Oracle to divest MySQL to a "suitable third party". I noticed that Michael "Monty" Widenius' post explaining the petition provided several options for a "suitable third party".
Date: 2010-01-19
Florian Mueller Sets Out To Save MySQL IN 2010
Florian Mueller begins 2010 by demonstrating why he was named EU Campaigner of the Year by the Economist five years ago. While most of us were prepping for New Year's Eve celebrations or contemplating New Year's resolutions, Monty and Mueller spent December 28th launching an online Save MySQL petition against the Oracle acquisition of MySQL via Sun.
Date: 2010-01-04
|
|
