22-25 April 2026 
SQLBits 2015
Scaling the DVD Store from 100 to a million TPM
Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
The Dell DVD store is an open source database and online commerce application used for benchmarking hardware.
Come along to see us attempt to optimise and redesign the "Dell DVD Store" sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
In Part I we will see just how far we can optimise a the commerce solution using traditional tuning and scale up on a single database server and making use of technologies like the In memory OLTP engine.
In Part II we look to migrate the solution to the cloud taking advantage of scalability features the Microsoft Azure platform and best practices such as sharding, data caching and asynchronous processing.
Come along to see us attempt to optimise and redesign the "Dell DVD Store" sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
In Part I we will see just how far we can optimise a the commerce solution using traditional tuning and scale up on a single database server and making use of technologies like the In memory OLTP engine.
In Part II we look to migrate the solution to the cloud taking advantage of scalability features the Microsoft Azure platform and best practices such as sharding, data caching and asynchronous processing.
Speakers
Bob Duffy's previous sessions
From SSIS to Synapse to Fabric - A Data Architects Case Study
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.
Financial Statements with Power BI - Part 1 P&L/BS
I will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
included is PBIX so you can follow.
EDW Automation in Synapse SQL Pools
DW Automation and Design Best Practices
SQL Storage Fundamentals for Azure VMs
SQL Storage Fundamentals for Azure VMs
Financial Modelling with Power BI
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
The European Economic Crisis and the Euro-A Data Tale
Gain insights into what is behind the media storm surrounding the Economic Crisis, by diving into publically available data using PowerBI . Learn how the use of analytical tools can empower us by answering the questions we need to ask.
Scaling the DVD Store from 100 to a million TPM
Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
When good SQL design goes bad
In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
Migrating to the Cloud
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.
Optimising Cube Processing
You don’t have to be an analysis services guru to gain a better understanding of how to analyse, configure and optimise cube processing.
The Irish Economic Crisis, Visualised with Power BI
In this session we will explore the Irish Economic Crisis from multiple perspectives, using Microsoft’s latest Visualisation tools including Power BI, Power Query, Power Map, Power View and Q&A.
SQL 2012 Always on Deep Dive
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 folk
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 Dive
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 Services
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 Planning
SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit
SQL tuning from the dot.net perspective
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.