Delphi

Thoughts about Delphi

File management from inside SQL code

Writing a log, dumping data, looking for file to be used in Bulk insert…

There are many situations when you would want to have access to files from inside your SQL code on Microsoft SQL Server.

Did you know that you actually can do this? No? Check below for code snippets to perform various operations on files. It is presented in form of the functions but you are actually not limited to that

Prerequisites and assumptions

  1. Your script should have sufficient rights to perform required access to files (not necessarily local).
  2. Scripting.FileSystemObject should be present at your SQL Server location and accessible.

Check if file exists
(more…)

By Serguei Dosyukov, ago

Are Developers Hurting SOA?

In his SD Times’ article Why Some Developers Are Hurting SOA David S. Linthicum is discussing some of aspects of mutual relationship between Developers and Software Architecture. …hard truth is that most developers don’t think about architecture, but focus more on the latest tools, languages and platforms. They are more concerned Read more

By Serguei Dosyukov, ago