Skip to content

Instantly share code, notes, and snippets.

View alleey's full-sized avatar

Shoaib Ali alleey

  • Solo
  • Islamabad
View GitHub Profile
Visual Studio 2026 18.x
Professional: NVTDK-QB8J9-M28GR-92BPC-BTHXK
Enterprise: VYGRN-WPR22-HG4X3-692BF-QGT2V
Product Year Version Product Keys
Visual Studio 2022 2021 17.x
Professional: TD244-P4NB7-YQ6XK-Y8MMM-YWV2J
Enterprise: VHF9H-NXBBB-638P6-6JHCY-88JWH
Visual Studio 2019 2019 16.x
@alleey
alleey / Enable Request Logging.md
Last active October 2, 2024 03:45
SqlAnywhere

Enable Request Logging

Add the following parameters to the Parameters key

-zr SQL -zo D:\request_log.txt

@alleey
alleey / Backup and Restore.md
Last active October 2, 2024 03:39
SQLServer

Backup

BACKUP DATABASE [TheDatabase] TO  
DISK = N'\\dbserver\f$\MSSQL11.MSSQLSERVER\MSSQL\Backup\TheDatabase\fullbackup-03-feb-2021.bak' WITH FORMAT, 
INIT,  
NAME = N'TheDatabase-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
sudo yum install -y ksh
sudo yum install -y tree
sudo yum install -y wget
sudo yum install -y glibc.x86_64 glibc.i686
sudo yum install -y libgcc.x86_64 libgcc.i686
sudo yum install -y libstdc++.x86_64 libstdc++.i686
sudo yum install -y java-1.8.0-openjdk-devel
sudo yum install -y java-11-openjdk-devel
sudo yum install -y libnsl

Powershell script to remove clutter of developer unfriendly stock Libararies

$libids = @(
    '0DB7E03F-FC29-4DC6-9020-FF41B59E513A' # 3D Objects
    '1CF1260C-4DD0-4ebb-811F-33C572699FDE' # My Music
    '24ad3ad4-a569-4530-98e1-ab02f9417aa8' # Local Pictures
    '3ADD1653-EB32-4cb0-BBD7-DFA0ABB5ACCA' # My Pictures
    '3dfdf296-dbec-4fb4-81d1-6a3438bcf4de' # Local Music
    'A0953C92-50DC-43bf-BE83-3742FED03C9C' # My Video
 'f86fa3ab-70d2-4fc7-9c99-fcbf05467f3a' # Local Videos

How to create a self-signed code signing certificate

New-SelfSignedCertificate -DNSName "domain.com" -CertStoreLocation Cert:\CurrentUser\My -Type CodeSigningCert -Subject "Code Signing Certificate”

Convert from CND to CryptoApi format

List Active Directory Users

get-aduser -filter {UserPrincipalName -notlike '*ng1.local'}
get-aduser -filter {UserPrincipalName -like '*'}

List only the usernames