Rudi Bruchez

Profile

Thirty years in development and databases, twenty of them as an independent consultant. I have worked on SQL Server since version 6.5: performance audits, tuning, cloud migrations, high availability, training. I also write the tools I use, in Go, C#, Python and Rust.

Based in Paris. French and fluent English. Contact me.

Experience

Since 2006, independent consultant

Engagements for banks, manufacturers, software vendors, retail and online platforms.

• Performance audits and emergency troubleshooting in production.
• Tuning of T-SQL code and ORM-generated SQL, coaching of development teams.
• High availability (availability groups, failover clusters, log shipping), backups and recovery plans.
• Version upgrades and migrations to Azure SQL or AWS RDS.
• Remote DBA work and long-term maintenance, up to seven years with the same client.
• Corporate and public training (Orsys since 2007), NoSQL courses at the universities Paris Descartes and Toulouse Le Mirail.

The measured results of these engagements are on the Achievements page.

2006, Netsize

Head of database administration: monitoring of databases distributed across several countries, coaching of developers.

2005, Karavel Promovacances

Database administrator, development and production, on high-availability databases.

2002 to 2005, Mediterranean Shipping Company

DBA at the group’s headquarters in Geneva: modeling, T-SQL, failover cluster, replication.

2000 to 2002, CNET Channel

Developer and DBA: B2B website in ASP on SQL Server 7, server security and administration.

1995 to 2000, early career in Switzerland

Freelance developer (Access, Visual Basic), then Delphi at Médiaprofil, and at CQFD Informatique a client-server system for a public service, in Visual Basic 6 on SQL Server 6.5, under my full responsibility.

Books

• SQL Server 2012 Security Cookbook, Packt Publishing, 2012.
• Pro T-SQL 2012 Programmer’s Guide, Apress, 2012, coauthor.
• In French: Optimiser SQL Server, Dunod, 2008; Les bases de données NoSQL, Eyrolles, 2013 to 2021, three editions; SQL, Pearson France, second to fourth edition, coauthor.

Training and video

• More than 120 video courses on LinkedIn Learning since 2012: SQL language, tuning and indexing, troubleshooting, C#.
• Nine courses in English on Pluralsight: SQL Server security, development best practices, Azure Cosmos DB, Python, Rust.
• More than 1,200 trainees surveyed at Orsys since 2010: delivery rated 3.76 out of 4 over the whole period, 3.9 out of 4 since 2022.

Open source

• sql-auditor: SQL Server diagnostic collector, the basis of my remote audit.
• SqlGoPace: index and statistics maintenance at a controlled pace.
• sqlferret and sqltop: workload analysis and session monitoring.
• tsql-scripts: diagnostic queries.

Awards and certifications

Skills