| |
Top Articles
Prevent MySQL Injection Attacks
[2010-08-31] 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.
The IN Thing
[2010-08-17] 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. Some fashions, however, never die, and thus can continue to be used at your discretion. Likewise, your database can become stuffed to the seams, and there may be situations where you want to return a result if it matches not only a single value, but also any from a host of values.
Data Integrity with Foreign Keys
[2010-08-03] 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. It's truly a relationship miracle-worker. Eat your heart out, Dr. Phil.
Sorting by Count(*)
[2010-07-20] 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. What I needed to do was to choose only the entries in a table which appeared a certain number of times.
How to Dupe Duplicate Rows in Three Easy Steps
[2010-07-08] 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.
Cooking with SQL: Short and Sweet
[2010-06-22] 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. Nothing better than hot dogs and SQL...
A Uniform Query to the Community
[2010-06-08] 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.
Teradata Releases New Database Features
[2010-05-25] Todd Walters introduced the new release - 13.10. Not every feature is equally interesting to me but a couple were important to note:
MySQL Incremental Backup
[2010-05-11] 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:
Using MySQL Workbench To Copy/View/Edit/Test A Remote Website Locally
[2010-05-06] 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.
Oracle Pledges To Up Investment In MySQL
[2010-04-20] 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.
Comparing NoSQL And RDBMS For Large Database Structure
[2010-03-30] 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. If you want to turn a screw, I'll take the screw driver.
Using YQL To Connect With Large Groups Of APIs
[2010-03-19] A few days ago I spotted a Twitter conversation between Simon Whatley and Christian Heilmann which brought YQL back into my mind.
DiscountASP.NET Improves Security Of SQL Server Hosting
[2010-03-02] 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.
Microsoft Answers Calls For SQL Server 2005 Service Pack
[2010-02-19] 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.
Oracle Plans Strategy For Sun's Asset Integration
[2010-02-02] 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.
MySQL Could be Bought By IBM
[2010-01-19] 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".
Florian Mueller Sets Out To Save MySQL IN 2010
[2010-01-04] 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.
Negative Reactions To Oracle's Acquisition of MySQL
[2009-12-09] It's a given fact of human nature that people despise change. We're creatures of habit, and we like things to remain the way they have been. There's of course some exceptions to the rule, but that isn't the case with Oracle's attempted acquisition of Sun Microsystems. If you haven't been keeping up, Oracle has been attempting to purchase Sun Microsystems since April, but has been stymied by the Europe's antitrust laws.
Yahoo Bounces Back From SQL Injection Flaw
[2009-11-17] Jobseekers are perhaps some of the last people in the world who deserve to be bothered by malware; things are tough enough for the unemployed, particularly in this economy. Yahoo might deserve a round of applause, then, as the company fixed an SQL injection vulnerability affecting its HotJobs site.
Microsoft Schedules SQL Server 2008 R2 Price Hike
[2009-11-10] People and businesses that want to get close to Microsoft's SQL Server 2008 R2 may have to dig a little deeper than they expected. Microsoft recently announced that certain editions will carry a higher price tag for the first time in about four years.
MySQL Founder Concerned Over Fork User Protection
[2009-10-21] Ex MySQL leaders on opposite sides of EU vs. Oracle discussion. MySQL's ex-CEO Marten Mickos and MySQL co-founder Michael ‘Monty' Widenius have recently released open letters to the EU. Marten writes in support of Oracle acquisition of MySQL, as part of the Sun acquisition. Monty writes to block MySQL from being controlled by Oracle.
Survey Puts Microsoft SQL Server, MySQL In Tight Race
[2009-10-08] When it comes to relational database systems in emerging markets, Microsoft SQL Server is king, according to the results of a new survey. MySQL might be characterized as the prince who's just a heartbeat away from the throne, though.
No MySQL Mentioned in WSJ Ad
[2009-09-15] Matt Asay and Marten Micknos both tweeted about Oracle's ad targeted at Sun customers that ran in Wednesday's Wall Street Journal. It's also on Oracle's website:
SQL Injection Attack Hits Over 55,000 Sites
[2009-08-25] The existing SQL community may want to take note: a whole lot of people are getting introduced to the database computer language whether they like it or not. A mass SQL injection attack has compromised upwards of 55,000 sites, and from there, normal Internet users are becoming the targets.
|
|
