SQLBits IV Conference

by Allan Mitchell 9 Feb 2009 16:10
I am very proud to announce that I will be presenting at this free conference in Manchester on 28.03.2009.  My session will be on mixing SSIS and Data Mining.  It is a free conference organized by people giving up their own time and is aimed at the community.  Everybody I know who has ever been always says that they enjoyed it.   For more details go to www.SQLBits.com

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. http://www.techfest2009.com/default.aspx

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 http://www.sqlbits.com/information/PublicSessions.aspx 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 Please.zip (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: http://sqlserverfaq.com/default.aspx?item=event&itemid=139   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]

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]

Extending SSIS with custom Data Flow components (Presentation)

by Darren Green 6 Mar 2008 14:00
Download the slides and sample code from my Extending SSIS with custom Data Flow components presentation, first presented at the SQLBits II (The SQL) Community Conference. Abstract Get some real-world insights into developing data flow components for SSIS. This starts with an introduction to the data flow pipeline engine, and explains the real differences between adapters and the three sub-types of transformation. Understanding how the different types of component behave and manage data is key to writing components of your own, and probably should but be required knowledge for anyone bu... [More]

Preview of SSIS in SQL Server 2008 (Presentation)

by Allan Mitchell 15 Oct 2007 14:00
Download the slides and samples from the Preview of SSIS in SQL Server 2008 presentation, first presented at the SQLBits 2007 Community Conference. In this session we looked at some of the new and improved features of SSIS coming in SQL Server 2008. Highlights include: Looking at the new pipeline limiter The new threading engine The arrival of C# as a scripting language option Change Data Capture(CDC) Presentation & Samples (360KB) Preview of SSIS in SQL Server 2008.zip

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]

Extending SSIS with Custom Tasks (Presentation)

by Darren Green 13 Oct 2007 14:00
Download the slides and sample code from the Extending SSIS with Custom Tasks presentation, first presented at the SQLBits 2007 Community Conference. The sample demonstrates a custom task with a connection property, including a property grid drop-down (UITypeEditor) to list all your connections and also add new connections, and a password property flagged as sensitive to honour the package protection level. It also illustrates how to create a user interface for your task. Abstract This session is all about developing for SSIS, writing .Net code to create your own tasks. We cover b... [More]

SQL Server Integration Services - Thinking Outside of the DTS Box (Presentation)

by Darren Green 19 May 2005 14:00
Download the slides and sample code from our SQL Server Integration Services - Thinking Outside of the DTS Box session at the 2005 PASS European Conference. Presentation & Samples (521KB) SQL Server Integration Services - Thinking Outside of the DTS Box