Online retail giant Amazon just announced a new update which allows users to run Microsoft’s database and web programming platform ASP.NET, on its Relational Database Service (Amazon RDS). Amazon reveals that users can now use Microsoft tools they are accustomed to – to deploy, manage and scale SQL Server databases and ASP.NET applications. Amazon also
MySQL is one of, if not, the best database management systems. It’s even better because it’s open source which allows anybody to make changes to it as they see fit for their own needs. Major companies use it to power their Web sites and it’s always nice to see these companies make their work with
April 10th, 2012 will be an interesting day. According to an SAP release, that is the day it will announce it’s plans to compete directly with Oracle, claiming they will “become a leading database vendor.” Reuters report seems to believe the move will involve SAP’s HANA software. The software is a in-memory based system and
Nearly every business has shifted away from terrifyingly large groupings of spreadsheets in favor of more organized and dynamic databases. Of course when nearly every business uses some iteration of the same conceptual data housing, attackers can take advantage of the standardized structure. In 2009 there were 141 reported data breaches. In 2010 that number
Writing a multi-threaded program is hard enough to do without having to worry about data concurrency in your database. Lucky for us, MySQL has the methods necessary to help us keep our data current built in. There are two main kinds of locks supported by MySQL, table-level locks and row-level locks. Table-level locks are supported
I prescribe to the slow and steady approach in life. It’s a proven methodology in becoming succesful (just ask the Tortoise and/or the Hare). However, slow and steady is typically not acceptable in data computation, and SQL is no different. Thus, MySQL provides a Slow Query Log. Do you use the slow query log? Let
NoSQL solutions are now vital to many applications. When evaluating the use of NoSQL in new projects or upgrades to existing projects, project managers should take close examination of the potentially hidden costs of NoSQL. Have you experienced some hidden costs in your NoSQL implementation? Let us know in the comments. Human/Knowledge Resources Learning NoSQL
The previous article on the subject gave you a nice introduction to MySQL date types, but here I’m going to go more into entering dates and a few other important points. MySQL has a long list of functions associated with Date and Time fields, and they can be difficult to understand what they do, simply
With all of the talk about NoSQL going around, it is clear that people want better ways of storing large amounts of data in their databases. However, before you go running off to implement one of these new systems, don’t forget that SQL has a few tricks of its own. Specifically, I am speaking of
Storing dates and times in MySQL may appear to be as complicated as dates in real life to those who have never delved into the subject. Programmers often default time using an int datatype and storing the current timestamp using the time() function in PHP. Is there a best way to store dates and times
