All Posts
Everything published on this blog since 2017, newest first. The Windows, PowerShell and WSL material is the active side of the site; the SQL Server writing has moved to sqldba.blog.
If you are looking for something specific, the two guides below collect the posts by topic rather than by date:
-
Git Log One Line
How to get a one-line git log, with the graph, aliases, dates and authors.
-
How To Install Windows Subsystem for Linux (WSL)
Want to run Linux directly on your Windows machine? Windows Subsystem for Linux (WSL) makes it easy! This guide provides a quick demo on how to get WSL enabled…
-
Why Use WHERE 1=2 in SQL
In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let’s discuss WHERE 1=2 — or any condition that results in a FALSE…
-
How to Install Postgres on Ubuntu 20.04
This post is a short note on how to install Postgres on Ubuntu 20.04.
-
How to Manage S3 Buckets with AWS CLI
This is a post on how to help manage S3 Buckets with AWS CLI, and to help explain some local Operating System (OS) considerations when running such commands.
-
Managing Old Files with PowerShell
Managing disk space is a common task for IT professionals, especially when dealing with folders that accumulate temporary or outdated files. Using simple…
-
Using Get-EventLog in PowerShell
The Get-EventLog cmdlet allows you to view event logs directly in your PowerShell terminal, similar to using Event Viewer. Below are some quick examples to get started:1. List Available Event Log Types2. Show Events by Count3. Filter Events by Message4. View Full Message of an Event 1. List Available Event Log Types 2. Show Events…
-
Get-Command in PowerShell
Get-Command is a cmdlet in PowerShell that lets you retrieve a list of all available commands in your current session. It’s a go to tool for discovering new…
-
Create Folder If Not Exists in PowerShell
Creating folders programmatically can streamline tasks and ensure that required directory structures are in place.
Three guides collect the posts by the job you are doing rather than by date.
PowerShellFiles, CSVs, the firewall, scheduled tasks WSLInstalling it, distros, files across both worlds Windows AdministrationServers, domains, DNS, the tools worth havingThis site started as a SQL Server blog in 2017 and the archive is still here. The new SQL Server writing, and all the scripts, moved to a site of their own.
sqldba.blogScripts, error library, wait types, SSMS- Linux & WSL (28)
- Microsoft SQL Server (51)
- Other (13)
- PowerShell (53)
- Windows Server Admin (38)