Database & System Admin Cheat Sheets

As a Database and System Administrator, I find that having cheat sheets on hand can be incredibly useful. They provide quick and easy access to important syntax information, which can save time and help me solve problems more efficiently.

Here is a list of my cheat sheets that help me along the way as a Database and System Administrator:

MSSQL Diagnostic Cheat SheetThis sheet provides a list of common diagnostic commands and queries that I can use to troubleshoot issues with Microsoft SQL Server.

MSSQL Operational Cheat SheetThis sheet contains a list of common operational commands and queries that I can use to manage and maintain a Microsoft SQL Server instance.

MSSQL ETL Cheat SheetThis sheet includes a list of common ETL (extract, transform, and load) commands and queries that I can use to move data between different databases and systems.

PowerShell Cheat SheetAs a System Administrator, I often need to use PowerShell to automate tasks and manage systems. This sheet provides a list of common PowerShell commands and syntax that I can use to accomplish these tasks.

Postgres Cheat SheetThis sheet includes a list of common PostgreSQL commands and syntax that I can use to manage and optimize Postgres databases.

Redshift Cheat SheetThis sheet provides a list of common AWS Redshift commands and queries that I can use to manage and optimize Redshift data warehouses.

MySQL Cheat Sheet This sheet contains a list of common MySQL commands and syntax that I can use to create and manage tables, import and export data, and perform common data analysis tasks.

Git Cheat SheetThis page provides a Git cheat sheet with some common Git commands.

Markdown Cheat SheetThis sheet includes a list of common markdown syntax and formatting options. This can be useful when writing for the web, as markdown allows for easy conversion to HTML or other markup languages for rendering. Markdown is often used for formatting documentation and readme files in version control systems like Git.

Linux Cheat SheetThis sheet provides a list of common Linux commands and syntax that I can use to manage Linux systems.

AWS CLI Cheat SheetThis sheet contains a list of common AWS CLI (command line interface) commands and syntax that I can use to manage and automate tasks on Amazon Web Services.

As you can see, I do like a good cheat sheet! I hope you find these as useful as I do.