Ozzie.eu

Working on a mixed environment, with Windows and Linux boxes, you might want to share some stuff from a linux machine with a user that doesn’t have an SSH client with file tranfer support or even installed. Or even send some files to download to a non-techie team mate. Something everybody...

The guys at Yahoo released their partition management script on github:At Yahoo, we manage a massive number of MySQL databases spread across multiple data centers.We have thousands of databases and each database has many partitioned tables. In order to efficiently create and maintain partitions we developed a partition manager which automatically manages these for you with minimal...

Link: Yahoo's MySQL Partition Manager is Open Sour...

So, I was going through the documentation for SQL Server 2016 Always Encrypted feature and I read this paragraph:The driver encrypts the data in sensitive columns before passing the data to SQL Server, and automatically rewrites queries so that the semantics to the application are preserved.We’ll still be able to get the execution plan for the query from the server, but regarding optimization,...

Playing around with the Employees sample database and full text search on MySQL, I found a weird bug. After creating a full text targeting a column on a table, a "select distinct" query to retrieve the range of values returns an empty set.So if you initially perform the following query, the outcome comes with 7 rows:mysql> select distinct title from titles;+--------------------+|...

Link: MySQL Bug #79497: Full text indexes and aggregate functions This bug is already reported at MySQL Bugs. It appears to be an upstream issue, reproducible on current 5.6 and 5....

Link: Should we be muddying the relational waters? Use cases for MySQL & Mongodb | Scalable Startups Seems I’m not the only one keeping away from JSON on the relational DB:I would shy away from the NoSQL add-ons that some relational vendors have added, to compete with their newer database cousins. This starts to feel like a fashion contest after a while.You can also get my...