Run MySQL Queries from PowerShell

Posted on August 22, 2016 · Posted in Powershell
posh: select query from mysql

One of the useful PowerShell features is the opportunity to connect to databases on remote servers, including MySQL ones. Thus, you can address MySQL tables to access data directly from PowerShell console. In this article, we’ll deal with the examples of connection to MySQL DB from PowerShell script and some.. read more

Generating Random Password with PowerShell

Posted on August 11, 2016 · Posted in Powershell
PoSh Script to Generate Random password

It is not easy to think a secure password, so that it meet certain requirements to the length and complexity. There are many programs and online services in the Internet to generate passwords, but why using third-party programs if you can do with the tools that already exist in your system… read more

Using NTFS Disk Quotas to Set Limits for Users

Posted on August 10, 2016 · Posted in Windows Server 2012 R2
Quota entries table

Disk quotas allow Windows administrators to control and manage the size of the disk space used by users on the file systems of servers and workstations. Windows Server supports two types of quotas: File Server Resource Manager quotas and NTFS quotas. Though FSRM quotas are more flexible and convenient, in.. read more

Fix: Windows 10 Screen Brightness Control Not Working

Posted on August 9, 2016 · Posted in Windows 10
Microsoft Basic Display Adapter

Some users complain that after a clean install or upgrade to Windows 10 they cannot adjust the screen brightness on some laptops. When trying to increase or decrease the brightness with the keys Fn+F11/ F12/etc. (depending on the laptop model), nothing happens. All other combinations and functional keys work well… read more

Blocking Remote Network Access for Local Accounts

Posted on August 4, 2016 · Posted in Windows Server 2012 R2
S-1-5-113 Local account

Using local accounts (including the local administrator account) to access another computer over network in Active Directory environments is not recommended on a number of reasons. The same local administrator login and password are often used on many computers resulting in putting many computers at risk if one computer is.. read more

Restore Missing CD/DVD Drive in Windows 10

Posted on August 2, 2016 · Posted in Windows 10
cd/dvd drive not detected after upgrade to windows 10

After upgrading from Windows 7 SP1 /  Windows 8.1 to Windows 10 (using free upgrade) some users have begun complaining that the system couldn’t detect a CD/DVD drive. In BIOS/UEFI the CD/DVD-ROM is identified correctly, but in Windows 10 itself it is not displayed in the Device Manager or is.. read more

Installing SFTP (SSH FTP) Server on Windows Server 2012 R2

Posted on July 28, 2016 · Posted in Windows Server 2012 R2
connect openssh on windows server using winscp

We go on talking about the means of secure file transfer between a client and a server running Windows Server 2012 R2. Last time we discussed using FTPS as a secure extension of FTP. Today we’ll dwell on the peculiarities of SFTP (Secure FTP) and its use in Windows Server.. read more

Removing VMWare vCenter Self-Signed Certificate Warning

Posted on July 27, 2016 · Posted in VMWare
The security certificate presented by this website was not issued by a trusted certificate authority.

When connecting to a VMWare vCenter server using a web-browser, there appears a warning of self-signed certificate issued by an untrusted certification authority. In Firefox, this warning can be disabled just by adding a vCenter website to the list of exceptions, but in Internet Explorer the procedure is more complicated.

Fixing High Memory Usage by Metafile on Windows Server 2008 R2

Posted on July 25, 2016 · Posted in Windows Server 2008 R2
metafile size in rammap utility

One of the file servers running Windows Server 2008 R2 encountered a problem of high RAM load resulting in the issues with the server and applications performance. It turned out that the memory was swamped by the system file cache containing file system metadata. The problem potentially affects all file.. read more

LZX File Compression on the NTFS Level in Windows 10

Posted on July 8, 2016 · Posted in Windows 10
compress Program-Files-x86 folder in Windows 10

Another rather interesting and promising, though underpromoted, feature of Windows 10 is the support of LZX data compression algorithm on the NTFS file system level. Compared to the familiar NTFS compression, the LZX compression ratio in Windows 10 is much higher (almost at zip level). The average compression level is.. read more