What’s new in SQL Server 2014 – Full Day Workshop in Sydney

Shameless plug time – I’ll be demoing HDInsight at the event below in Sydney on May 28th – grab a ticket here. The text below is pretty much a straight copy from the event website, so hop over there for up to date details. There’s some great and knowledgeable speakers… and me :)

SQL Server 2014 Jump Start

Mission Critical Performance, BI, Big Data and Cloud

When: 28th of May, 9:00 AM to 5 PM

Where: Saxons, Level 12, 10 Barrack Street, Sydney NSW 2000

  • Discover the impact of cloud technologies on Business Intelligence
  • Accelerate your solutions with in-memory databases
  • Enable analytics for your users with the latest wave of self-service solutions

Register today and join our special event featuring SQL Server experts and guest speakers from Microsoft.

In this full day event, you will learn about the new features and enhancements to Microsoft SQL 2014 and Power BI, as well as how to create business value through features such as in-memory databases and Power BI reporting.


Who Should Attend:

  • IT professionals or DBAs using SQL Server Enterprise, with multi-terabyte OLTP or OLAP databases, interested in increased scaling, high availability, and performance
  • BI developers or administrators interested in an overview of the SQL Server big data analytics platform
  • Data professionals interested in the options for SQL Server hybrid solutions both on premise and in the cloud



  • Victor Isakov (MVP, MCT, Microsoft Certified Master, Microsoft Certified Architect: SQL Server)
  • James Beresford (www.bimonkey.com)
  • Iman Eftekhari (MCSE, MCITP: Business Intelligence)
  • Dean Corcoran (Microsoft)
  • Shashank Pawar (Microsoft)



  • 09:00 am: Opening by Microsoft
  • 09:30 am: Session 1: SQL Server 2014 editions and engine enhancements
  • 10:30 am: Morning Tea
  • 10:45 am: Session 2: Data analytics and BI
  • 11:45 am: Session 3: Cloud and Big Data
  • 12:15 pm: Lunch
  • 01:15 pm: Demo 1: Database enhancements
  • 02:45 pm: Demo 2: Self-service BI in the Cloud
  • 03:30 pm: Afternoon tea
  • 04:00 pm: Demo 3: Big Data

Read More

TechEd 2013: I’ll be presenting!

I’ll be presenting at TechEd Australia 2013 on “Big Data, Small Data and Data Visualisation via  Sentiment Analysis with HDInsight

In the session I’ll be looking at HDInsight – Microsoft’s implementation of Hadoop – and how to leverage that to perform some simple Sentiment Analysis, then link that up with structured data to perform some Data Visualisation using the Microsoft BI stack, especially PowerView.

Hopefully this will also tie in with the release of a White Paper on the subject so anyone with deep technical interest can get hands on with the experience.

I’m excited to get a chance to present again – look forward to seeing you there!

Read More

I’ll be speaking at Tech-Ed Australia 2012

I'll be speaking at Tech Ed Australia 2012
I’ll be speaking at Tech Ed Australia 2012







What it says on the tin: I’ll be presenting a session entitled “Introducing Data Quality Services and its role in an Enterprise Information Management (EIM) Process” at Tech Ed Australia 2012.

Look forward to seeing you there!

Read More

SQL Server user group presentation deck – DQS & SSIS in SQL2012

So, a little late – it’s been a busy couple of weeks – but the deck from my presentation “Introducing SQL Server Data Quality Services, plus what’s new in SQL2012 SSIS” is available here: Download

It was a great and well attended session – especially given it was Valentine’s day – so I owe some thanks to attendees’ forgiving spouses as well as mine! Remember to keep an eye on http://sqlserver.org.au/ for upcoming events.

Read More

I’m presenting at SQL Server User Group on Feb 14th

If you’re in Sydney on Valentine’s day and don’t like your wife / partner all that much, you can come and spend time with something you really love – SQL Server! I’m presenting at the SQL Server User Group on Feb 14th – the session title is “Introducing SQL Server Data Quality Services, plus what’s new in SQL2012 SSIS”. Please register at: http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=577


Read More

AUSSUG Followup

After the great session at AUSSUG on Tuesday, I thought i’d share the presentation materials, so here’s my powerpoint slides. I enjoyed the shorter, more interactive format.

I’ve also been busy updating the documentation for the BI Monkey SSIS ETL Framework on the codeplex site, and have uploaded a fresh alpha release – which is significantly more tested and reliable – it’s already had quite a few downloads so i’m looking forward to some feedback soon.

Read More

The BI Monkey SSIS ETL Framework

I have, after at least 3 incarnations of building SSIS based ETL control frameworks, decided to do a fourth and (possibly) final one – for all to share. The alpha release of this is available now on CodePlex @ http://ssisetlframework.codeplex.com. I’ve put an aplha up, rather than a better tested Beta because the youngest BI Monkey in my household appears to be unhappy being a baby right now and is taking me away from this side project.

It’s fairly standard stuff from my point of view – it’s metadata driven framework that consists of a single control package and a template execution package. I’ve aimed to include the following features, all of which can be turned on or off in the metadata without altering any code.

  • Recoverability
  • Extraction constraints
  • Execution order
  • Dependencies
  • Failure handling

The SSIS packages are pretty much a simple interface for where the meat of the decision making is occurring – in a bundle of stored procedures where it’s a lot easier to write and maintain complex decisions about processing than in SSIS.

I’m adhering to my own self-set principles on usability as well, namely to hit these targets:

  • High visibility of operation via reports
  • Fully commented code
  • No acronynms in table and field names
  • Any codes used exposed in a metadata table

I will be doing a demo of it at the AUSSUG session in Sydney this coming Tuesday as part of the SSIS round table which is taking place:

James Beresford:  ETL Frameworks

Design and Implementation considerations when building ETL Control Frameworks, Including the debut demo of the BI Monkey ETL Framework

Kevin Wong:  Practical ADO. NET

Three practical showcases using ADO.NET in SSIS including re-usable in memory resultsets

Glyn Llewellyn:  Putting the T back into ETL

Looking at alternative ways in SSIS to perform data transformations and correction and discussing the advantages and disadvantages of each method

(Full details at the AUSSUG website)

I hope to see you there!

Read More

AUSSUG Upcoming Sessions

In case you aren’t in the Australian SQL Server User Group, AUSSUG, there are a few upcoming sessions in Sydney which will be pretty useful – check out the official site to register. Sessions are free and always useful.

Lunchtime Wed 3rd March, 2010 – Ensuring Optimal Performance in SQL Server 2008 Based Applications with Viktor Isakov

Evening * Thu * 4th Mar 2010 – What’s new in Reporting Services 2008 R2 and PerformancePoint Services 2010 with Peter Myers, presenting what’s new in the upcoming release of Reporting Services 2008 R2 and PerformancePoint Services 2010

And TBA date in April 2010 – Knights of the SSIS Round Table – Kevin Wong, Glyn Llewelyn and myself will be presenting a series of mini demos followed by Q&A, so a chance to pick some expert brains

Hope to catch you at one of the sessions!

Read More

AUSSUG: Integration Services 2008 new features – Tues 10 Nov 2009

One for those Sydney resident BI Monkeys – Kasim Wirama, SQL MVP is presenting to the Sydney Chapter of the Australian SQL Server User Group on new features in SSIS for SQL 2008.

Please register at the AUSSUG website if you plan to attend – sessions are free. I expect to be there, finally able to attend for the first time in months, having missed some very interesting sounding sessions. The presentations are always useful and a great chance to meet with some of the SQL Server Gurus in Sydney.

Full details below:

Venue: Mechanics’ School of Arts, Level 1, 280 Pitt St, Sydney

5:30PM Networking (Pizza & Drinks provided)
6:00PM – 8:00PM Session

On: Tuesday, 10 November 2009

Session Details

SQL Server Integration Services (SSIS) is prime ETL engine of SQL Server 2005/2008.
At this session, I would like to show new feature and improvement in SSIS 2008 and
presents practical SSIS solutions, i.e.:

* Referenced resultset
* Branching in control flow and data flow
* Centralized SSIS package configuration and logging
* Multi column output with Oledbcommand component
* Streaming (high performance) sequence number
* Dynamic source file connection with much less code than former DTS does
* Lookup improvement in SSIS 2008

Read More

The ABC of ETL with SSIS followup

I have now uploaded all the files used in the presentation as promised – see the blog post dated for yesterday. Everyone provided very positive feedback and it appears that there was something useful for all attendees. It was quite daunting presenting to 50+ people so i’m glad the audience was friendly!

Read More