Web Development, Networking, Security, SEO
MySQL, MSSQL, T-SQL, MariaDB, Percona & more.
Today a client asked me to remove all the posts from a given category to the auto-generated XML Sitemap of his WordPress blog and also redirect these posts to a …
WordPress - How to retrieve all posts from one or more given categories with a SQL query Read More
If you're a fond MySQL and/or MariaDB user you most certainly experienced at least one of these common errors: MySQL server has gone away Error reading result set's header Error …
How to fix "MySQL server has gone away", "Packets out of order" and similar MySQL connection errors Read More
If you found this post it probably means that you are experiencing the following scenario: A Windows 2012 or Windows 2016 Server machine with SQL Server 2008, SQL Server 2008R2, …
How to fix MSXML2.XMLHTTP and MSXML2.ServerXMLHttp Error 0x80070057 - The Parameter is Incorrect How to overcome the nasty Error 0x80070057 - The Parameter is Incorrect when executing a POST HTTP connection within a T-SQL Stored Procedure using the MSXML2.XMLHTTP or MSXML2.ServerXMLHttp object Read More Yesterday I was trying to investigate through an odd size increment affecting one of our MySQL databases. Since I didn't knew about the table(s) affected by the issue, the first …
How to get the size of all MySQL Tables in all Databases (and other size-related queries) Read More Today I was installing the latest (at the time of writing) MediaWiki build, which is 1.27.1, to a customer, together with all the bundled plugins and add-ins, following more or …
MySQL Lock Wait Timeout Exceeded Error in InnoDB Tables - How to fix it Read More If you stumbled upon this post it probably means that your favourite MySQL management client (SQLyog, MySQL Workbench or any other) and/or your MySQL-based website or service is suddently unable …
MySQL User Password Expired: how to (permanently) fix it Read More Have you ever needed to convert one, some or all the tables of a MySQL Database from MyISAM to InnoDB or the other way around? Here's a couple queries you …
MySQL - Convert all Tables of one or more Database(s) from MyISAM to InnoDB and vice-versa Read More Sometimes you'll need to retrieve your SQL Server Product Key from an existing installation on your Client or Server machine: the most common scenario takes place when you have an old Server …
SQL Server - Retrieve Product Key from an existing installation Read More
We already had the opportunity to talk about Replication between MySQL Database in a previous article, where we described it as a great way to increase the security and reliability …
When the Replication stops working: analysis and resync of MySQL Replication Read More Everyone working with MySQL (and DBMS in general) knows about the AUTO_INCREMENT attribute that can be used on a column - often the primary key - to generate a unique identity for new …
MySQL: two-columns Primary Key with auto-increment Read More