Friday, December 17, 2010

SSIS + CDC = SCD -- A PASS webinar on 20th December by Patrick LeBlanc

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

Date:
12/20/2010

Start Time:
12:00:00 PM

End Time:
1:00:00 PM

Timezone:
(GMT-05:00) Eastern Time (US & Canada)

Short Description

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.

Event Description

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

URLhttps://www.livemeeting.com/cc/usergroups/join?id=53BGCZ&role=attend&pw=3%3C%2C9%27CDcs

Thursday, December 16, 2010

SQL Azure free trial

Here is a link to the special free trial offer for SQL Azure

For a limited time, new customers can sign up for SQL Azure and get a 1GB Web Edition Database for no charge…and no commitment. We ask for your credit card information when you accept this offer, as any additional usage per month will be billed at the standard rate. This is a great way to try SQL Azure – and the Windows Azure platform – without the risk.

Friday, December 10, 2010

Denali Resource Centre

This morning I found the following link on the MSDN blogs that is quite useful. There are plenty of articles and links to community blog posts, as well as 12 videos about the new functionality in SSIS.

Head over to the SQL Server Denali Resource Center.

Enjoy Denali using this resource centre

Rerunning a SSRS subscription report

Yesterday I had a situation where  a couple of SSRS reports failed due to a network upgrade. The SSRS report was not able to access the SQ...