While many enterprises continue to build systems and strategies to protect their relational databases, many organizations haven't done enough to secure the information in the most common database ...
I have to import flat files into MSSQL server. So far, I've used SSIS packages and Delphi programs to do the job but I'm getting more and more files to load. Many are very wide (more than 90 fields) ...
In this flat file database, the data on each member of staff is held together with all data for each department. This is unnecessary as some information is stored more than once (eg the same phone ...