João Osório

29 Added | 5 Magazines | 1 Like | 2 Following | 3 Followers | @osoriopt | Keep up with João Osório on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “João Osório”

MySQL 8.0 - auto increment feature gets fixed

João Osório 2:23:00 AM mysql , transactions No comments<p>How InnoDB initializes AUTO_INCREMENT counters is actually not a bug, but a documented …

New tool: GitHub's online schema migration for MySQL

João Osório 4:07:00 AM migration , mysql , tools No comments<p>Shlomi Noach from the the Github engineering team posted the release of a new tool for …

Get a summary footprint on a MySQL server instance

João Osório 9:22:00 AM configuration , mysql , scripts No comments<p>Landing on an enterprise with ongoing projects mean that servers are often handed …

Real time query monitoring on MySQL using the SYS schema

João Osório 3:43:00 AM mysql , scripts , tools , tuning 1 comment<p>On an earlier post I wrote about real time query monitoring on MySQL with a third …

Real time query monitoring on MySQL - with 3rd party tool and without

João Osório 3:42:00 AM monitoring , mysql , performance , scripts , tools , tuning No comments<p>I've tried out Idera's MySQL Query Explorer, a free …

Using MySQL on Openshift - Red Hat's public cloud

João Osório 1:37:00 AM cloud , hosting , mysql , php , tools No comments<p>Developing a prototype, I found myself wanting a trustworthy cloud provider. …

Find and remove duplicate indexes

Having duplicate keys in our schemas can hurt the performance of our database:<p>They make the optimizer phase slower because MySQL needs to examine …

MySQL: a few observations on the JSON type

MySQL 5.7 comes with built-in JSON support, comprising two major features:<p>A native JSON data type<br>• A set of built-in functions to manipulate values of …

Databases

How to deploy a MariaDB Galera cluster on Ubuntu 14.04

Today we will show you about the deployment of MariaDB Galera Cluster on Ubuntu 14.04. MariaDB is an enhanced, drop-in replacement for MySQL while …

How to migrate MySQL to MariaDB on Linux

Since the Oracle's acquisition of MySQL, a lot of MySQL developers and users moved away from MySQL due to Oracle's more closed-door stance on MySQL …

Databases

Be Careful With MySQL's auto_increment. How We Ended Up Losing Data

Recently we stumbled upon a very strange bug that took us several hours to find. We were <b>losing data</b> in one of the MySQL tables. Let's put some …

Moving SQL Server data between filegroups – Part 2 – The implementation

In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is …

Troubleshooting SQL Server Wait Stats

Consequently, your first order of business in performance troubleshooting is to determine whether it is even your job to be the person …

Databases

Health Care: 4-Step Guide to Driving Patient Engagement

Health care providers who want to really engage with their patients need to go where their patients are—on social media.<p>But connecting through social …

9 Must-Have Features for Social Media Software

Share<p>Social media managers wear a lot of hats: marketer, customer service representative, campaign manager, videographer… the list goes on.<p>What if …

10 Social Media Tips for Small Businesses

Share<p>Why use social media to grow your business? It’s where your customers are. There are nearly 2.5 billion social media users across the globe. And …

Marketing

Backing up your SQL Server to Amazon's Cloud in Three Easy Steps

<b>Tuesday, January 23, 2018 - 11:18:56 AM - Adam</b><p>I am the accidental DBA for our small business and found this article very helpful. Other articles on …

7 Social Media Templates to Save You Hours of Work

Whether it’s your first time running social media for a company, or you’re just looking to boost your online profile, <b>social media templates will save</b> …

Social Media Marketing

SQL Server 2014 Checklist for Performance

Hello once again :)<p>Over time and after discussing this topic with other DBAs, I have compiled a short checklist to help with performance. Below are …

“How To”: Using Visual Studio to build Applications That Integrate with HDInsight/Hadoop

To make developers in Visual Studio productive with “big data” in their custom applications, we've added a deeper tooling experience for HDInsight in …

Monitor Database Growth and Usage

As a DBA, you probably manage hundreds of databases, if not thousands. Each of these databases has at least two devices and each of these devices may …