Techfest 2009 Conference Poland

by Allan Mitchell 8 Feb 2009 16:18
I am going to be speaking at this excellent 3 day conference being held in Southern Poland on 3-5 April 2009.  I will be speaking on SSIS.

C2C Conference In Poland

by Allan Mitchell 8 Feb 2009 16:10
I am proud to say that I have been chosen to speak at the Communities to Communities Conference in Poland.  The conference is free to attend and is being held in Warsaw, Poland.  I will be delivering a session on SSIS and performance.  Hope to see you all there.

PASS European Conference

by Allan Mitchell 8 Feb 2009 15:59
Well it’s that time of year again and I am happy to say I have been chosen to deliver a couple of sessions at this year’s conference.  The PASS European Conference, on April 22nd-24th in Neuss in Germany is a great conference and I had fun last year. I will be doing a pre-conference seminar with my good friend Chris Webb.  It is a beefed up version of a presentation he gave at PASS in the United States last year.   Me, being the SSIS expert, I will be covering that side of things and rewriting Chris’s packages so they're rather more robust; allowing Chris to concentrate on... [More]

SQLBits IV session voting open

by Allan Mitchell 27 Jan 2009 11:36
We've now closed session submission for SQLBits IV, which will be taking place on March 28th in Manchester. Once again we've had a great response and it's now time to vote for which of the 83 submitted sessions you'd like to see; to do this you need to register on the site and then go to and choose the sessions you'd like to see. Darren and I have both submitted sessions.

Data Mining Time Series presentation

by Allan Mitchell 22 Jan 2009 13:15
Here are the slides/Spreadsheets and queries I ran in my UK User Group presentation.  I talked about how the algorithms in SQL Server 2008 (ARTxp and ARIMA) work and what the effects of changing some of the attributes are on predictions. It was a great night and I got some good feedback. Hope you enjoy Time Gentlemen (178.59 kb)

UK BI User group Meeting Next Week

by Allan Mitchell 6 Jan 2009 20:55
OK, this is rather short notice I know but the UK SQL Server User Group is hosting a BI evening event next week, on January 15th at Microsoft's HQ in Reading:   Anyway if you follow the link you'll see that I'm one of the speakers: I’ll be doing a session on Data Mining and the Time Series Algorithm.Chris Webb will be repeating the session he did at PASS last year on building a monitoring solution for Integration Services, Analysis Services and Reporting Services. Hope to see y... [More]

SQLBits IV Session Submission now open.

by Allan Mitchell 27 Dec 2008 13:40
  The next installment of the increasingly popular community conference (FREE) is going to take place in Manchester on 28.03.2009 (Saturday).  This is an excellent place for you to get some experience in speaking and telling a couple of hundred people something about SQL Server which really rocks your world and you want to let people know or to learn something new yourself. We will be there as we have been for all the SQLBits events.  We really enjoy the day and love to meet the people who visit our blog so… Submit a session here We also would love to hear from anyone that ... [More]

SQLBits 3 – The Movies

by Allan Mitchell 12 Nov 2008 13:32
Back in September we ad our community conference SQLBits and MS were there filming.  In addition to my presentation there are a load of other good ones.  The whole of the BI track was filmed.  I know this is off topic slightly but it well worth taking a look. So head over there and see what there is.

Tips and Tricks in SSIS Presentation

by Allan Mitchell 1 Nov 2008 12:05
Here is a Live Meeting presentation I did for the Polish SQL Server User Group on Tips and Tricks I use when out and about using SSIS (It is in English).  It lasts about an hour and you can either watch it online or download the wmv to view later   Tips and Tricks in SSIS

More Value From Data Using Data Mining Presentation

by Allan Mitchell 1 Nov 2008 11:37
Here is a presentation I gave at the SQLBits conference in September which was recorded by Microsoft.  Usually I speak about SSIS but on this particular event I thought people would like to hear something different from me. Microsoft are making a big play for making Data Mining more accessible to everyone and not just boffins.  In this presentation I give an overview of data mining and then do some demonstrations using the excellent Excel Add-Ins available from Microsoft SQL Server 2008 SQL Server 2005 I hope you enjoy this presentation http://go.microso... [More]

SSAS Cache Warming Using SSIS

by Allan Mitchell 31 Oct 2008 08:22
Having your users walk into a cold cache on a morning is something that will cause them to have slower running queries initially.  Cache warming takes care of a lot of that by executing typical queries against the newly processed cube and thereby building the cache ready for your users when they get in.  There are a number of ways to warm the cache available. Chris Webb has already blogged about how he has done it and we thought we would show you a variation on that theme. UPDATE: The Trace File Source Adapteris now available. The package is relatively simple.     ... [More]

Building a Successful ETL Project

by Allan Mitchell 28 Oct 2008 09:00
When we are building ETL projects we need to do some planning up front to make sure we have all the things we need to make it a success. Here are some of the things we consider when embarking on an ETL Project. There are two lists. The first is around an ETL Project in general and the second is around things we think about specifically for SSIS. Review target data model Identify source systems (Owners, RDBMS types, Permissions) Analyze and profile source systems (usge patterns, Windows of opportunity) Document source data defects and anomalies (known issues, data profiling) ... [More]

Logical OR in Control Flow to Skip Task

by Allan Mitchell 28 Oct 2008 08:52
Here is an example of how to do something that in DTS we would have had to do some coding in Script.  In our packages we often find the need to follow one path or another in the Control flow based on some condition that exists at runtime.  In the example below we use a variable value to decide what path to take.   Here is the control flow along with the variables pane. The icons on the workflow indicate we have expressions thereon. The expression on the workflow constraint between tasks 1 and 2 is shown here. As you can see we want the workflow to be followed if our variabl... [More]

SSIS Performance Training Seminar

by Allan Mitchell 14 Oct 2008 17:19
We have just finished a 1 day course on how to get the most performance from your SSIS architecture.  This is an intense day and is given as a seminar.  This course is taken from real life learning and is a must for anyone interested in really understanding what goes on in their SSIS implementations This course is currently being delivered on demand on client sites.  Public deliveries are being prepared. If you think we could come and help you by delivering this seminar then let us know. Here is the course outline   Synopsis This one day course is designed for tho... [More]

Immediacy Demands a Change of Focus

by Allan Mitchell 25 Sep 2008 12:08
In this paper from Attunity they look at why we may have to look at how our data capture needs differ with everything now seemingly needing to be realtime. Immediacy Demands a Change of Focus - Final.pdf (112.96 kb)

Real Time Data Integration

by Allan Mitchell 25 Sep 2008 12:05
Here is a paper written by our friends over at Attunity about the need for Change Data Capture and SSIS. More...

More value from your data through data mining (Presentation)

by Allan Mitchell 25 Sep 2008 11:35
In this Live Meeting presentation Allan looks at data mining. The presentation is split evenly between demos and talking. Allan will give a brief overview of what data mining is along with some of the terminology as well as looking at what is available to you using SQL Server 2005. For the demos he uses Excel 2007 and the Data Mining add-in to demonstrate how even the least statistically minded of us can get started with this technology Presentation

SSIS Tips, Tricks and things I do (Presentation)

by Allan Mitchell 25 Sep 2008 11:24
In this live meeting presentation to the Polish SQL Server user group I go through a number of things I find help me when designing/building SSIS solutions from performance tips to 3rd party tools Presentation

Making more of SSIS in 2008 (Presentation)

by Allan Mitchell 13 Mar 2008 01:42
Download the slide deck from my Making more of SSIS in 2008 presentation, first presented at the SQLBits II (The SQL) Community Conference. Abstract Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is advanced (level 400) session so yo... [More]

Advanced Topics in SQL Server 2005 SSIS (Presentation)

by Allan Mitchell 15 Oct 2007 14:00
Download the slides and sample code from the Advanced Topics Using Microsoft SQL Server 2005 Integration Services presentation, first presented at the SQLBits 2007 Community Conference. In this session we looked at some of the not so often thought about areas of the SSIS toolbox. Perhaps they aren't considered true ETL by some people or are simply not seen but we think they are really useful weapons in our ETL armoury. Highlights include: Loading partitions directly Consuming a package in SSRS Using a DM algorithm in the pipeline to see... [More]


Comment RSS