Prodata: SQL Centre of Excellence is an Irish Microsoft Certified Gold Partner that specializes in providing world-class consulting and managed services to its customers using the SQL Server platform. We are committed to working with our customers to help them maximize their investment in their SQL Server Estate, a crucial element in achieving this is to drive skills levels in the staff of organizations that are working with SQL on a day-to-day basis. With this in mind we regularly bring top-class local and international speakers to Ireland.

Upcoming Events

• 

  Real World Cube Design and Performance Tuning with Analysis Services

  register now

  (18/06/2013) This course aimed at intermediate-to-experienced Analysis Services developers, looking at more advanced cube design topics and query performance tuning more information

• 

  Agile Data Warehouse Design

  register now

  (18/06/2013) A 3-day workshop presented by international data warehousing (DW) expert and author Lawrence Corr, covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective DW/BI systems more information

• 

  Precon: Productivity and Leadership Skills for the IT Professional

  register now

  (21/06/2013) Skilled technologists often reach a ceiling in their career unless they move into management. Attendees will learn how to lead teams, as compared to managing teams, focusing on motivation, effectiveness, and team success.. more information

• 

  Precon: Self-Service BI and Office 2013

  register now

  (21/06/2013) This day-long seminar will look at how Office 2013 and related tools can be used to build a self-service BI solution. more information

• 

  Precon: SSIS Design Patterns, MDS and DQS

  register now

  (21/06/2013) SSIS Design Patterns, Master Data Services and Data Quality Services more information

• 

  SQL Saturday Dublin

  register now

  (22/06/2013) FREE training event for SQL Server professionals and those wanting to learn about SQL Server. High profile local and international speakers will give of their time and expertise to make sure that this is a high value event. more information

• 

  SQL Server Integration Services 2012 Design Patterns

  register now

  (09/09/2013) The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and design patterns, and those who wish upgrade their existing SSIS skills to 2012 more information

• 

  Introduction to Analysis Services 2012 Tabular

  register now

  (26/09/2013) This course is aimed at BI professionals who want to develop SQL Server Analysis Services 2012 Tabular models. No previous knowledge of Analysis Services is required more information

• 

  Advance Performance Tuning Workshop

  register now

  (30/09/2013) Friday evening and the weekend is flirting with you promisingly ... then the dreaded email arrives telling you that your SQL Server has enormous performance problems. What can you do to identify the problem and resolve it quickly? more information

• 

  Introduction to MDX

  register now

  (13/11/2013) This course designed for BI professionals with some experience of SQL Server Analysis Services cubes, but little or no experience of MDX, will teach the fundamentals of the MDX query language and show how to implement common queries and calculations more information

Previous Events

• 

  Super-Scaling SQL Server

  (13/06/2013) This course is level 400+ and targets the sweet spot between designing for performance and maintaining performance and is therefore relevant to Architects, Developers and DBAs alike, and as for Consultants more information

• 

  Introduction to PowerPivot

  (05/06/2013) This course designed for SQL Server DBAs and developers with at least one year experience of writing TSQL more information

• 

  Agile Data Warehouse Design

  (27/05/2013) A 3-day workshop presented by international data warehousing (DW) expert and author Lawrence Corr, covering the latest agile techniques for systematically gathering Business Intelligence (BI) requirements and designing effective DW/BI systems more information

• 

  Advance DAX

  (13/05/2013) This workshop is aimed at experienced POWERPIVOT and SSAS 2012 Tabular developers who already have basic knowledge of DAX. more information

• 

  SSIS - What's New in 2012

  (26/04/2013) Whether you have used previous versions of SSIS or are entirely new to the product this course will give you a good appreciation of what is possible and the processes around using the new features. more information

• 

  Advanced TSQL

  (19/03/2013) This course designed for SQL Server DBAs and developers with at least one year experience of writing TSQL more information

• 

  Optimising the SQL Platform for dot.net Solutions

  (28/02/2013) delve deeper into how dot.net design and coding practices can cause performance or scalability Issues more information

• 

  Introduction to StreamInsight

  (27/02/2013) This course is designed for BI professionals, analysts and database developers. No experience of real-time processing and analysis of data is necessary more information

• 

  Advanced Performance Tuning

  (24/01/2013) In this deep dive session we will have a more detailed look into the Plan Cache of SQL Server more information

• 

  Azure & The Cloud for SQL Professionals

  (06/12/2012) This course is designed to help SQL Professionals evaluate what Azure and the Cloud can do for them. more information

• 

  Introduction To MDX

  (05/12/2012) This course designed for BI professionals with some experience of SQL Server Analysis Services cubes, but little or no experience of MDX, will teach the fundamentals of the MDX query language and show how to implement common queries and calculations. more information

• 

  Super Scaling SQL Server

  (23/11/2012) Not for the faint-hearted, this course coud be described as performance tuning on steroids. In one intense day, Thomas will take participants beyond indexes to the next steps in optimising the performance of their SQL Servers. more information

• 

  SQL Server Performance Tuning & Troubleshooting Workshop

  (14/11/2012) Friday evening and the weekend is flirting with you promisingly ... then the dreaded email arrives telling you that your SQL Server has enormous performance problems. What can you do to identify the problem and resolve it quickly? more information

• 

  Mission Critical Availability, Availability Groups and Failover

  (26/10/2012) This session discusses and demonstrates the AlwaysOn high availability features in SQL Server 2012, specifically failover cluster instances and availability groups more information

• 

  PowerPivot Workshop

  (18/10/2012) This course is aimed at Excel and BI professionals who want to develop models in PowerPivot with Excel 2010. more information

• 

  Advanced Internals & Troubleshooting

  (09/10/2012) This two day workshop provides participants with the opportunity to learn about advanced SQL Server support topics in a very approachable way. more information

• 

  SQL Masterclass Programme 2012 - 2013

  (05/10/2012) The Master Class programme brings the most advanced SQL content delivered by internationally recognised experts to Ireland. more information

• 

  Business Intelligence with Office 2013

  (05/10/2012) Office 2013 is packed with new Business Intelligence (BI) functionality, making it an incredibly powerful tool for both corporate and self-service BI scenarios. In this session, we will look at all of the new BI features and how they can be used more information

• 

  Data Visualisation with SQL 2012

  (21/09/2012) This course is designed for BI professionals and report writers who use Excel and Power View and who want to learn how to create effective data visualisations. more information

• 

  SSAS 2012 Tabular Model Workshop

  (19/09/2012) This course is aimed at BI professionals who want to exploit the full power of the new Tabular models in Analysis Services. more information

• 

  Upgrade your SSIS Skills to 2012

  (12/09/2012) This course aimed at SQL Server Integration Services developers who want to learn about new features in SSIS 2012. more information

• 

  RWCD and PT with Analysis Services

  (03/07/2012) This course aimed at intermediate-to-experienced Analysis Services developers, looking at more advanced cube design topics and query performance tuning. more information

• 

  Data Visualisation with SQL Server 2012 Tabular Models, Power View and Excel

  (30/05/2012) This course will enable you to create data visualisations that will help you and your colleagues interpret you data more effectively in Excel and Power View. more information

• 

  SQL Server Analysis Services 2012 Tabular Workshop (in association with SQLBI)

  (28/05/2012) This course is aimed at BI professionals who want to exploit the full power of the new Tabular models in Analysis Services. more information

• 

  SQL Saturday 105

  (24/03/2012) FREE training event for SQL Server professionals and those wanting to learn about SQL Server. High profile local and international speakers will give of their time and expertise to make sure that this is a high value event. more information

• 

  SQL Saturday 105 Precon - SSIS Performance Design Patterns

  (23/03/2012) Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? This session will teach you how to pick the right design so you can hit your ETL performance goals with little to no performance tuning! more information

• 

  Introduction To MDX

  (21/03/2012) This course will be taught by Chris Webb of Crossjoin Consulting. Chris is a Microsoft MVP and a leading expert on MDX. more information

• 

  From Zero to SSIS

  (05/03/2012) This course will be taught by Andy Leonard. Andy is a SQL Server MVP and an author with decades of ETL experience and years of SQL Server Integration Services experience. more information

• 

  Introduction to Master Data Services

  (17/02/2012) An end to end look inside Master Data Services, this full day course will begin with a synopsis of Master Data Management before moving on to an overview of Microsoft SQL Server 2008 R2 Master Data Services (MDS) more information

• 

  Real World Cube Design and Performance Tuning

  (09/02/2012) This course will be taught by Chris Webb of Crossjoin Consulting. Chris is a Microsoft MVP and a leading expert on MDX. more information

• 

  Advanced SQL Internals and Troubleshooting Workshop

  (06/12/2011) The Advanced Troubleshooting Workshop for SQL Server 2005, 2008 and R2 provides attendees with SQL Server internals knowledge, practical troubleshooting skills and a proven methodical approach to problem solving. more information

• 

  SQL 2008 Developer WorkShop

  (01/11/2011) A 2-day interactive workshop that drills down into new features, tools and best practices for developers working with SQL Server 2008 or 2008 R2 more information

• 

  SQL Tuning for Dot.Net Applications

  (08/09/2011) If you are developing an application on top of SQL Server this session is a must before you do any performance tuning more information

• 

  SQL Scalability

  (26/05/2011) An overview of how to scale SQL Server from humble beginning to tens of thousands or potentially millions of users. more information

• 

  SSIS Deep Dive

  (31/03/2011) Key design and performance concepts that you need to know to build scalable and performant SSIS packages more information

• 

  PowerPivot Fundamentals

  (20/01/2011) Practical PowerPivot Fundamentals to get you started more information

• 

  SQL Consolidatation and Virtualisation

  (24/11/2010) If you are about to embark on a consoldation or virtualisation project, this session is a must. more information

• 

  SQL Masterclass Programme

  (24/11/2010) The SQL MasterClass programme for 2010/2011 brings the most advanced SQL Server Content to Ireland more information

• 

  Introduction to MDX with Analysis Services - Chris Webb

  (30/09/2010) Introduction to MDX - Chris Webb more information

• 

  Disaster Recovery Master Class

  (07/07/2010) 2-day Master Class more information

• 

  Performance Optimization Master Class

  (05/07/2010) 2-day Master Class more information

• 

  SQL Immersion: Dublin 2010 with Paul Randal & Kimberly Tripp

  (28/06/2010) The foremost speakers and mentors in SQL Server - Paul Randal and Kimberly Tripp are bringing SQL Immersion Events to Europe. more information

• 

  Real-World Cube Design & Performance Tuning with Analysis Services 2008

  (27/05/2010) Real-World Cube Design with Analysis Services 2008 - Chris Webb more information

• 

  SQL Academy Module IV: SQL 2008R2 Next Generation BI

  (23/03/2010) Level 300, blah blah more information

• 

  SQL Immersion 2009

  (21/09/2009) The foremost speakers and mentors in SQL Server - Paul Randal and Kimberly Tripp are bringing SQL Immersion Events to Europe. more information