C H A P T E R 2
BIDS and SSMS
At each increase of knowledge, as well as on the contrivance of every new tool, human labour becomes abridged.
—Inventor Charles Babbage
After gathering the requirements and specifications for the new processes, it is time to design the ETL flow. This includes deciding the tools to use, the time frames for data processing,the criteria for success and failure, and so forth. One of the integral parts of deciding which tools to use is determining the sources for the data and the capability of the tools to gain access to it with ease and to extract it efficiently. As we discussed in Chapter 1, efficiently describes the taxing of the network, hardware, and overall resources optimally. One of the best characteristics ...