Home
- Details
- Written by: po3dno
- Category: MSSQL
- Hits: 576
Introduction
DBA uses services accounts to run the various SQL Services. Usually, we should use a separate service account for an individual server SQL Services.
- You should run SQL services having the least permissions
- You should use a complex password and store it in a secure place
- Its password should never expire
- You should also change the password regularly, depending upon your organization’s security policy
If you maintain a large inventory of SQL Servers, you might think it is a cumbersome task to change and maintain the passwords for these servers. Once you change the service account password using SQL Server Configuration Manager, it also requires the restart of SQL Services. It might be a challenging task as well to get downtime for highly transactional applications.
We can leverage Group Managed Service Accounts (gMSA) in these cases. Let’s explore it in the subsequent section.
- Details
- Written by: po3dno
- Category: Windows
- Hits: 496
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Control\FileSystem" -PropertyType DWord -Name RefsEnableLargeWorkingSetTrim -Value 1
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Control\FileSystem" -PropertyType DWord -Name RefsNumberOfChunksToTrim -Value 32
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Control\FileSystem" -PropertyType DWord -Name RefsEnableInlineTrim -Value 1
fsutil behavior set disableDeleteNotify refs 1
- Details
- Written by: po3dno
- Category: Windows
- Hits: 507
If Windows 11 setup is stuck due to lack of network connection:
- Press Shift + F10 to launch Command Prompt.
- Type in
OOBE\BYPASSNROand press Enter. - Your VM should reboot and at the setup screen you should see an option for “I don’t have internet.”
- Once Windows setup is completed, make sure to install the SPICE guest tools for network drivers.
- Details
- Written by: po3dno
- Category: Windows
- Hits: 517
If you get this message trying to install Windows 11, you can bypass it with the following steps:
- Press Shift+F10 to open Command Prompt and type in
regedit.exeto launch Registry Editor. - Navigate to HKEY_LOCAL_MACHINE\SYSTEM\Setup
- Right click on the Setup key on the left size and choose New -> Key.
- Create a key (Раздел) named
LabConfig - Select the LabConfig key.
- Create two new values: Choose New -> DWORD (32-bit) and create
BypassTPMCheckandBypassSecureBootCheck. Set both values to 1. - Close out of Registry Editor and Command Prompt.
- In setup, press the back button and then Next to continue installation.
- Details
- Written by: po3dno
- Category: Windows
- Hits: 546
A pending reboot is defined in many places. Scroll right to see the values and conditions. A Windows computer is pending a reboot if any of the conditions in this table are true.
| Key | Value | Condition |
| HKLM:\SOFTWARE\Microsoft\Updates | UpdateExeVolatile | Value is anything other than 0 |
| HKLM:\SYSTEM\CurrentControlSet\Control\Session Manager | PendingFileRenameOperations | value exists |
| HKLM:\SYSTEM\CurrentControlSet\Control\Session Manager | PendingFileRenameOperations2 | value exists |
| HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\RebootRequired | NA | key exists |
| HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Services\Pending | NA | Any GUID subkeys exist |
| HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\PostRebootReporting | NA | key exists |
| HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\RunOnce | DVDRebootSignal | value exists |
| HKLM:\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\RebootPending | NA | key exists |
| HKLM:\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\RebootInProgress | NA | key exists |
| HKLM:\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\PackagesPending | NA | key exists |
| HKLM:\SOFTWARE\Microsoft\ServerManager\CurrentRebootAttempts | NA | key exists |
| HKLM:\SYSTEM\CurrentControlSet\Services\Netlogon | JoinDomain | value exists |
| HKLM:\SYSTEM\CurrentControlSet\Services\Netlogon | AvoidSpnSet | value exists |
| HKLM:\SYSTEM\CurrentControlSet\Control\ComputerName\ActiveComputerName | ComputerName | Value ComputerName in HKLM:\SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName is different |