SQLBits 2011

Building a SSMS Add-in; The Agony and Ecstasy

We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.

Cast your mind back to November 2005, Madonna had just been knocked off the Number 1 spot by the Pussycat Dolls and SQL Server 2005 was released - writing Management Studio Add-ins was a total nightmare.

Fast forward 3 years, Katy Perry was kissing a girl and SQL Server 2008 was released, guess what, Management Studio Add-ins still a total nightmare and your previous 2005 Add-ins didn’t work!

As Lady Gaga sings Bad Romance, the team in Redmond release SQL Server 2008 R2 and SSMS Add-ins break again.

In this session I'll run through creating a SQL Server Management Studio 2008 R2 Add-in (in C#), covering common pitfalls, gotchas and the differences between 2005/2008/R2.

And if it’s released by then the joys of rewriting your Add-ins for Denali.

Mark Pryce-Maher's previous sessions

Nose-Dive Narratives: Slide Karaoke 2024

Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!

Fabric Product Group - Ask us Anything

Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

A Deep Dive into Microsoft Fabric Data Warehouse

Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.

Synapse Q&A with PG

SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.

Lightning Talks

5 minute lightning talks from your favourite speakers

Dedicated SQL Pools : How some stuff 'really' works

Session covering table distributions, partitioning , RSC and materialised views.

Reporting on 1.4B rows with Serverless SQL Pools

Building a dashboard using Serverless SQL Pools in a performant way

Azure Synapse Analytics: Evolving Azure SQL Data Warehouse

In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.

Modernizing & Migrating Your Data Warehouse w/ Azure Synapse

This session will dive into how to successfully migrate to Azure Synapse, all the way from code conversion to enterprise grade developer tooling, with real customer examples for product and migration experts.

Azure Machine Learning from the ground up

Azure Machine Learning is a fully managed cloud service for predictive analytics. In this 1hour session, we will run through; ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.

Building a SSMS Add-in; The Agony and Ecstasy

We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.