I got interested in the title of this webinar and hence thought that all of you might be interested in this webinar event as well. Below are the details
Date / Time
(GMT-05:00) Eastern Time (US & Canada)
Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions ;using features that are all native to SQL Server 2008.
Speaker: Patrick LeBlanc
Patrick LeBlanc, SQL Server MVP and Author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events and a PASS Regional Mentor.
Mon Dec 20th 12pm EST SSIS + CDC = SCD
At the beginning of this month, I received an email from #microsoft telling me that I have received the Most Valuable Professional (MVP Awa...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
In this post I would like to share my experience of migrating our Reporting server from sql server We installed SQL SERVER 2017 on...
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...