Toluu

SQL Zone - The social network for developers

Computing 95 Percentile In MySQLYesterday

When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The "average" is the evil of performance optimization and often as helpful as "average patient temperature in the hospital".

Making Your MySQL Tables More Effecient By Using Correct FieldtypesDecember 2

One of the biggest mistakes of today's fledgling MySQL programmers is their field type definitions, also known as data type or column type. Many are too quick to set up their tables, flying through the different options without giving it much thought. The time you spend setting up your tables will save you from many headaches later on down the road.

Essential MySQL Refcard Available - Download NowNovember 9

MySQL is the world's most popular open source database. Its scalability, robustness and high performance have made MySQL the database of choice by sites like Yahoo!, Craigslist, Wikipedia, YouTube, Flikr, and Facebook. The MySQL Refcard is an invaluable quick-reference tool for both beginning and seasoned MySQL developers, covering such core topics as configuration, administration software,...

SQL Server Scheduled Backups with NAntNovember 7

When installing and using production web applications, backup is always a must. I have written about SQL Server Backup before and this post would expend on that. The main goal here is to create a solution that periodically backs up your database. To do this, we’ll use the backup script from the previous post, employ NAnt to execute the script and zip the created backup. Last, we’ll schedule...

Polyglot PersistenceOctober 23

In late 2006 Neal Ford wrote about Polyglot Programming and predicted the wave of language choice we are now seeing in the industry to use the right language for the specific job at hand. Instead of assuming a "default" language like Java or C# and then warring over the many different available frameworks, polyglot programming is all about using the right language for the job...