Video unavailable

SQLBits 2022

ColumnStore Maintenance in Synapse SQL Pools

ColumnStore Maintenance in Synapse SQL Pools

Columnstore are pretty much a defacto standard for large tables in SQL pools, but nothing ships as standard to do daily/weekly maintenance. This session explores some Columnstore internals and using this to review health and implement maintenance and optimisation. Included is a free opensource framework for ColumnStore maintenance using Industry Best Practise for SQL Pools.

Speaker

Bob Duffy is a SQL Server MVP, currently working as Database and Solution Architect in Dublin, Ireland. He has over 28 years experience in the database sector, with MCA, MCM and Maestro certification.

Bob Duffy's Sessions

Automating Star Schemas in Fabric DW

From SSIS to Synapse to Fabric - A Data Architects Case Study

Financial Statements with Power BI - Part 1 P&L/BS

ColumnStore Maintenance in Synapse SQL Pools

EDW Automation in Synapse SQL Pools

Stats Maintenance in Synapse SQL Pools

Cashflow Statements with Power BI

SQL Storage Fundamentals for Azure VMs

Financial Modelling with Power BI

Financial Modelling with Power BI

Using the Data Gateway for Hybrid PowerBI and Flow

SQL Storage Fundamentals for Azure IaaS

The European Economic Crisis and the Euro-A Data Tale

Scaling the DVD Store from 100 to a million TPM

When good SQL design goes bad

Migrating to the Cloud

Optimising Cube Processing

The Irish Economic Crisis, Visualised with Power BI

SQL 2012 Always on Deep Dive

Windows Azure For SQL folk

SQL 2012 Always On-Deep Dive

Load Testing Analysis Services

SQL Consolidation Planning

SQL tuning from the dot.net perspective

SQL Server Denali-Always On Deep Dive

Performance Management for SQL Server with SCOM 2007

Self Service Business Intelligence- Project Gemini