-
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, database/system administrators, and…
-
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 that is stored…
-
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 the connection that…
-
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 name. This can…
-
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 run the git…
-
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 on Linux (Ubuntu)…
DBA Blog Posts
SQL Server DBA Blog posts, organised with information on Database Admin, SSMS, PowerShell and Windows Admin tips. This page will be updated frequently.
All blog posts linked below are internal links created by myself, a SQL DBA living the dream of being able to combine a love for database software and blogging.
My high-level blog categories include the following:
– MS SQL DBA
– SSMS Tips
– PowerShell Tips
– Windows Admin
– WSL
– Linux Tips
– Git Tips
– AWS Tips
MS SQL DBA
Move Temp DB SQL Server
October 20, 2022
How to Check SQL Server Version
October 6, 2022
Adding Columns to a Table in SQL Server
September 6, 2022
Add a Filegroup to a Database in SQL Server
September 1, 2022
Disable Change Data Capture (CDC) in SQL Server
August 30, 2022
How to Enable CDC in SQL Server
August 29, 2022
SQL Server Default Port
August 26, 2022
How to Rename a Computer that Hosts SQL Server
August 23, 2022
Get All Database Sizes in SQL Server
August 20, 2022
How to Backup a SQL Server Database
August 19, 2022
Get Estimated Backup Restore Time in SQL Server
August 18, 2022
Drop Table if Exists in SQL Server
July 26, 2022
Get Last Database Restore DateTimes in SQL Server
July 23, 2022
List All SQL Agent Jobs on a SQL Server Instance
July 21, 2022
How to Restore a Database in SQL Server
July 19, 2022
What’s New in the SQL Server 2022 Install
May 29, 2022
Why Use WHERE 1=2 in a SQL Query
May 5, 2022
Why Use WHERE 1=1 in a SQL Query
September 21, 2020
Check & Restart SQL Server Services On Linux
July 14, 2020
Installing SQL Server On Linux
April 27, 2020
SSMS Tips
SSMS Maximum Characters Displayed
September 12, 2022
SSMS Show Line Numbers
September 3, 2022
How to Connect to SQL Server with a Different Domain User Account
August 25, 2022
USE Command in SQL Server
November 25, 2020
Change Default Database in SQL Server
November 23, 2020
Disk Usage by Top Tables Report in SQL Server
October 4, 2020
Include Execution Trace Messages in SQL Server Error Logs
May 5, 2020
“Index was out of range” SQL Server Management Studio
April 15, 2019
The (SSMS) Import Flat File Feature
January 24, 2019
Using Custom Connection Colours in SSMS
October 22, 2018
Exporting SQL Server Query Results to CSV
October 2, 2018
How to Delete Files in PowerShell
September 11, 2022
Create a New Firewall Rule with PowerShell
September 5, 2022
How to Check PowerShell Version on Windows
August 31, 2022
How to Automate PowerShell Scripts with Task Scheduler
August 28, 2022
SQL Server Default Port: Add New Firewall Rule with PowerShell
August 26, 2022
PowerShell Restart Services on Multiple Hosts
August 24, 2022
PowerShell ForEach Loop Examples
August 22, 2022
How to Check Windows Firewall Status with PowerShell
August 16, 2022
How to Enable Windows Firewall with PowerShell
August 15, 2022
How to Disable Windows Firewall with PowerShell
August 14, 2022
Best Terminal for Windows 2022
August 13, 2022
PowerShell Create Folder If Not Exists
August 12, 2022
Get-EventLog in PowerShell
October 30, 2021,
Get-Command in PowerShell
October 29, 2021,
Windows Admin
How to Automate PowerShell Scripts with Task Scheduler
August 28, 2022
SQL Server Default Port: Add a New Firewall Rule in Windows
August 26, 2022
How to Find Which Process is Listening on a Port in Windows
August 21, 2022
How to Check Windows Firewall Status with PowerShell
August 16, 2022
How to Enable Windows Firewall with PowerShell
August 15, 2022
How to Disable Windows Firewall with PowerShell
August 14, 2022
Best Terminal for Windows 2022
August 13, 2022
WSL (Windows Subsystem for Linux)
How to Reboot WSL (Windows Subsystem for Linux)
August 12, 2022
How to Upgrade WSL from Version 1 to Version 2
August 2, 2022
How to Downgrade from WSL Version 2 to WSL Version 1
August 2, 2022
How to Open WSL Projects in Windows File Explorer
July 27, 2022
How to Change Default Linux Distro in WSL
July 25, 2022
How to Install Postgres on Ubuntu 20.04 in WSL
July 22, 2022
How to Check WSL Versions
July 20, 2022
How To Install Windows Subsystem for Linux (WSL)
July 18, 2022
How To Change From WSL2 to WSL1
May 8, 2022
How to Reboot a WSL Distribution/Instance
May 4, 2022
How to Check WSL Versions
May 3, 2022
How To Install Ubuntu 20.04 On WSL
April 6, 2021
How To Unregister A Linux Distro In WSL
April 5, 2021
How To Set A Default Linux Distro In WSL
April 4, 2021
Setup SSH Keys In WSL
September 8, 2020
Create A Link Between Local Windows Files And WSL
September 6, 2020
Access Local Files From Windows Subsystem For Linux (WSL)
September 5, 2020
Reinstall A WSL Disto
September 4, 2020
Linux Tips
How to Check Linux Version in Ubuntu
July 29, 2022
How to Install Postgres on Ubuntu 20.04
May 2, 2022
How To Install & Configure AWS CLI On Ubuntu
April 8, 2021
Check & Restart SQL Server Services On Linux
July 14, 2020
Installing Firewalld On Linux
April 27, 2020
Git Tips
Git Log Show in One Line (–oneline)
May 17, 2022
Change Git Remote URL To SSH From HTTPS
September 28, 2020
“Config Lock Failed Operation Not Permitted” – Git
September 7, 2020
AWS Tips
How to Manage S3 Buckets with AWS CLI
May 1, 2022
How To Install & Configure AWS CLI On Ubuntu
April 8, 2021