Knowledge Base

Exchange

• Check if a user is moved to O365
• Clean-MailboxDatabase
• DKIM Office 365
• Find folder in mailbox

Linux

• Apache is using to much memory
• Cleanup boot folder on linux
• Find large files in Unix
• How To List and Delete Iptables Firewall Rules
• How To Set Up SSH Keys
• How to setup Linux disc alert
• Linux chmod for www sites
• Setting Up Pure-FTPd in Ubuntu
• UFW on linux
• Unban with fail2ban

Show all articles ( 6 ) Collapse Articles

MSSQL

• Backup

  • Backup SQL Server

• DateTime

  • Convert from datetime to varchar
  • Convert from Unix timestamp
  • Convert to Unix Timestamp
  • Get latest order on customer
  • SQL DateTime
  Show all articles ( 1 ) Collapse Articles

• Jobs

  • Job template on Always On Cluster

• Restore

  • Database in restoring mode
  • Insert huge SQL script
  • MSSQL Recover users after restore
  • MSSQL Recover users on all databases after restore

• Scripts

  • Backup all databases
  • Convert from datetime to varchar
  • Convert from Unix timestamp
  • Convert to Unix Timestamp
  • Create Table with Autoincrement
  • Database last accessed
  • DBCC Shrinkfile
  • Delete oldest duplicate in SQL
  • Get latest order on customer
  • How to hide SQL Server user databases in SQL Server Management Studio
  • Insert huge SQL script
  • List columns in a table
  • MSSQL Recover users after restore
  • MSSQL Select Distinct
  • Remove MUST_CHANGE_PASSWORD from user
  • Reseed
  • Silent truncation in MSSQL
  • SQL Server – How to get sizes of all databases on a server
  • UPDATE table FROM table2
  • With q as query
  Show all articles ( 16 ) Collapse Articles

• Triggers

  • Add Trigger
  • MSSQL Only trigger on certain changes
  • Trigger on multiple insert

MySQL

• MySQL Events
• Setup MySQL for VPS 2GB

Other tools

• Extract MSI package
• Port redirect on Linux using UFW
• PsShutdown
• Remote Task kill

PowerShell

• Add or Update a User Picture to the Active directory
• Check if a user is moved to O365
• Clean-MailboxDatabase
• List all jobs on all servers in AD
• Powershell fetch BitLocker key
• Send a csv file with users in AD

Show all articles ( 2 ) Collapse Articles

Windows

• Recover file from Offline files
• Startup folder in Windows 10