SQL DBA Blog

Blog Posts

• Introducing DBASco: SQL Server Database Admin Blog

  Greetings Tech People! If you’ve been following my technical journey on peter-whyte.com, I’m excited to share a new platform that dives into the world of Database Reliability Engineering and beyond – welcome to DBASco.com! At DBASco.com, I share my latest technical writings, focusing on a spectrum of topics catering to IT enthusiasts,…

  January 25, 2024

• How to Set Environment Variables in PowerShell

  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 variable is a value…

  December 19, 2022

• Temp Tables in SQL Server

  Temp tables in SQL Server can improve the efficiency and performance of complex queries by breaking them down into smaller pieces, storing intermediate results in memory, and eliminating unnecessary data. In SQL Server, temporary tables are tables that are created for a specific purpose and are only available for the duration of…

  December 15, 2022

• Git Log Author

  If you’re a Git user, you’re likely familiar with the git log command, which allows you to view the commit history for a repository. This blog post is an extra tip on the git log command, showing the –author option parameter which allows you to filter the commits displayed by the author’s…

  December 13, 2022

• Git Log Command

  Git log is an essential command for working with Git. It allows you to see the history of a repository, including details about each commit like the author, date, and commit message. Using the git log command is simple. Just navigate to your Git repository in a terminal or command prompt and…

  December 13, 2022

• How to Install PowerShell on Ubuntu 20.04

  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 Microsoft Documentation, Installing PowerShell…

  November 6, 2022

• Move Temp DB SQL Server

  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 DB Files depends on…

  October 20, 2022

• SSMS

  SSMS, SQL Server Management Studio, is the standard application that we use to run queries and administer instances of SQL Server. The Microsoft Documentation and links to download can be found here – Download SSMS My blog posts with the SQL Server Management Studio (SSMS) Tag may help guide you through common…

  October 17, 2022

• How to Check SQL Server Version

  Checking your SQL Server versions is a common task, as most database administrators will know how important it is to keep the software on the host up to date. This post is here to help you to check the version of SQL Server instances. You may have many instances running on the…

  October 6, 2022

• SSMS Silent Install

  This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use to administer SQL Server and to run SQL queries. If you need to install SSMS many times or on multiple computers, you may want to use the silent…

  September 14, 2022