On Reaching the Summit – PASS Summit 2013 That Is

August 27, 2013
Tags: , ,

[Note: This is repost from May 22, 2013, due to technical issues on this blog.] Each year I participate in a variety of public events, including conferences, user groups, SQL Saturdays, and webinars of all kinds. (This year, indeed next week, I’m going to an event that is part of a cruise – SQLCruise!) Through […]


Let go of my ISPAC!

February 12, 2013

Sometimes it happens. SQL Server Data Tools crashes and burns. (It’s also known as Visual Studio or SSDT but I don’t know how to pronounce that…) Was it something I said? I’m currently building a small data warehouse and building out a lot of packages in a fairly short period of time, so maybe I […]


8 Enhancements in Integration Services 2012 for Easier Package Development

January 27, 2012

The upcoming release of SQL Server 2012 includes a major overhaul for Integration Services (SSIS). I write about the changes in SSIS, big and small, in Introducing Microsoft SQL Server 2012 (Microsoft Press, 2012) which will be available in March as a free download. Meanwhile, if you really can’t wait that long, you can get […]


24HOP: BI Workload Follow-Up

September 8, 2011
Tags: ,

Yesterday, Denny Cherry (blog|twitter) and I co-presented a 24HOP session for the Fall 2011 lineup, “So How Does the BI Workload Impact the Database Engine?” 24HOP stands for 24 Hours of PASS and is a semiannual roundup of speakers from the SQL Server community. Initially, this event consisted of 24 consecutive sessions, each lasting an […]


Building a Data Mart with Integration Services

September 13, 2010

Last week I presented a Webcast, sponsored by Idera, that received some favorable feedback, plus some requests for my sample files. To recap, my focus was on the process of building the data mart, rather than trying to explain (in 45 minutes!) all the things that you can do with Integration Services. In some cases, […]