blog.ozzie.eu

github.com

mjlmo (João Osório) · GitHub

https://github.com/mjlmo

Http:/ blog.ozzie.eu. Jul 15, 2012. Compares the schema in one database against all other databases. Check a list of MSSQL servers for a running service, last backups and integrity checks. Stack Exchange PowerShell Loader. 0 contributions in the last year. Summary of pull requests, issues opened, and commits. Learn how we count contributions. Mjlmo has no activity during this period. You can't perform that action at this time. You signed in with another tab or window. Reload. To refresh your session.

mvalente.eu

Music « mvalente.eu/mv.*

http://mvalente.eu/category/music

Mdash; Comments Off on The Renegade Trilogy. He’s just a boy, that has lost his way,. He’s a rebel, that has fallen down. He’s a fool, that’s blown away,. To you and me, he’s a renegade. He’s a clown, that we put down,. He’s a man, that doesn’t fit. He’s a king, but not in this town,. To you and me, he’s a renegade. But he is a king, when he’s on his own,. He’s got a bike, and that’s his throne. And when he rides, he’s like the wind,. To you and me, he’s a renegade. He’s a devil, that’s right,. He’...

blog.sqlstunts.com

July 2015

http://blog.sqlstunts.com/2015_07_01_archive.html

What have we learnt in two decades of MySQL? Article on Information Age. From obscurity to the mainstream, the journey of MySQL shows the power of the open source community to drive innovation. Read the full article here:. Securing your MySQL server. After installing a MySQL database server, like the one I posted earlier. If it's going to be a production environment than you should consider securing the instance by eliminating some of the basic vulnerabilities that come with a generic install. Y/n] n &#4...

blog.sqlstunts.com

September 2016

http://blog.sqlstunts.com/2016_09_01_archive.html

MySQL 8.0 - auto increment feature gets fixed. How InnoDB initializes AUTO INCREMENT counters is actually not a bug, but a documented mechanism. There were some complaints and even people who lost data. To initialize an auto-increment counter after a server restart, InnoDB executes the equivalent of the following statement on the first insert into a table containing an AUTO INCREMENT column. SELECT MAX(ai col) FROM. With MySQL 8.0. Subscribe to: Posts ( Atom ). View my Flipboard Magazine. 169; SQL Stunts.

blog.sqlstunts.com

November 2015

http://blog.sqlstunts.com/2015_11_01_archive.html

Get a summary footprint on a MySQL server instance. Landing on an enterprise with ongoing projects mean that servers are often handed to IT staff without complete knowledge of what's inside. I've built a simple script, scraping from here and there, to gather a summary of relevant information. Once you've gained remote access to the MySQL instance, you can execute the queries to identify the following information regarding the target database server:. All the tables and their space used ;. Finally, it che...

blog.sqlstunts.com

August 2015

http://blog.sqlstunts.com/2015_08_01_archive.html

Mysqlpump — A Database Backup Program. The MySQL 5.7 Release Notes. For version 5.7.8 are out. Besides the new JSON data type. There is also a new tool, called mysqlpump, which offers the following features:. Parallel processing of databases, and of objects within databases, to speed up the dump process. Better control over which databases and database objects (tables, views, stored programs, user accounts) to dump. Capability of creating compressed output. Creating user accounts on a secured MySQL server.

blog.sqlstunts.com

New tool: GitHub's online schema migration for MySQL

http://blog.sqlstunts.com/2016/08/new-tool-githubs-online-schema.html

New tool: GitHub's online schema migration for MySQL. From the the Github engineering team posted. The release of a new tool for triggerless online schema migration with MySQL. Although it's mostly targeted at databases using a replication architecture, if you don’t have replicas, or do not wish to use them, you are still able to operate directly on the master. For instance, foreign keys not supported. On this matter you would better off using pt-online-schema-change. From the Percona Toolkit.

blog.sqlstunts.com

September 2015

http://blog.sqlstunts.com/2015_09_01_archive.html

Ubuntu: Steps to install/update MySQL to the latest DMR. For learning, testing and keep up with things, one might want to install/update the MySQL version to the latest DMR (Development Milestone Release). At the time of this writing the latest DMR for MySQL is MySQL Community Server 5.7.8-rc. Before carrying on, keep in mind that:. This shouldn't be done on a production environment;. If you're aiming for an upgrade instead of a fresh install, always backup your databases first. Shell sudo dpkg -i. Shell...

mvalente.eu

Books « mvalente.eu/mv.*

http://mvalente.eu/category/books

Mdash; Comments Off on Godel, Escher and Bach: An Eternal Golden Braid. Godel, Escher and Bach: An Eternal Golden Braid. Back in 1986, at 18 years old, I read this wonderful huge book http:/ www.amazon.co.uk/Godel-Escher-Bach-Eternal-philosophy/dp/0140179976/ref. Sr 1 4 all through the Summer. I would take the book to read at the beach, thinking that not only would that give me more time to read but also it might also impress the ladies. It didnt; geek delusions. Http:/ www.ucp.pt. WIN ucp.pt #FAIL.