31 Days of SSIS – Small Package, Big Win (26/31)

Welcome to day twenty-sixth post of the 31 Days of SSIS.   We’re getting near the end now.  If you have not read the other posts, they can be found through the introductory post. This series has been a combination of my thoughts on practices for working with SSIS and proof of concept packages that represent … Continue reading 31 Days of SSIS – Small Package, Big Win (26/31)

Presenting on #SSIS to EDMPASS Today

Will you be in Edmonton today?  How about near a computer connected to the inter-tubes?  If so, you might be interested in joining the EDMPASS January user group meeting.  Colin Stasiuk (Blog | @BenchmarkIT) invited me to join the meeting today. The details for the meeting are Start Time: Wednesday, Jan 26, 2011 6:00 PM … Continue reading Presenting on #SSIS to EDMPASS Today

31 Days of SSIS – DTSConfig Configuration (19/31)

The last two posts in the 31 Days of SSIS talked about the use of environmental variables and SQL Server configurations.  Between those two types of configurations, you can cover most situations where you need to configure an SSIS package. There is one more type of SSIS package configuration that I’d like to make sure … Continue reading 31 Days of SSIS – DTSConfig Configuration (19/31)

Can You Dig It? – Parallelism in the Plan Cache

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the lead in to this post, I talked about how the plan cache can be a gold mine of information.  There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache

Return of the Index Analysis Report

Finally up to the last post of this series resurgence.  Time to update the Index Analysis Custom Report that I developed last year. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find … Continue reading Return of the Index Analysis Report