SQL Centre of Excellence

Just announced is that Matt Massonis to deliver a WHOLE Day seminar as part of the SQL Saturday event I am helping organise with the Dublin SQL Users group. Matt is a developer on the Microsoft SSIS Product Team in Redmond, and is coming all the way from Canada!

This will be cover a number of modules aimed to help anyone heavily involved with SSIS with performance and improving their design patterns.

Course Modules

  • Module 1 - Data Flow Internals
  • Module 2 - Benchmarking and Performance Best Practices
  • Module 3 - Common Design Patterns
  • Module 4 - Lookup Design Patterns
  • Module 5 - Parallelization Design Patterns
  • Module 6 - Advanced Design Patterns
  • Module 7 - SSIS in SQL Server 2012

Its a community event, so the 199 euro cost is just to help fund the large and FREE SQL Saturday event which is nearly up to 400 registrations! Places will be limited to about 80 and I would expect these to all go, so book early.

The link to the SSIS preconference with Matt Masson on Friday 23rd March, 2012 is http://www.prodata.ie/Events/2012/SSIS-Precon.aspx

The link to the SQL Saturday event on Saturday 24th March, 2012 is http://www.sqlsaturday.com/105/eventhome.aspx

My Sessions selected at SqlBits

by Bob Duffy 8. January 2012 07:50

I’m super excited that two of my sessions have been selected for SqlBits (http://sqlbits.com/) on the 29th –31st March, 2012. SqlBits is all lined up to be the largest SQL event in Europe this year!

If you go to only one SQL event this year, this is the one. Now if you go to two events you must of course come to our very own first ever Sql Saturday which is also the Irish Technical launch for SQL 2012. its on the 23rd march and is free http://www.sqlsaturday.com/105/eventhome.aspx

here are my two sessions.

Load Testing Analysis Services (Friday 30th March)


Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?

This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. Including how to locate resource bottlenecks and the appropriate configuration settings that can help improve performance.

Sample source code will be supplied to help you load test analysis services. We will be focused on the MOLAP engine, but techniques are equally applicable to the new tabular data model available in BISM.

SQL 2012 Always On-Deep Dive (Sat 31st March)


Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.

During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery.

This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.

This session scored really highly in the last SQL Bits so I hope to improve the scores this time.


Page List

Page List