Send us a text

Summary

In this episode of The sql_squared Podcast!!!, we're joined by our special guest, Simon Frazer, for a deep dive into the journey from software developer to data expert. As an expert in SQL Server performance, optimization, and security, Simon shares his unique insights on the evolving roles within the tech industry. This conversation is centered around our guest's experiences, from his early days in software development to becoming a production DBA and consultant. Listeners will walk away with a deeper understanding of the differences between development and DBA roles, practical tips for performance tuning using tools like the Brent Ozar Consultant Toolkit, and a fresh perspective on the value of community engagement through conferences. This is a can't-miss episode for anyone interested in database administration, career transitions in tech, and SQL Server optimization.

Guest Information

• Name: Simon Frazer
• Bio: Simon Frazer is a Senior Database Administrator at Medivet and the owner of his own SQL Server consultancy, Simon Fraser Limited. He specializes in performance, optimization, and security, with a background that began in software development before transitioning into the data space.
• LinkedIn: https://www.linkedin.com/in/simon-frazer/

Resources Mentioned

• Brent Ozar Consultant Toolkit: https://www.brentozar.com/ - A set of scripts (part of the First Responder Kit) that quickly check SQL Server health and performance, simplifying troubleshooting for DBAs and consultants.
• Azure SQL Managed Instance: A managed cloud database service discussed for its ability to automate tasks like patching and backups, freeing up DBAs to focus on higher-value work like performance tuning.
• Data Scotland: A free, community-led data conference in Scotland, highlighted for its high-quality sessions and welcoming community vibe.
• SQLBits: A major UK-based data platform conference, known for attracting speakers and attendees from around the world.

#SQLServer, #DatabaseAdministration, #DBA, #PerformanceTuning, #SoftwareDevelopment, #BrentOzar, #DataCommunity, #SQLBits, #DataScotland, #Mana

Support the show

Support the show!

Enjoying The sql_squared Podcast? The best way to support us is by subscribing to our YouTube channel!

• Watch & Subscribe on YouTube
• Listen on other platforms: Apple Podcasts | Spotify
• Leave a Review: If you found this episode helpful, please leave a 5-star review wherever you get your podcasts or leave a like and comment on YouTube.
• Share: Know someone who would love this episode? Go ahead and share a link!

The sql_squared podcast is your guide to navigating the ever-evolving world of data. We go beyond the code to explore the tools, techniques, and trends that shape the data landscape, from SQL Server and cloud platforms to AI and developer productivity. Join us as we chat with experts from the community to help you learn, grow, and make the right decisions on your data journey.

• Website: https://www.sqlsquared.co.uk/
• Twitter/X: @sql_squared
• LinkedIn: @sql_squared
• Email: mailbag@sqlsquared.co.uk

Send us a text

In this episode of The sql_squared Podcast!!!, we're joined by our special guest, Mike Hodson, for a deep dive into data development, Agile methodologies, and the evolving role of data in the recruitment industry. As a seasoned tech leader and Scrum Master with a passion for data, Mike shares his unique insights on adopting Agile processes, leveraging data for business success, and the future of AI in development.

Bio: Mike Hodson is a tech leader and Scrum Master with a strong passion for data. He began his career with a maths degree and a love for numbers, falling into a data management role that he grew to love. With over 18 years of experience, Mike has progressed from a data manager and SQL developer to a certified Scrum Master, focusing on Agile methodologies to bridge the gap between development and business needs.

Social Media

LinkedIn: https://www.linkedin.com/in/masterofscrum/

Key Topics & Timestamps

• 00:00 - Introduction to Data and Tech Leadership
• 01:40 - Mike's Career Journey and Passion for Data
• 07:11 - Current Role and Responsibilities in Data Management
• 10:56 - Understanding Agile and Scrum Methodologies
• 12:01 - Benefits and Challenges of Scrum in Development
• 27:53 - Leveraging Data in Recruitment
• 34:50 - Innovative Uses of Data in Recruitment Processes
• 35:25 - Leveraging CRM for Recruitment Opportunities
• 37:55 - AI in Recruitment: Enhancing Efficiency and Context
• 43:34 - Data Security and Ethical Considerations in Recruitment
• 48:12 - Quickfire Round: Insights and Personal Preferences
• 53:03 - The Future of Data: Trends and Predictions

Resources Mentioned

• NotebookLM: https://www.sqlsquared.co.uk/blog/the-data-flow-3/notebooklm-the-perfect-note-taking-and-research-companion-7 - David's blog post on a Google product that uses AI to analyze and generate content from uploaded documentation.
• Model Context Protocols (MCPs): A discussion on an innovative AI concept that acts as a bridge between an AI agent and other data sources, with a C# implementation for SQL Se

Support the show

Support the show!

Enjoying The sql_squared Podcast? The best way to support us is by subscribing to our YouTube channel!

• Watch & Subscribe on YouTube
• Listen on other platforms: Apple Podcasts | Spotify
• Leave a Review: If you found this episode helpful, please leave a 5-star review wherever you get your podcasts or leave a like and comment on YouTube.
• Share: Know someone who would love this episode? Go ahead and share a link!

The sql_squared podcast is your guide to navigating the ever-evolving world of data. We go beyond the code to explore the tools, techniques, and trends that shape the data landscape, from SQL Server and cloud platforms to AI and developer productivity. Join us as we chat with experts from the community to help you learn, grow, and make the right decisions on your data journey.

• Website: https://www.sqlsquared.co.uk/
• Twitter/X: @sql_squared
• LinkedIn: @sql_squared
• Email: mailbag@sqlsquared.co.uk

Send us a text

Episode Summary

In this episode of The sql_squared Podcast, we're joined by our special guest, Elliot Leighton-Woodruff, for a deep dive into Azure cloud migrations. As an expert Principal Architect specializing in Azure, Elliot shares his unique insights on moving beyond simple "lift and shift" projects to truly modernize applications and infrastructure for maximum return on investment.

This conversation is centered around our guest's extensive experiences and knowledge. Listeners will walk away with a deeper understanding of the "Five Rs" of cloud migration, practical tips for avoiding common cost pitfalls and managing services effectively, and a fresh perspective on the "build vs. buy" dilemma for software solutions. This is a can't-miss episode for anyone interested in cloud architecture, DevOps, and data platform strategy.

Guest Information

• Name: Elliot Leighton-Woodruff
• Bio: Elliot Leighton-Woodruff is a Principal Architect and Azure expert with 15 years of industry experience. His journey has taken him from infrastructure engineering and data center fit-outs to specializing in Office 365 and now focusing on Azure application modernization for the past several years. Elliot is a strong advocate for Infrastructure as Code, applying an 80/20 rule to automation to help customers maximize their cloud investment.
• Website: https://www.synextra.co.uk/
• Social Media:
  • LinkedIn: https://www.linkedin.com/in/elliottlw/

Resources Mentioned

• The Five Rs of Migration: A framework mentioned by Elliot for classifying application migration strategies (Rehost, Refactor, Rearchitect, Rebuild, Replace) to ensure you choose the right approach.
• Terraform: An Infrastructure as Code tool discussed for its ability to automate, standardize, and efficiently deploy cloud resources, reducing human error.
• Northern Azure User Group: The local Manchester-area tech community where the host and guest met, recommended for networking and learning.

Support the show

Support the show!

Enjoying The sql_squared Podcast? The best way to support us is by subscribing to our YouTube channel!

• Watch & Subscribe on YouTube
• Listen on other platforms: Apple Podcasts | Spotify
• Leave a Review: If you found this episode helpful, please leave a 5-star review wherever you get your podcasts or leave a like and comment on YouTube.
• Share: Know someone who would love this episode? Go ahead and share a link!

The sql_squared podcast is your guide to navigating the ever-evolving world of data. We go beyond the code to explore the tools, techniques, and trends that shape the data landscape, from SQL Server and cloud platforms to AI and developer productivity. Join us as we chat with experts from the community to help you learn, grow, and make the right decisions on your data journey.

• Website: https://www.sqlsquared.co.uk/
• Twitter/X: @sql_squared
• LinkedIn: @sql_squared
• Email: mailbag@sqlsquared.co.uk