Importing Tricky CSV Files with PowerShell
A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell
2018-07-03
8,971 reads
A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell
2018-07-03
8,971 reads
Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. In this article, Nicolas Prigent describes PoshUD, and how to use it to monitor your infrastructure using PowerShell.
2018-05-30
4,458 reads
In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module.
2018-05-28
3,337 reads
Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM.
2018-05-11
3,550 reads
In the third installment of this series, Steve Jones uses PowerShell to source control code.
2018-05-03
4,994 reads
In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.
2018-02-15
390 reads
2018-01-30
760 reads
2018-01-23
740 reads
2018-01-16
802 reads
How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet
2018-01-24 (first published: 2018-01-11)
31,310 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers