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
So you have a website, and you’re getting traffic – but the sales aren’t rolling in. Or maybe they are, but they’re not setting the world on fire. All too often websites are built with little or no consideration given to their usability. And this is often the critical difference between good and great websites.
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
Is that Virtual Pageview really being sent to Google Analytics when someone submits my registration form? Does the Event Tracking Call for outbound links get to GA in time before the visitor has left my website? Why do I not get any data for clicks on my teaser links? Questions that can drive a Web
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
