As a SQL Server DBA, I like to code in T-SQL mostly. Recently I had a requirement where I need to delete files on conditional basis. I could have done the same writing a simple batch script or vb script Continue Reading..
Category: OLE
OLE Automation is an inter-process communication mechanism created by Microsoft.
COPY OR MOVE FILES AND FOLDERS USING OLE AUTOMATION
I love playing around with automation stuff. In a recent automation task, I was to copy or move files and/or folders from one location to another in SQL Server without using SQLCMD. If you are novice to OLE automation in SQL server then Continue Reading..
File system operations in SQL Server using OLE Automation
I have been doing some cool automation stuff in SQL Server using OLE Automation objects. This is a series post on OLE automation, If you missed the first post then read it here to know what OLE Automation is and how to Continue Reading..
Binary data into filesystem using OLE automation in SQL Server
Recently I have been assigned to do some file system operation from SQL Server like saving a physical file into database in binary format and extract back the same file into file system when needed. This could have been done using cmd, powershell, vbs Continue Reading..