SQL Server - How to compress and decompress files and directories using 7-zip and xp_cmdshell or SQLCLR (C#) June 10, 2018 9 min read Continue reading
SQL Server - File Operations Using xp_cmdshell: How to List, Read, Write, Copy, Delete and Move Files August 29, 2017 6 min read Continue reading
SQL Server - How to export and import tabular data files (for example, CSV) using CLR (C#) March 20, 2017 8 min read Continue reading
SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C#) November 6, 2016 18 min read Continue reading
SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#) September 11, 2016 6 min read Continue reading
SQL Server - How to export the source code of all Stored Procedures, Functions, Views and Triggers from a database to .sql files August 25, 2016 6 min read Continue reading
SQL Server - How to read, import and export data from XML files June 18, 2016 27 min read Continue reading
SQL Server - Importing and Exporting Data from Excel Spreadsheets June 15, 2016 5 min read Continue reading
SQL Server - How to export database data to a text file (CLR, OLE, BCP) June 3, 2016 16 min read Continue reading
SQL Server - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET) May 29, 2016 7 min read Continue reading
SQL Server - How to list, read, write, copy, delete and move files with CLR (C#) May 7, 2016 11 min read Continue reading