UTC in Microsoft Windows

To dual boot with Windows, it is recommended to configure Windows to use UTC, rather than Linux to use localtime. (Windows by default uses localtime)

It can be done by a simple registry fix: Open regedit and add a DWORD value with hexadecimal value 1 to the registry HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation\RealTimeIsUniversal

You can do this from an Administrator Command Prompt running:

C:\>reg add "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation" /v RealTimeIsUniversal /d 1 /t REG_DWORD /f

Repeated Message – Driver exit RTD3 [USB issue]

#Display USB Selective Suspend when on battery

powercfg.exe /SETDCVALUEINDEX SCHEME_CURRENT 2a737441-1930-4402-8d77-b2bebba308a3 48e6b7a6-50f5-4782-a5d4-53bb8f07e226 1

#Display USB Selective Suspend when plugged

powercfg.exe /SETACVALUEINDEX SCHEME_CURRENT 2a737441-1930-4402-8d77-b2bebba308a3 48e6b7a6-50f5-4782-a5d4-53bb8f07e226 1

Windows 11 / Windows 10 Download

Goto https://uupdump.net

Search  “23H2” (build number 22631)

Download and unpack files

Click uup_download_windows.cmd batch file and select the Run as administrator option.

After download use Rufus or other app to create bootable USB Drive

Install Windows 11 24H2 on Unsupported Hardware

Get ISO fro https://www.microsoft.com/pl-pl/software-download/windows11
Mount iso
Windows+r “cmd”
select mounted drive ex.: D:
then
.setup.exe /product server
click “Change how to setup download updates” and select “Not right now”

Enable Multiple RDP Sessions

Enable Multiple RDP Sessions

1. Log into the server, where the Remote Desktop Services are installed.
2. Open the start screen (press the Windows key) and type gpedit.msc and open it.
3. Go to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Connections.
4. Set Restrict Remote Desktop Services user to a single Remote Desktop Services session to Disabled.
5. Double click Limit number of connections and set the RD Maximum Connections allowed to 999999.

MSSQL restore all databases from folder with .bak files

Powershell

Install-Module dbatools
Import-Module dbatools
Set-DbatoolsInsecureConnection -SessionOnly
Restore-DbaDatabase -SqlInstance SERVER-NAME\INSTANCE-NAME -Path 'C:\PATH-TO-BACKUPS'

MSSQL: User, group, or role ‘platnik’ already exists in the current database.

lists logins and incorrect SIDs
USE <platnik_db>
GO
EXEC sp_change_users_login 'Report'
GO

Then start SQL
USE <platnik_db>
GO
EXEC sp_change_users_login 'Auto_Fix','<user_name>',NULL, '<password>'
GO

Delete multiple databases in MSSQL

drop databases query

USE master;
Go
SELECT 'DROP DATABASE ['+ name + ']'
FROM sys.databases WHERE name like 'PREFIX%';
GO

Windows recovery

bootrec /scanos

bootrec /fixmbr

bootrec /fixboot

bootrec /rebuildbcd

Deletes files older than 30 days

forfiles /p "C:\sql.arch" /s /m *.* /D -30 /C "cmd /c del /Q /S @path"