Blog TsqlMaster Posts - TopicsExpress

One More Possible Reason for ERROR 1959 (OP000) Invalid role
One More Possible Reason for ERROR 1959 (OP000) Invalid role specification ift.tt/1C5MMGY Mon, 2015-01-26 09:59chris.calenderI ran into this error tod...

Mo’ Data, Mo’ Problems ift.tt/1CnajSo Welcome to blog #2 in a
Mo’ Data, Mo’ Problems ift.tt/1CnajSo Welcome to blog #2 in a series about the benefits of the Fractal Tree. In this post, I’ll be explaining Bi...

Securing JSON APIs with Wrapper Objects ift.tt/1xYlavy At
Securing JSON APIs with Wrapper Objects ift.tt/1xYlavy At VividCortex, security is a top priority. Leading companies such as Zappos, Dyn, and Etsy use...

Identifying useful info from MySQL row-based binary logs
Identifying useful info from MySQL row-based binary logs ift.tt/1ElTre7 As a MySQL DBA/consultant, it is part of my job to decode the MySQL binary log...

When ONLY_FULL_GROUP_BY Won’t See the Query Is
When ONLY_FULL_GROUP_BY Won’t See the Query Is Deterministic… ift.tt/1BGHRrP This is a follow-up post to my recent announcement of only_f...

Log Buffer #404, A Carnival of the Vanities for DBAs
Log Buffer #404, A Carnival of the Vanities for DBAs ift.tt/1xmrwth With new year already in fast gear, bloggers are sparing no stone unturned to come...

InnoDB crash recovery speed in MySQL 5.6 ift.tt/1rh8G5N It has
InnoDB crash recovery speed in MySQL 5.6 ift.tt/1rh8G5N It has been a while since I have looked at InnoDB crash recovery. A lot has change in the last...

The Monitoring mistake OR how dreaming can bring ideas
The Monitoring mistake OR how dreaming can bring ideas ift.tt/1CkY2Pl Hi Paul how is going? Good Marco and you? Good, I had a stressful week last week...

SQL SERVER SUPER QUERY Resurrection... - I just rescued the SUPER
SQL SERVER SUPER QUERY Resurrection... - I just rescued the SUPER QUERY script and re-wrote it in order to list all more complete info on the records ...

OpenStack’s Trove: The benefits of this database as a service
OpenStack’s Trove: The benefits of this database as a service (DBaaS) - Peter Zaitsev - ift.tt/1spSmeG In a previous blog, my colleague Dimitri Vano...