Hello and welcome to my tech blog, which is a place for me to store all my notes as I blog away as a software enthusiast.
My area of interest, or niche, very much revolves around Database Administration, so there will be a lot of RDMS related blog posts here, particularly on SQL Server. I spend a lot of time testing random features during my journey as a Database Administrator (DBA). This tech blog is a good place to store notes for personal reference. I do try my best to keep things accurate and informative for those landing on my pages via Google search too though.
If you want to know more about who’s writing this have a look at my about me page here.
I hope you find some of my posts useful and feel free to get in-touch. If anything I say is inaccurate or if you’d like to offer some general feedback please go ahead, I’d really appreciate it.
Cheers,
Pete
Certificates & Encryption CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Exporting Data Featured Git Importing Data Installing SQL Server Linked Servers Linux Admin Logging & Monitoring Measuring Databases Restoring Databases SQL Server Agent SQL Server ETL SQL Server Management Studio SQL Server Processes SQL Server Scripts Windows Admin WordPress Technical Issues WordPress Tutorials WSL
This is a post on how to set our default Linux distribution in Windows Subsystem for Linux (WSL). If you’re making the most of WSL and have more than one Linux distribution installed, this post might come in handy.
This is a post on how to show event logs in PowerShell using Get-EventLog. First up I’m showing a list of the types of event log available on my system.
This post is a quick guide on how you can open your current folder in PowerShell. Invoke-Item “performs the default action on the specified item”.
A handy post to note down the JDBC client driver download. I’m frequently in need of this myself. You can download the JDBC driver from the AWS Docs and then gain your cluster endpoint address from the main Redshift dashboard window Instead of doing the above, you navigate to the Configure tab in the Redshift console and download the JDBC driver &
This post is some quick notes on creating a new files and directories using PowerShell. There’s 3 wee highlights:# Create a New Directory# Create a New (.txt) File# Add Text to the New File Create a New Directory New-Item is the command.
