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
3,972 reads
Stewart Campbell
2017-07-06
1,284 reads
2015-10-29
1,980 reads
2015-04-16
1,649 reads
2015-04-14
1,756 reads
2014-09-03
1,922 reads
2014-08-28
2,149 reads
2014-01-27
1,466 reads
2012-11-20
2,103 reads
2012-01-27
2,228 reads
Blogs
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Forums
Common schema in different Databases
Hi, I need to include a very simple schema in all of my database...
Permissions to Run CLR Assembly
This is my first time dealing with CLR assemblies and we have setup some...
Convert date value
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC