Query all WordPress posts in MySQL not having a Yoast SEO meta description
If you just started using Yoast SEO it's sometimes nice to know which posts don't have a meta description yet. Knowing this, you can add the description which is good for your SEO results. Here is a query you can use to query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin.
Disable WordPress XCloner Plugin logger in MySQL / phpMyAdmin
If XCloner Logger option is enabled, it will store a log file inside the xcloner-XXXXX folder inside the backup archive. This can generate a huge amount of temporary files and log files, slowing down your file system.
Disable Joomla Contacts component (com_contact) in MySQL / phpMyAdmin
The built-in Joomla contact forms component (com_contact) is abused by spammers, I explain how to disable these forms and combat this abuse.
How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error
A possible fix for Yoast broken DeleteDuplicateIndexables statement
Reduce Wordfence CPU usage, disable Wordfence "Live Traffic View"
The Wordfence "Live Traffic Options" ("Traffic logging mode") feature can cause high CPU usage and load issues for WordPress websites.
ASP and ASP.NET connectionstring examples for Microsoft SQL Server and MySQL
A connectionstring is sometimes a bit obscure. Do I need ODBC or OLE DB? When you need one and Google for it, you often find old ones that either don't work at all anymore, or are not optimal. This article provides you with a couple of ASP.NET to SQL Server connectionstring examples, and as a bonus for ASP to MySQL too.
MySQL Connector/ODBC C# test script
Quickly test the MySQL database connection from ASP.NET using this C# test script. It utilizes the MySQL ODBC 8.0 Unicode Driver and SslMode is available.
How to use SSL in PHP Data Objects (PDO) mysql
If you want to connect securely to your MySQL database using PHP Data Objects (PDO), here is how to connect to MySQL with PHP PDO using an SSL encrypted connection.
Restore single MySQL table from a full mysqldump backup file
If you need to restore a single table from a full MySQL backup, you may find yourself wondering "how do I do that?". There are a few steps required, I outline them here for you to restore the contents of just one table back into the database from the mysqldump using Bash.
Optimized WordPress hosting (9+ practical tips)
Optimized WordPress hosting is a subject on which a lot is written about. And therefore, this post is not about where to host your WordPress blog, or who offers the best WordPress hosting. This post is for you developers, what you can do to optimize your WordPress hosting. Or for any other PHP web application for that matter. This post is not about setting up high-availability, fail-over, clustering, IIS versus Nginx versus Apache, RAID 1, 5, 6, 10, different types of storage, and so on. It’s about solving performance issues.
windows-server (96)
iis (80)
powershell (76)
php (54)
wordpress (45)
mysql (36)
windows (34)
performance (28)
linux (23)
web.config (23)
Website (22)
htaccess (20)
aspnet (19)
url-rewrite-module (19)
sql-server (18)
bash (18)
optimization (18)
ssl (17)
plugin (13)
windows-10 (12)
devops (11)
monitoring (11)
security (10)
gnu-linux (10)
appcmd (10)
wsl (9)
smtp (9)
wincache (9)
wmi (8)
zabbix (8)
windows-update (8)
opcache (8)
openssh (7)
database (7)
dism (7)
iis-60 (7)
sysops (6)
wsus (6)
apache (6)
hyper-v (6)
virtualization (6)
spam (6)
functions-php (6)
classic-asp (6)
ddos (6)
password (5)
email (5)
active-directory (5)
joomla (5)
command-line (5)
application-pool (5)
blacklist (5)
t-sql (4)
wql (4)
https (4)
group-policy (4)
backup (4)
connector-net (4)
debug (4)
logparser (4)
network-adapter (4)
dns (4)
query_cache (4)
ghost (4)
iisnode (4)
node-js (4)
vbscript (3)
umbraco (3)
windows-firewall (3)
brute-force (3)
ftp (3)
postfix (3)
forensics (3)
benchmark (3)
xss (3)
disk-cleanup (3)
disk-space (3)
sql-injection (3)
openssl (2)
net-core (2)
visual-studio (2)
windows-defender (2)
rdp (2)
connector-odbc (2)
c (2)
mysqldump (2)
xml-rpc (2)
smb (2)
cross-site-scripting (2)
innodb (2)
httpbl (2)
centos (2)
magento (2)
denial-of-service (2)
deployment (2)
windows-deployment-services (2)
mysqli (2)
open-xchange (2)
waf (2)
web-application-firewall (2)
windows-11 (1)
ipv6 (1)
networking (1)
sqlce (1)
tinymce (1)
Prianha-CMS (1)
kvm (1)
http-3 (1)
quic (1)
wmsvc (1)
database-mirroring (1)
service-principal-names (1)
spn (1)
jetpack (1)
api (1)
kms (1)
elasticsearch (1)
red-hat (1)
varnish-cache (1)
dhcp (1)
jquery (1)