Blog Posts

• Time To Revive This Blog

  November 22, 2024

  As per title, I’m keen to revive this blog here at https://peter-whyte.com. I haven’t been publishing regularly for over a year, and it’s been many years since I changed the theme/design. So here we go, a new theme is in-place, updates are underway to improve the overall design,…

  Read More

  ---

• How to Set Environment Variables in PowerShell

  December 19, 2022

  To get environment variables in PowerShell, we can use Get-ChildItem env: to list all the environment variables and $env: to return the value of a specific environment variable. This blog post should help explain this as well as how to set new values for Environment Variables. An environment…

  Read More

  ---

• How to Kill SPIDs in SQL Server

  December 17, 2022

  In SQL Server, Session Process IDs (SPIDs) play a crucial role in identifying and managing SQL connections. The KILL (SPID) command serves as a tool for terminating troublesome sessions. This blog post provides an overview of the KILL command and its practical applications. The following is included in…

  Read More

  ---

• Git Log Author Command Example

  December 13, 2022

  If you’re a Git user, you’ll be familiar with the git log command, which allows you to view the commit history for a repository. This blog post is to share an extra tip while using the command, utilising the –author parameter which allows you to filter the commits…

  Read More

  ---

• Git Log Command Examples

  December 13, 2022

  Git log is an essential command when working with git version control. It allows you to see the history of a repository, including details about each commit like the author, date, and commit message. It lets you know what’s changed, when it changed and by who. Basic Git…

  Read More

  ---

• How to Install PowerShell on Ubuntu 20.04

  November 6, 2022

  This post is a guide on installing PowerShell on Ubuntu 20.04. The Ubuntu Linux distribution being used in this demo is running as a Windows Subsystem for Linux (WSL) instance. I have not yet encountered issues with the PowerShell, Ubuntu and WSL cocktail. Be sure to check out…

  Read More

  ---

• Move Temp DB SQL Server

  October 20, 2022

  A common best practice for SQL Server DBA’s is to have Temp DB files stored on a separate drive, especially ensuring that it’s not on the C:\ drive and sharing with the OS. This is because Temp DB can grow very large, very quickly. The growth of Temp…

  Read More

  ---

• How to Check Your SQL Server Version

  October 6, 2022

  Checking your SQL Server versions is a thing we need to do quite often as Database Administrators (DBAs). We know how important it is to keep our software up to date. This post is here to help you check the version of your running SQL Server instances, with…

  Read More

  ---

• How to Silently Install SSMS

  September 14, 2022

  This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use when working with SQL Server. If you need to install SSMS on multiple computers, you may want to use the silent installation feature for…

  Read More

  ---

• SSMS Maximum Characters Displayed

  September 12, 2022

  By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters. We can amend our query outputs in SSMS to Results to Text, rather than the default grid layout. This can be done by clicking…

  Read More

  ---