IS there any good books out there, that have detailed examples, on implementing SCD 1 and 2 in SSIS ? i have found a few books, that claim to be a soup to nuts solution for SSIS and ETL. but most of their instruciton is on Truncate and Load facts and dimensions, which is very good, if that's what you're company wants. But we are implementing SCD and it's tough to get my head around some of the concepts. Looking for a good book, article, or even attending a training class to work thru some of these examples.
I've taken Pragmatic Works free webinars before with some success. Here's one on SSIS Design Patterns for Loading a Data Warehouse (http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/PastWebinars.aspx?ResourceId=580),
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …