Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

SQL Heroes Contest Winners

They announced the SQL Heroes contest winners at the PASS Summit keynote today. I’m very happy to say that both BIDSHelper and ssisUnit were in the top 5! BIDSHelper had a perfect score of 55 (the only perfect score), based on the judging criteria (yes, Read More...
Posted Friday, November 21, 2008 6:08 PM by jwelch | 1 Comments

Batch Destination and the Merge Destination

After I created the Batch Destination for my presentation at the MS BI Conference, I was talking with Matt Masson, who let me know that they’d been working on a MERGE Destination sample component, and would hopefully be releasing it soon. It’s out now Read More...
Posted Friday, November 07, 2008 10:14 PM by jwelch | 1 Comments

SSIS Tasks and Components

Todd McDermid (a frequent poster on the MSDN SSIS forums , and creator of the Kimball SCD component ) and I have started a new project on CodePlex along with Todd McDermid, the SSIS Community Tasks and Components (ssisCTC) project. This project is intended Read More...
Posted Friday, November 07, 2008 9:24 PM by jwelch | 0 Comments
Filed under: , ,

SQL Heroes Contest

David Reed , who manages the SQL Server community samples on CodePlex , has been running a SQL Heroes contest. It’s for open source applications that help improve the SQL Server experience. You can read more about it on the SQL Heroes blog . I find myself Read More...
Posted Friday, October 31, 2008 3:51 PM by jwelch | 0 Comments
Filed under: ,

Preview of the SSWUG Virtual Conference

The SSWUG Business Intelligence Virtual Conference is just two weeks off now. They’ve made a 10 minute preview of my session on SSIS configurations available here: http://www.vconferenceonline.com/speaker.asp?id=Jwelch , if you are interested in getting Read More...
Posted Thursday, October 23, 2008 11:28 PM by jwelch | 0 Comments

A “Merge” Destination Component

At the Microsoft BI Conference, I did a chalk talk on creating custom components for SSIS. It seemed to go pretty well, as I got a lot of questions and interaction from the audience, which is the point of a chalk talk. As part of it, I demonstrated a Read More...
Posted Tuesday, October 21, 2008 5:37 PM by jwelch | 5 Comments

PASS Summit 2008

Last post on presentations for a while, I think / hope. I'll be presenting on Unit Testing in SSIS at the PASS Summit 2008 , occurring in Seattle, WA from Nov. 18-21. There's lots of great content planned at PASS this year, and it's definitely worth attending. Read More...
Posted Thursday, September 18, 2008 2:15 AM by jwelch | 0 Comments
Filed under: , ,

The Microsoft BI Conference

I'm doing a couple of chalk talks at the Microsoft BI Conference , occurring in Seattle, WA on October 6-8. The chalk talks are a different format than the typical presentation: smaller audience, no (or very few) slides, and more conversational in format. Read More...
Posted Thursday, September 18, 2008 1:58 AM by jwelch | 0 Comments
Filed under: ,

SQL Saturday in Greenville, SC

There's a SQL Saturday coming up in Greenville, SC on October 11th. It's a free, day long event with a number of great speakers doing sessions. I don't include myself in the great speaker category, but I was asked to present a couple of sessions on SSIS, Read More...
Posted Thursday, September 18, 2008 1:41 AM by jwelch | 0 Comments
Filed under: ,

The SSWUG BI Virtual Conference Is Moving...

but not very far, just to Nov. 5-7. In order to provide more value to attendees, the BI conference is being run at the same time as the SharePoint, SQL, and .NET conferences. So now, instead of just having access to the BI content, you'll be able to pick Read More...
Posted Thursday, September 18, 2008 1:33 AM by jwelch | 0 Comments
Filed under:

Presenting at the Triad SQL Server User Group

I'm presenting at the Triad SQL Server User Group tomorrow night on Migrating to Reporting Services 2008. It was a lively group last time I was there, and I'm looking forward to visiting them again. If you are in the area, please stop by. Here's the abstract Read More...
Posted Tuesday, September 16, 2008 3:21 AM by jwelch | 0 Comments

Error Redirection with the OLE DB Destination

A question that comes up occasionally is how to handle errors that occur on the OLE DB Destination in the data flow. Errors that occur when using the OLE DB Destination to insert into a table are usually caused by primary key, foreign key, or check constraints Read More...
Posted Friday, September 05, 2008 8:43 AM by jwelch | 2 Comments

ssisUnit 1.0 Is Available

The 1.0 bits for ssisUnit are now on CodePlex . The Release page for it includes versions for SQL Server 2005 and 2008. The biggest feature in this release is a GUI for creating the unit tests. The test files are still XML, but the GUI abstracts away Read More...
Posted Sunday, August 31, 2008 5:51 PM by jwelch | 0 Comments

Configuration Approaches In SSIS

A number of the SSIS MVPs were asked to contribute a white paper to MSDN a few months ago, and those articles were published recently. You'll notice a common thread in most of the topics: Considerations for High Volume ETL Using SQL Server Integration Read More...
Posted Sunday, August 31, 2008 1:46 AM by jwelch | 0 Comments
Filed under: ,

Testing the SQL Database at TechED

While at TechEd this summer, I participated in a panel discussion on testing the database and related technologies. The panel also included Gert Drapers and Jamie Laflen of the Visual Studio Team System - Database Edition team, David Reed (who manages Read More...
Posted Tuesday, August 19, 2008 4:18 AM by jwelch | 1 Comments
Filed under: ,
More Posts Next page »