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 –
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 –
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.
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.
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.
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.
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.
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.
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 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.