Bob Duffy

prodata.ie/author/bob

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and now Analysis Services “Maestro” certified. Bob used to work for Microsoft Consulting Services a Senior Consultant and subject matter expert for BI/data. He now works at the Prodata SQL Centre of Excellence in Dublin, Ireland where he helps enterprise customers with design, performance tuning, benchmarking and pretty much anything to do with SQL Server or Business Intelligence.

Bob Duffy's Sessions

Migrating to the CloudSQLBits 2014

In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.

SQL 2012 Always on Deep DiveSQLBits 2013

Always On Availability Groups offer a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in SQL 2012 emphasizing key features and benefits.

Windows Azure For SQL folkSQLBits 2013

We aim to cover the fundamental concepts that you should know on the Cloud and Windows Azure. In this demo based hour we will step through building Azure applications, deploying and managing them and what storage choices you will face.

SQL 2012 Always On-Deep DiveSQLBits 2012

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.

Load Testing Analysis ServicesSQLBits 2012

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?

SQL Consolidation PlanningSQLBits 2011

SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit

SQL tuning from the dot.net perspectiveSQLBits 2011

So your customer's dot.net application is ready to ship and it is dog slow. This session focuses on the tools and methology that SQL consultants use to test and improve performance with dot.net applications.

SQL Server Denali-Always On Deep DiveSQLBits 2011

SQL Server denali offers a huge leap forward in terms of high availability. This sessions is an Introduction to the changes in Denali and a demonstration of the key features and benefits.

Performance Management for SQL Server with SCOM 2007SQLBits 2010

Learn to love SCOM! Out of the box the SCOM Management Pack for SQL Server is not popular with DBA's. This demo based session will take you through the process of how you can extend SCOM to properly monitor and analyse SQL performance. Ultimately providing performance management scorecards and dashboards for your CIO.

Self Service Business Intelligence- Project GeminiSQLBits 2009

Microsoft Project Gemini brings data modelling and Business Intelligence in the hands of the end user - good or bad. This session demonstrates how to build and deploy an end to end business intelligence solution with project Gemini.

Automating Star Schemas in Fabric DWSQLBits 2026

This session shows how to rapidly build a Kimball star schema in Microsoft Fabric using minimal code, industry-standard T-SQL templates, metadata-driven design, and modern declarative patterns. You’ll learn how to automate dimension and fact loading, simplify orchestration, tune performance, and manage data quality and lineage—enabling faster, more scalable, and maintainable data warehouse solutions.

Diving Into Graph API with Fabric NotebooksSQLBits 2026

Microsoft Graph API is the unified gateway to Microsoft Cloud data, enabling powerful integration and automation. In this session, you’ll learn how to use Graph API with Microsoft Fabric to integrate SharePoint, analyze Power BI usage via Log Analytics, monitor Office 365 and OneDrive compliance, and interact with Azure services. We’ll cover core concepts, security best practices, and hands-on examples, plus provide ready-to-use GitHub templates so you can start building immediately. Join us to streamline cloud integrations and supercharge your Fabric workflows with Graph API.

PBI Financial Modelling Masterclass - Part 1 PL/BSSQLBits 2026

Learn how to build fast, scalable P&L and Balance Sheet statements by moving from measure-based DAX to a model-driven approach. We’ll cover dynamic modelling, flexible layouts, and advanced financial reporting—plus you’ll get a downloadable PBIX to try it yourself.

PBI Financial Modelling Masterclass – Part 2 AP/ARSQLBits 2026

Build AR and AP models that work across any ERP. Learn how to handle ageing, reconciliation, FX exceptions, and as-of balances—plus get a ready-to-use PBIX.

RAG + Fabric + Eventhouse: An End-to-End Pattern for Automated Contract ComplianceSQLBits 2026

A practical walkthrough of building an auditable, scalable RAG-based contract compliance solution on Microsoft Fabric, from ingestion to insight.

Replacing ADF with Notebooks in FabricSQLBits 2026

We replaced most ADF pipelines with Fabric notebooks. In this session, we explore why moving from pipeline-centric to notebook-centric ETL can improve performance, extensibility, and developer experience in data engineering.

Automating Star Schemas in Fabric DWSQLBits 2025

This session will explore how to streamline the process of building a Kimball star schema in a Fabric Data Warehouse using minimal code, leveraging Industry Standard T-SQL templates, metadata, and modern, declarative architectures. We will guide you through best practices for transforming raw data into a well-structured and optimized star schema, focusing on automation, efficiency, and simplicity. Ideal for those looking to accelerate Data Warehouse development and achieve scalable, maintainable solutions with minimal manual coding.

From SSIS to Synapse to Fabric - A Data Architects Case StudySQLBits 2024

In 2019 we migrated our EDW automation Framework to Synapse and ADF In 2023 we completed migration of the latest version to Fabric. This session shows you the - Migration process - Lessons learned - Improvements - Unit Test Strategy used. - What we are looking forward to Come along to hear some real-world lessons learned on using Fabric, Migrating to Fabric and re-architecting on Fabric using declarative techniques.