5
votes
2answers
106 views

Deploying Database Schema changes in a patching process [duplicate]

I am facing a conceptual development methodology problem that I was hoping you could help me with. Firstly, a little bit of background. Background The project I am developing is a niche application ...
0
votes
1answer
107 views

How should I evaluate the Database Solution for Large Data Application

Background I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
-1
votes
2answers
623 views

SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
5
votes
4answers
475 views

How do you keep track of the meaning of your SQL fields?

The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data. I use SQL ...