Reinstalling a WSL Disto
This post is a guide on how to reinstall WSL (Windows Subsystem for Linux) via command. This may be useful if you are looking to clear down and start a up fresh WSL instance, treating it as a throw-away environment.
Enable Windows Subsystem for Linux (with Ubuntu 18.04)
WSL allows Windows users to develop and run applications within a GNU/Linux environment. Previous to this feature release we needed VM’s or a dual boot setup.
Remove Quotes from a CSV File with PowerShell
This is a post on how to remove quotes from a CSV file using PowerShell. If your dealing with a large CSV file, running the Import-CSV cmdlet below will consume a lot of system resources (RAM mostly).
“.ps1 cannot be loaded because running scripts is disabled on this system” PowerShell Error
When attempting to run a PowerShell script you may receive the following error: cdk.ps1 cannot be loaded because running scripts is disabled on this system.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server demo post, and this time it’s to a MySQL database. Noteworthy weblinks: # My Linked Server Blog Posts.# Microsoft Docs – Linked Servers.
Check & Restart SQL Server Services on Linux
As of the 2017 Edition of SQL Server we have been able to install SQL Server on Linux. Linux will likely be more of an unfamiliar environment for traditional Microsoft SQL DBAs.
“Changing the Primary Domain DNS Name of this Computer Failed” – Server 2008 R2
Within an AWS account I have a Windows Server 2016 Domain Controller, and I’m trying to join a Windows Server 2008 R2 to my Whyte.net Domain.
Testing Connectivity to Remote Server Ports with PowerShell
All admins need a tool to test connectivity to remote servers on TCP ports. In Windows, this is commonly done using PuTTy or PowerShell.
Forcing Encryption in SQL Server
If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in transit.
Include Execution Trace Messages in SQL Server Error Logs
Logs are always important if you’re supporting systems. The SQL Server Agent has always been a heavily used tool in my experience, so writing execution trace messages to the logs might help investigate an issue one day.
Backing up a SQL Server Database with Encryption
To backup a database in SQL Server with Encryption, run the BACKUP DATABASE command with the ENCRYPTION option added to the SQL statement, and specify the valid encryption certificate name.
Backing up a SQL Server Certificate
It’s important to backup SQL Server Certificates, but only if you’re using them really. If for example, your SQL Server database backups are encrypted and you need to restore it on another server, then you will need both the certificate and private key that was used.
