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
4,474 reads
Stewart Campbell
2017-07-06
1,288 reads
2015-10-29
1,982 reads
2015-04-16
1,654 reads
2015-04-14
1,758 reads
2014-09-03
1,922 reads
2014-08-28
2,153 reads
2014-01-27
1,466 reads
2012-11-20
2,103 reads
2012-01-27
2,231 reads
Blogs
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
MVP for Another Year 2020-2021
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Forums
Unusual use of the WHERE clause
I am working an exercise problem where the solution provided has a WHERE clause...
How to get the SSAS Server administrators in MDX query?
Hello, Is there any way to get the list of server administrators from SSAS...
Upgrading from SQL Server 2012 to SQL Server 2017 - Any Tips or Gotchas
We are running SQL Server 2012 SP4 Standard Edition on Windows Server 2012 R2...
Ask SSC