11 million installations can't be wrong

MySQL Journal

Subscribe to MySQL Journal: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get MySQL Journal: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories

There is an old saying that good things come in small packages. This saying definitely applies to this book, which focuses in on a set of functions that most people are not aware of that are available in SQL Server. To start off with we need to answer the following question: What are T-SQL Window functions? These functions have nothing to do with the Microsoft Windows API. They are in essence a way to create a window into your data as you process each line in a query. Their strength lies in the ease with which you can solve tricky queries. The authors also point out that these functions don't add any new functionality per se as you could create the queries the old way; however, in general the functions are much more efficient. One very neat capability of these functions is to allow you to include non-aggregated columns in an aggregated query, which is a big limitatio... (more)

Data Platforms as a Service | @CloudExpo @Pythian #API #Azure #BigData

Download Slide Deck: ▸ Here Download Slide Deck: ▸ Here A Tour of Data Platforms as a Service With the proliferation of both SQL and NoSQL databases, organizations can now target specific fit-for-purpose database tools for their different application needs regarding scalability, ease of use, ACID support, etc. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on ... (more)

Basic Apache and MySQL Performance Tuning

Apache and MySQL make up the backbone of many Linux based web servers. According to the August 2011 Web Server Survey by Netcraft, Apache currently runs on 65.18% (or 301,771,518!) of web servers.  Similarly, MySQL is the most popular open source database and holds a significant portion of the market share – especially for web content.  This article will detail how you can get at the ‘low-hanging fruit’ in order to make some simple changes that will yield big performance gains. Apache Tuning If your system is running httpd, the Apache web server, it will definitely benefit you t... (more)

Five Big Data Features in SQL Server

Traditional RDBMS & New Data Processing Over the past two decades relational databases have been most successful in serving large scale OLTP and OLAP applications across enterprises. However, in the past couple of years with the advent of Big Data processing, especially for processing unstructured data coupled with the need for processing massive quantities of data, made the industry to look into Non RDBMS solutions. This has lead into the popularity of NOSQL databases as well as massively parallel processing frameworks. However the traditional RDBMS were quick to react and added ... (more)

MySQL Ace To Run Eucalyptus

Eucalyptus Session at Cloud Expo Mårten Mickos, the guy who sold MySQL to Sun for a billion dollars, has got himself another company. Now all he has to do is find another sucker like Sun. Mårten, who wouldn't be Mårten without that cute little Finnish doohickey over his name, has been named CEO of Eucalyptus Systems, the open source private cloud start-up. Woody Rollins, who was CEO, has morphed into the company's CFO. Since leaving Sun and MySQL last year, Mårten has been at Benchmark Capital, which backed MySQL, as entrepreneur-in-residence trying to spot his next opportunit... (more)

Node.js in Retail | @DevOpsSummit #DevOps #Docker #Microservices

How Node.js Revolutionized the Retail Space By Omed Habib In a crowded world of popular computer languages, platforms and ecosystems, Node.js is one of the hottest. According to w3techs.com, Node.js usage has gone up 241 percent in the last year alone. Retailers have taken notice and are implementing it on many levels. I am going to share the basics of Node.js, and discuss why retailers are using it to reduce page load times and improve server efficiency. I’ll talk about similar developments such as Docker and microservices, and look at several companies implementing these techn... (more)