Follow me on Twitter

by Allan Mitchell 28 Jun 2010 18:18
I will be tweeting on all subjects that interest me and come to mind.  Expect to see tweets about StreamInsight, SSIS, Data Mining and Spatial.  Follow me at @allanSQLIS

Tags

Categories

Sorting data in the SSIS Pipeline (Video)

by Allan Mitchell 29 May 2010 20:27
In this post I want to show a couple of ways to order the data that comes into the pipeline.  a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs.  One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.

StreamInsight Licensing

by Allan Mitchell 28 May 2010 06:22
I cannot help but think that this is currently wrong.  There are two editions of StreamInsight (SI), Premium and Standard.  A link to their differences is here Points to note Developer Edition and Evaluation Edition represent Enterprise Edition in SQL Server but not SI where they represent Datacentre Edition.  Won’t this be confusing when people evaluating SI find that it is not the same animal when they move to Enterprise Edition? If SI Premium is the only thing you want out of the SQL Server box then it is going to be a high cost. The latency rates as well quot... [More]

Explaining the State Transitions Viewer in Sequence Clustering

by Allan Mitchell 27 May 2010 19:29
Her is an article I wrote for MSDN that helps explains the excellent viewer we get for Sequence Clustering models in SQL Server Data Mining.  I show you how the numbers you see are derived and also give an explanation as to what the icons you see in the viewer mean. Link to the article

MSDN Article for the GetClusterCharacteristics Stored Procedure

by Allan Mitchell 27 May 2010 19:26
Here is an article I wrote for MSDN that introduces us to the GetClusterCharacteristics stored procedure in SQL Server Data Mining.  It gives us an insight into how the sequences within clusters are derived when using the Sequence Clustering algorithm. Link to article

Optimising Lookups with the Cache Transform (Video)

by Allan Mitchell 14 May 2010 15:40
How to optimise doing the same lookup multiple times. [More]

The Pipeline Limiter in SQL Server Integration Services (Video)

by Allan Mitchell 14 May 2010 11:51
Not many people understand that the Integration Services pipeline can be intentionally throttled back under the covers to stop you from running out of memory.  In this video we show you how to detect this is happening and explain more about the limiter itself. More...

User Group Meeting in Dundee (Scotland)

by Allan Mitchell 5 Jan 2010 18:34
Tony Rogerson and myself are going to be in Dundee (we are going back to school) week beginning 18.1.2010.  Whilst there we are going to do a User Group meeting and it would be great to see people there.  More details can be found here - http://sqlserverfaq.com?eid=211

Script Task/Component and Template Information

by Allan Mitchell 8 Dec 2009 06:46
The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful. That being said we should no be using them everywhere.  There are generally Tasks/Components already provided that will do the job it may be that we have to rethink the way we want to draw our package. I had cause last week to break out the script component in SQL Server 2008 SP1 and found that it was broken.  I don’t know when it broke as I do not use them all that often.... [More]

Change Data Capture Webinar

by Allan Mitchell 12 Sep 2009 07:37
I am going to be doing a webinar with our friends at Attunity on Change Data Capture.  Attunity have a good story around this technology and you can use it in your SSIS loads to great effect. Join Attunity and Konesans/SQLIS for a Webinar on 17 September Space is limited. Reserve your Webinar seat now at: https://www1.gotomeeting.com/register/693735512 Want increased efficiency and real-time speed when conducting ETL loads? Need lower implementation costs while minimizing system impact? Learn how change data capture (CDC) technologies can reduce ETL lo... [More]

Swiss SQL Server Saturday, Zurich, September 19th

by Allan Mitchell 21 Aug 2009 13:34
I am going to be speaking at the first ever SQL Server Saturday in Switzerland this autumn.  This event is taking place on Saturday 19th September in Zurich.  If you want to know more about it or are thinking of coming then head over to www.sqlsaturday.ch Charley has lined up a top list of speakers for this event and I know it is going to be a fun day.

Manchester UG Presentation Video

by Allan Mitchell 11 Aug 2009 16:01
In July I was invited to speak at the UK SQL Server UG event in Manchester.  I spoke about Excel being a good data mining client.  I was a little rushed at the end as Chris Testa-ONeill told me I had only 5 minutes to go when I had only been talking for 10 minutes.  Apparently I have a reputation for running over my time allocation.  At the event we also had a product demo from SQL Sentry around their BI monitoring dashboard solution.  This includes SSIS but the main thrust was SSAS Then came Chris with a look at Analysis Services.  If you ... [More]

Donald Farmer comes to SQLBits

by Allan Mitchell 11 Aug 2009 13:36
What do medieval archaeology, fish farming, Southwestern University of Chongqing and Microsoft Business Intelligence have in common? If you know, you should tell Donald Farmer, because he has been deeply involved in all of them at various times. Donald has worked in the Microsoft Business Intelligence team for 8 years covering many subject areas: data integration, information quality, metadata intelligence, master data management, OLAP, predictive analytics and self-service BI. He is a well-known speaker at Microsoft and other industry events, and the author of several books and articles. ... [More]

Integrating Data Mining into your BI Solution (Presentation)

by Allan Mitchell 9 Jun 2009 08:23
I recently gave a live meeting presentation to the UK User Group on Integrating Data Mining into your BI Solution.  In it I talk about and demo ways of using your data mining models inside Integration Services, Analysis Services and Reporting Services.  This is the first in a series of presentations I will be doing for the UG as I try to get the word out that Data Mining can be for the masses. You can download my deck and my line meeting recording from here.

July SQL Server UG Event in Manchester

by Allan Mitchell 18 May 2009 16:18
I will be speaking at the SQL Server UK User Group event in Manchester on 16.07.2009.  I am going to be talking about data mining again and how it isn’t all statistics and people with PhDs from Oxford.  Come join me and the excellent Chris Testa-O’Neill.  More details and registration can be found here

UK SQL Server User Group Events (June)

by Allan Mitchell 13 May 2009 07:12
There are two events of note for the SQL Server User Group in June.  The first is a Live Meeting event with myself on 04.06.2009.  I am going to be looking at how to integrate Data Mining into your BI solution.  I will be looking at putting DM into SSIS, SSAS and SSRS.  It will be very demo oriented.  You can register for the event here The second event is an event at Microsoft Reading on 10.06.2009.  The evening will be a BI/Data Mining event.  Chris Webb and myself are organizing it and  we want speakers.  We would love to see new faces up the... [More]

UK SQL Server User Group Event (May)

by Allan Mitchell 13 May 2009 07:02
Our very own Darren Green is speaking at a UK user group event in Cambridge (UK) on 20.05.2009.  He will be speaking on Integration Services.  Peter Blackburn will also be there and what he doesn’t know about SSRS isn’t worth knowing.  It promises to be a good night.  We would love to see as many people there as possible so head over to the UK User Group site and register. Register Here

SSIS Performance Tuning Seminar (1 day)

by Allan Mitchell 18 Feb 2009 12:29
I am going to be delivering a one day tuning seminar for SSIS (SQL Server 2005).  I am doing it in conjunction with the UK User Group.  I will be covering as much as I am able on how to look at your package with performance in mind.  I will show you how to get more from the data flow engine and also how to avoid common performance slow downs.  The location we have chosen is beautiful and it should be really good day. if you are interested then shoot over to here Perf Course

Attunity Oracle CDC Solution for SSIS - Beta

by Allan Mitchell 18 Feb 2009 12:23
We in no way work for Attunity but we were asked to test drive a beta version of their Oracle CDC solution for SSIS.  Everybody should know that moving more data than you need to takes too much time and uses resources that may better be employed doing something else.  Change data Capture is a technology that is designed to help you identify only the data that has had something done to it and you can therefore move only what is needed.  Microsoft have implemented this exact functionality into SQL server 2008 and I really like it there.  Attunity though are doing it on Oracle... [More]

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

RecentComments

Comment RSS