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>

Rolemaster Fate Points

Fate Points Variant Rules for Rolemaster Standard System Copyright Nicholas HM Caldwell 1998 Destiny and the Player Characters “Some are born great, some achieve greatness, some have greatness thrust upon …

MSSQL Blocked Queries

12345SELECT * FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle) where session_id IN (     SELECT blocking_session_id FROM sys.dm_exec_requests WHERE DB_NAME(database_id)=’AIMS’ and blocking_session_id <> 0 )