You can set the Microsoft SQL Server memory limits via command-line using sqlcmd. This is useful if you do not have SSMS available.
Connect to the server using sqlcmd. If you are running locally with the default instance, this is as easy as running the following from the command prompt:
sqlcmd -S
Note that you will need to have sysadmin permissions to be able to make the changes.
Run the following commands to set the minimum and maximum memory limits:
EXEC sys.sp_configure 'show advanced options', 1;GORECONFIGURE;GOEXEC sys.sp_configure 'min server memory', 1024;GOEXEC sys.sp_configure 'max server memory', 4096;GORECONFIGURE;GO
In the example above, we set the minimum memory to 1 GB (1 ...
While there are a lot of ways and tools to write bootable ISOs to USB on a Mac, the most easiest is in fact by using the "linux" method, a perfectly valid option using internal command-line tools:
You'll need an USB device that's large enough. For netinst, 1 GB would be sufficient. Make sure that the contents are kept safe if needed, as the USB device will be wiped.
If you haven't done so already, you can download the proper ISO file for Debian from this page: https://www.debian.org/distrib/. Download only from a legitimate mirror.
Insert the USB device and open up Terminal. We need to verify the device identifier of the USB device as we will need this later. This will be in the ...
It can happen that the network profile on a domain controller switches to Private, usually after changing network settings or a network adapter. The network profile is then set to Private with no way to switch to Domain.
The first thing you can attempt is to restart the Network Location Awareness service. This service is responsible for setting the network profile depending on several parameters. It can sometimes get it wrong (usually because of startup order).
If restarting NLA helps, then there's an easy registry fix to permanently resolve it. This is the preferred method over manually configuring service dependencies in the registry, which is more complex and prone to errors. While the ...
To factory reset a Cisco Catalyst 9200 series switch (e.g. when you can no longer log in or have forgotten the password), you can factory reset the switch through physical access and a serial console connection.
First, connect the serial console cable and verify whether you have access to the serial console. Also, verify whether you have physical access to the switch and can unplug the power.
Unplug the power cable to power down the switch. While holding down the button at the left top corner (next to the "S" LED), plug in back in. Keep the button pressed for at least 10 seconds, until the "S" LED is solid green. The console output will also state the boot from "pa ...
To configure SSH access, and disable Telnet, follow these steps.
Enable the new AAA model and configure a user account and optional enable password:aaa new-modelusername cisco secret 0 ciscoenable secret 0 cisco
Generate SSH keys and set up time-out and other parameters:ip domain name some-domain.comcrypto key generate rsaip ssh version 2ip ssh time-out 60ip ssh authentication-retries 2
When generating SSH keys, you first need to specify a domain name. You will also be prompted to enter the modulus bit rate. Although 1024 is suggested, it is recommended to set it to 2048 as lower is deprecated.
Optionally, to disable Telent access, explicitly set the transport:line vty 0 4transport inp ...
You can use the CertReq command line tool to request SAN SSL certificates. This can be useful where you have an internal (web)server which also needs to be available using another (alternate) DNS name.
First create a template file you can use, specifying the required parameters. Save it with a name, e.g. request.inf and save it to a temporary (work) folder (or simply your desktop):
;----------------- request.inf -----------------[Version]Signature="$Windows NT$"[NewRequest]Subject = "CN=SERVER1.domain.com, OU=Some OU, O=Organization, L=City, S=State, C=US";Subject = "CN=SERVER1.domain.com"KeySpec = 1KeyLength = 2048; Can be 2048, 4096, 8192, or 16384.; Larger ...
There is a known issue with SentinelOne Agent 23.2.3.358 installed on a domain controller, which causes backups in Veeam for those machines to fail. The following error is displayed:
Error
Processing SERVER Error: VSSControl: -805306334 Backup job failed. Cannot create a shadow copy of the volumes containing writer's data. Cannot prepare the [NTDS] data to a subsequent restore operation. Cannot process NTDS data. Updating BCD failed. Cannot execute [SetIntegerElement] method of [\\SERVER\root\wmi:BcdObject.Id="{cd12ab87-1a23-12f3-ba7c-dc9876b01357}",StoreFilePath=""]. COM error: Code: 0xd0000022
This is caused by the boot protection feature of SentinelOne. One possible ...
By default, audit of success and failure is enabled on Network Policy Server. This will log authentication attempts in the Security event log (filter on event IDs 6272 and 6273). If for some reason, it is not enabled, you can manually enable it via command-line (or Powershell).To view the current audit policy settings, run:
Note that a group policy can override this behaviour. Settings in GPO are located here: Computer Configuration → Policies → Windows Settings → Secu ...