| |
Top Articles
MySQL and CakePHP: A Match Made in Heaven
[2012-01-18] CakePHP is a PHP framework that is become more and more popular because it is so easy to use and makes that task of building web applications a much less daunting task.
The 80/20 SQL and NoSQL Paradigm
[2011-12-14] I'm not ashamed to admit that I've seen Tyler Perry's Why Did I Get Married... more than once. I've even seen the sequel. Okay, maybe I'm a little ashamed. Can I blame my wife? Well, when life hands you romantic comedies, make lemonade - with plenty of alcohol. Also, use it to make good analogies to support your technical stance on why you shouldn't be in any hurry to implement that latest NoSQL technology.
Optimizing MySQL Part 2: Optimize Tables
[2011-11-17] As your databases get larger and larger and you continually make changes to them, they will get messy and fragmented, just like any data on your computer.
Optimizing MySQL - Part 1: Indexing
[2011-10-25] With all of its stability, complexity, and support options, MySQL can be slow sometimes.
The Steady Rise Of NoSQL
[2011-10-04] Now that it is clear that Oracle is serious about offering NoSQL functionality for their systems, the movement may really come to the forefront of the development world.
Nokia has Trouble with SQL Injections
[2011-09-02] It seems that even companies that have money for brilliant security measures, are still vulnerable to attack.
An Overview of Transactions
[2011-08-19] Databases are becoming more complex and as this evolution is taking place there is much discussion about SQL and noSQL, ACID and BASE, and almost everything else related to databases. Central to this debate and commonly misunderstood are transactions.
MySQL Runs the Web
[2011-07-26] Not only is the LAMP software stack the most common web implementation, but MySQL is also built into the leading CMS engines: WordPress, Drupal, Joomla, phpBB, and others. It is used by the largest websites in the world: Google, Facebook, YouTube, Wikipedia, and Flickr. When looking at database architectures, SQL is here to stay, and of them MySQL will continue to run the web.
Facebook On The Brink Of SQL Crisis?
[2011-07-14] Facebook may on the brink of a crisis and trapped in a MySQL "Fate Worse than Death." The entire social platform is operating a huge, complex MySQL implementation that stands to cripple the social giant. According to Micahel Stonebraker the only possibility is to rewrite everything from scratch.
MongoDB's Growth Into The Enterprise
[2011-06-28] NoSQL is still not well understood, as a term or a database market category, by enterprise IT decision makers. However, one NoSQL vendor, 10gen, creators of open source MongoDB, appears to be growing into enterprise accounts and distancing themselves from competitors. If you're considering, or curious about, NoSQL databases, spend some time looking at MongoDB.
CUBRID Is Having A Programming Contest
[2011-06-07] CUBRID is having a programming contest! I like programming contests that almost anyone can enter, and this one is interesting for a different reason than some others. For those who do not know, CUBRID is:
Comodo Brazil Breach Reminds Admins to Guard Against SQL Injection
[2011-05-27] Back in March 2011, the Italian reseller of trusted, authorized, security certicates, Comodo was compromised through a simple SQL injection attack. The relevation that such a visable figure in online security could be breached with a simple SQL injection attack prompted SQL injection attempts at other Comodo resellers around the world. The latest to fall victim was Comodo Brazil. Both of these attacks involved a security auditting tool, sqlmap, Python script; and similar SQL injection points can be found by searching Google for script filetypes and generic paramaters names. A simple attack on a significant authority figure should give database administrators more to consider when securing their servers.
Advanced MySQL in PHP
[2011-05-05] Let's face it, we all know the basics of connecting to a MySQL database in PHP. That's development 101. But how many times have you looked at your code and wondered "there must be a better way to do this" to yourself? These are a couple PHP functions that I have found to be indispensable as my career as a web developer have progressed.
Oracle Updates SQL Developer
[2011-04-22] The graphical interface for SQL developers has been updated by Oracle, and the new version promises increased functionality and productivity, while simplifying various developmental processes. The third version of Oracle's SQL Developer looks to be the most comprehensive of the release family, as Oracle's update is a response to user feedback.
Lizamoon SQL Injection Attack Downgraded
[2011-04-05] Late last month, reports began to circulate about a large-scale SQL injection attack known as Lizamoon, and early figures made it look quite dangerous. Now, fortunately, a different method of measurement has indicated the threat isn't as serious as first thought.
DDoS Attacks Pass SQL Injections As Top Threat
[2011-03-22] SQL professionals may soon start seeing a decrease in the number of suspicious looks they receive. A new report from Trustwave indicates that distributed denial of service attacks have passed SQL injections to become the top threat most organizations face.
NoSQL Job Trends – February 2011
[2011-03-01] February is obviously job trends month here, and we have another installment. Today, we are looking at NoSQL job trends. In the previous installment of NoSql job trends, there were eight products included. In this edition, I have included Riak due to a recommendation in the previous post and the amount of buzz I have seen over the past few months.
Oracle Adding Firewall To Their Database
[2011-02-18] For Oracle users who are continually worrying about security, this news will seem like a breath of fresh air.It was announced earlier this week that Oracle would be adding a database firewall to their system. This will provide monitoring services, enforce normal behavior, and defend against unauthorized access or injection attacks.
The Importance of Normalization
[2011-01-27] I am a programmer. When I begin a project, I look at it from a programming point of view. This is almost exactly the opposite of a database administrator's point of view.
Could Oracle's Missteps Hurt The SQL Community?
[2010-12-07] Oracle hasn't won many friends in open source communities since its acquisition of Sun Microsystems and Sun's array of open source assets including MySQL, Java and OpenOffice. Oracle seems bent on continuing this trend with the growing Hudson open source project.
How To Query a Section of a Table
[2010-11-23] I recently needed to write a query that would take only certain rows from a table and run a query against those specific rows. I tried JOINs and sub-queries, but nothing quite worked. It was then that one of my more SQL-savvy coworkers introduced me to the idea of a VIEW.
Manipulating Time in your MySQL Tables
[2010-11-09] In the databases I have used, I have found two major schools of thought when it comes to storing dates in tables. There will either be a string like date, listed out in year-month-day hour-minute-second format, or there will be a timestamp. For those who don't know, a timestamp is usually just the number of seconds since the Unix epoch (00:00:00 UTC, January 1, 1970). One big advantage is that the timestamp is the same regardless of timezone or daylight savings time. Let's look at how we can manipulate timestamps to our advantage.
NoSQL 100: Brief History and Introduction to (No)SQL
[2010-10-26] NoSQL has managed to slip under many noses the past decade. Other than its initial plunge into the scene, NoSQL has made little to no waves. However, these systems have been improving to the point that they are now viable alternatives to traditional database management systems. Before we get into more advanced discussion on NoSQL, let's first get educated with some basic history and terminology.
SQL Server 2008 SP2 Fixes Bugs, Improves Manageability and Compatibility
[2010-10-13] After all the feedback from the release candidates and hot-fixes, Microsoft finally released an official update, Service Pack 2 for SQL Server 2008 this month. SQL Server 2008 SP2, a long awaited update, not only fixes numerous bugs, but also supplies new functionality for managing database instances using Data-tier Application (DAC) technology and forwards compatibility with SharePoint 2010 and with SQL Server 2008 R2.
Join A Table To Itself Using Aliases
[2010-10-12] SQL programmers are familiar with the common ways of joining multiple fields from multiple tables based on predicate criteria by using Inner and Outer, Left, and Right. But sometimes an SQL programmer will find a time when the need arises to combine, or join, the fields of a table to itself.
|
|
