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).
DBA Blog – Homepage
Index – Cheat Sheets – Notes
Categories
Database Software
SQL Server, MySQL, Postgres
Operating Systems & Native Code
Windows, PowerShell, Linux
Other
WordPress
Tags
Certificates & Encryption CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Exporting Data Featured Importing Data Installing SQL Server Linked Servers Linux Admin Logging & Monitoring Measuring Databases Restoring Databases SQL Server Agent SQL Server Management Studio SQL Server Processes Windows Admin WordPress Technical Issues WordPress Tutorials
Recent Posts
“..ps1 cannot be loaded because running scripts is disabled on this system” – PowerShell
When attempting to run a PowerShell script you may receive the following error: ps1 cannot be loaded because running scripts is disabled on thissystem.
Creating a Linked Server with a MySQL Database
This is my 3rd Linked Server 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
Restarting services is a simple one, although it could be an unfamiliar environment for pre-SQL Server 2017 (only) administrators; which was the edition that allowed SQL Server to run on Linux.
“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.
