It's a long time, I'm fighting against using "SP_" for naming procedures like this.

In most cases we use an other (nearly same "PRO_SP", but this because company name starts with...

Hello together,

other than first repliers I 'like' Powershell in combination with T-SQL, as my works often is managing files, analysing folder structures and building up connections and meta information in...

Hello together,

not as a vendor, but with good experiences for users, who don't often need to Import Excel and other data sources, I recommend a product called flowheater. It's easy...

Hi,

you should also think about being able to have your databases customizable as you'll often get special requirements from your customers. Therefore it could be helpfull, if you have more...