MySQL – Domain Web Center

Trump 2020

[ 2025-08-17 ] Why so many people annoyed with Trump? People
[ 2025-08-13 ] Wins and losses of Donald Trump after the Elections Ideas
[ 2025-07-24 ] They ” . . . conspire to produce an unaware and compliant citizenry” – How? Ideas
[ 2025-07-23 ] We win, our country wins when . . . Ideas
[ 2025-05-06 ] Russian hacking? – No. Putin aspired to help, but “NSA has moderate confidence” with a fake seal Ideas
[ 2025-04-29 ] Learn from Donald Trump skills of handling the press (по-русски) Ideas
[ 2025-04-22 ] Democratic Machiavellian disciple opens his cards (unwillingly) Ideas

T-SQL – replace TOP 1 field with MAX(field) to gain speed, cure errors

2025-10-04 Udar Gromov 0

How to Install WordPress 4.X on Windows 10 and IIS 7.5

2025-07-19 Udar Gromov 6

This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop […]

Uninstall just one instance of SQL server

2025-07-18 Udar Gromov 0

How to Work with MySQL – Basic Tasks

2025-07-15 Udar Gromov 0

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]

Stop multiple “upprinterinstaller” command windows popup every hour

2025-06-04 Udar Gromov 0

PHP chokes server with TEMP files – Updated and Solved

2025-04-23 Udar Gromov 0

I am running PHP on IIS 7.5. This is a Windows 2012 Server. Fresh clean install every time. The only way to access and delete these TEMP files are by using a command prompt. And this deletion procedure will run for several DAYS . . . The Problem The story […]

MySQL: Fantastic adventures – WordPress users and their roles

2025-04-21 Udar Gromov 0

This was exciting. After years of neglect, I have decided to examine, who is registering on my WordPress site, and what is that they are doing. I knew that most of them are just a result of robot activities, and they are just a dead weight in the database (useless […]

How to Convert Julian Date to Gregorian in MS SQL

2025-04-17 Udar Gromov 0

Julian date is stored in YYYDDD format, for example 12/31/99 will be stored as 99365 and 01/01/2017 will be stored as 117001. If you need to convert the date from YYYDDD to any conventional date format like dd/mm/yyyy in SQL use steps below. The idea is to convert year and […]

SQL DB2: Concatenate TEXT from multiple records

2025-02-10 Udar Gromov 0

Scenario Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field. This should be a numeric field indicating the sequence in […]

Amazon Linux 2 with WordPress, PHP 8, MySQL 8 and Node.js (in progress)

2025-01-31 Udar Gromov 0

Adding a new WordPress site to an Existing Installation

2025-01-30 Udar Gromov 0

Task You already have a working WordPress (WP) site. Now, you need to add one more site with a new MySQL database. This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip […]