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..
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..
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..
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..