Oracle DB Version
You can check the version of the export utility by looking at a DMB file from Oracle 1234567/> strings BACKUP_101220.DMP | head -n 5 "SYS"."SYS_EXPORT_FULL_01" x86_64/Linux 2.4.xx USWMC WE8MSWIN1252 11.02.00.00.00
Powershell Network Connectivity Test
1PS C:\> New-Object System.Net.Sockets.TcpClient("192.168.0.2", 80) 1PS C:\> Test-Netconnection 192.168.30.13 -Port 80
Query Cloudflare API
Cloudflare Analytics are available for 1 Year through the API Get the zones listing 1curl -X GET "https://api.cloudflare.com/client/v4/zones" -H "Authorization: Bearer secret" -H "Content-Type:application/json" Get stats on a zone 1curl …
Import Azure DB into local MSSQL Server
Importing Azure database into a local MSSQL instance gives the error. 12Could not import package. Warning SQL72012: The object [xxx_Data] exists in the target, but it will not be dropped …
AWS Windows Activation Failure
Windows license appears invalid after restoring AMI https://aws.amazon.com/premiumsupport/knowledge-center/windows-activation-fails/ 1234PS C:>Import-Module "C:\ProgramData\Amazon\EC2-Windows\Launch\Module\Ec2Launch.psd1" PS C:>Add-Routes PS C:>Set-ActivationSettings PS C:>slmgr /ato
MS SQL Database Recovery Pending
Microsoft SQL Server Database status Recovery pending 1234567891011ALTER DATABASE [DBName] SET EMERGENCY; GO ALTER DATABASE [DBName] set single_user GO DBCC CHECKDB ([DBName], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS; GO ALTER DATABASE [DBName] set …
MSSQL Transaction Log Full
Check Log Space in MSSQL Server 1DBCC SQLPERF(‘logspace’) If the error occurs: The transaction log for database ‘AIMS’ is full due to ‘ACTIVE_TRANSACTION’ Alter the logging levels of the database …
Powershell Command Fetch File From S3
12345678910111213141516171819202122Param( # AWS IAM Credentials [string]$access_key = "secret", [string]$secret_key = "secret", [string]$aws_region = "us-east-1", [string]$bucket_name = "www.itsmetor.com", # …
MSSQL Server Permission Issue on Restore
Receive the error: Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. (Microsoft …
Filter Events By User
12345<QueryList> <Query Id="0" Path="Security"> <Select Path="Security">* [EventData[Data[@Name=’subjectUsername’]=’Tor’]]</Select> </Query> </QueryList>