Stephen Wynkoop
Demo: Capture perfmon counters to binary logs and at the same time capture SQL Profiler. Then you can load both into profiler and see both at the same time. Great for troubleshooting what might be causing a problem or what is happening at a particular point in time.
Popularity: 2% [?]
TJ Belt
http://tjaybelt.blogspot.com
http://www.twitter.com/tjaybelt
You are on-call, maybe middle of the night and you get a call and there’s a problem. What do you do?
Popularity: 2% [?]
Below are tips, links and tidbits from today’s sessions. Use at your own risk. 
Popularity: 1% [?]
So the SSWUG Fall 2009 Virtual Conference begins today. I’ve setup at home to hibernate for hours watching the live and pre-recorded sessions on a wide range of SQL Server and business intelligence topics. An extra LCD monitor brought home, the trackball mouse from the office, headphones and webcam. The kitchen is stocked for my “conference” meals and snacks thanks to my lovely bride. I am ready!
Oh yeah, the sessions. I almost forgot.
Popularity: 1% [?]
Presenter: Matt Masson
http://blogs.msdn.com/mattm/
Starting up a new project with SQL Server Integration Services? Save time and money by learning about how to avoid common issues that users hit when implementing their ETL solutions. Drawing on the most frequently asked questions in the MSDN Integration Services forum and some of the more interesting packages we’ve seen over the years, well highlight common mistakes, clear up some misconceptions, and provide best practices to help you efficiently and effectively use Integration Services. Read the rest of this entry »
Popularity: 10% [?]
Presenter: John Welch
http://agilebi.com/cs/blogs/jwelch/Default.aspx
SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you’ll learn how to automate data transfers from a source to a target using SSIS. You’ll see the steps necessary to create both the control flow and the data flow portions of an SSIS package using the API and C# code. You’ll also learn about altering existing packages programmatically. Specific attention will be given to the generation of data flows with the proper source and destination components. We’ll take a look at some of the open source solutions available for this, plus some “roll your own” options. Read the rest of this entry »
Popularity: 16% [?]
Presenter: Matt Masson
http://blogs.msdn.com/mattm/
This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you’re interested in learning best practices for this new SQL Server 2008 functionality, you won’t want to miss this session! Read the rest of this entry »
Popularity: 14% [?]
Presenter: Brian Knight
bknight@pragmaticworks.com
Owner, Pragmatic Works
In this session, you’ll learn how to load a typical data warehouse in SSIS efficiently. You’ll start by seeing some of the strengths and weaknesses of the Slowly Changing Dimension (SCD) Wizard in SSIS and how you can get around some of the weaknesses including your own home-brewed solution. You’ll then see how to load a fact table using SSIS and how to make the common components scale. Read the rest of this entry »
Popularity: 19% [?]
