Nimesh Bhagat's guest appearances

Nimesh Bhagat

Google Cloud Platform Podcast

PurePerformance

Steve McGhee

Kelsey Hightower

Peter Norvig

Eric Anderson

John Bohannon

Manuel Lima

Margaret Mitchell

Jessie Frazelle

Joanna Smith

Juliet Hougland

Michelle Casbon

Jesse Houston

Mark Chmarny

Ville Aikas

Dale Markowitz

OwlTail

Morgan McLean

First time co-host Jan Kleinert joins Mark Mirchandani this week to talk about database observability and the cool tools that make it possible. Morgan McLean and Nimesh Bhagat describe database observability, which uses metrics, logs, and other tools to help users understand the health of your database. We talk about Object Relational Mappers and the challenges with using these for debugging database performance. SQL Commenter helps database observability in two ways: it is both a library and a standard, Nimesh tells us. He describes the process for us, detailing exactly how SQL Commenter effects projects. Recently, SQL Commenter was donated to OpenTelemetry to augment the observability offerings, create an application standard, and make it easier for developers to use a variety of different tools and languages. Engineers can get end-to-end traces no matter which database technologies they use. Morgan tells us about Splunk and how information from SQL Commenter is taken into Splunk and used. Backend data like metrics from Cloud Monitoring and client libraries can be correlated together with SQL Commenter and brought into Splunk for full stack observability. Nimesh offers client examples to help us understand how these useful tools integrate for optimal observability. He tells us about the databases and ORMs supported by SQL Commenter. Our guests and co-host Jan give tips to help our listeners get started with SQL Commenter and talk about what they’re looking forward to in the future of observability. Nimesh Bhagat Nimesh is a product manager at Google Cloud, he leads Database Observability. He has worked across engineering and product roles, building highly available and high performance enterprise infrastructure used by Fortune 500 companies. His passion lies in combining powerful infrastructure with simple user experience so that every business and developer can build software at scale and velocity. Morgan McLean Morgan is ​​Director of Product Management at Splunk and co-creator of OpenCensus / OpenTelemetry. Cool things of the week  Google Cloud Innovators site Redesigning the Cloud SDK + CLI for easier development  blog   GCP Podcast Episode 291: Redesigning the Cloud SDK and CLI with Wael Manasra and Cody Oss  podcast   What is Active Assist? video   GCP Podcast Episode 235: Active Assist with Chris Law + MariaDB SkySQL with Robert Hedgepeth  podcast    Interview  SQL Commenter site Sequelize site SQL Alchemy site ADO.net  site GCP Podcast Episode 247: Cloud SQL Insights with Nimesh Bhagat  podcast OpenTelemetry site Splunk site Cloud Monitoring site Cloud Spanner site Cloud SQL site Cloud Trace site Sqlcommenter now extending the vision of OpenTelemetry to databases  blog  Hosts Mark Mirchandani and Jan Kleinert

First time co-host <a href="https://twitter.com/jankleinert" rel="nofollow" target="_blank">Jan Kleinert</a> joins <a href="https://twitter.com/markmirch" rel="nofollow" target="_blank">Mark Mirchandani</a> this week to talk about database observability and the cool tools that make it possible. Morgan McLean and Nimesh Bhagat describe database observability, which uses metrics, logs, and other tools to help users understand the health of your database. We talk about Object Relational Mappers and the challenges with using these for debugging database performance. SQL Commenter helps database observability in two ways: it is both a library and a standard, Nimesh tells us. He describes the process for us, detailing exactly how SQL Commenter effects projects. Recently, SQL Commenter was donated to OpenTelemetry to augment the observability offerings, create an application standard, and make it easier for developers to use a variety of different tools and languages. Engineers can get end-to-end traces no matter which database technologies they use. Morgan tells us about Splunk and how information from SQL Commenter is taken into Splunk and used. Backend data like metrics from Cloud Monitoring and client libraries can be correlated together with SQL Commenter and brought into Splunk for full stack observability. Nimesh offers client examples to help us understand how these useful tools integrate for optimal observability. He tells us about the databases and ORMs supported by SQL Commenter. Our guests and co-host Jan give tips to help our listeners get started with SQL Commenter and talk about what they’re looking forward to in the future of observability. Nimesh Bhagat Nimesh is a product manager at Google Cloud, he leads Database Observability. He has worked across engineering and product roles, building highly available and high performance enterprise infrastructure used by Fortune 500 companies. His passion lies in combining powerful infrastructure with simple user experience so that every business and developer can build software at scale and velocity. Morgan McLean Morgan is ​​Director of Product Management at Splunk and co-creator of OpenCensus / OpenTelemetry. Cool things of the week <ul> <li>Google Cloud Innovators <a href="https://cloud.google.com/innovators" rel="nofollow" target="_blank">site</a></li> <li>Redesigning the Cloud SDK + CLI for easier development <a href="https://cloud.google.com/blog/products/application-development/redesigning-the-cloud-sdk-cli-for-easier-development" rel="nofollow" target="_blank"> blog</a></li> <li> <ul> <li>GCP Podcast Episode 291: Redesigning the Cloud SDK and CLI with Wael Manasra and Cody Oss <a href="https://gcppodcast.com/post/episode-291-redesigning-the-cloud-sdk-and-cli-with-wael-manasra-and-cody-oss/" rel="nofollow" target="_blank"> podcast</a></li> </ul> </li> <li>What is Active Assist? <a href="https://www.youtube.com/watch?v=A2VgO5N_B7g" rel="nofollow" target="_blank">video</a></li> <li> <ul> <li>GCP Podcast Episode 235: Active Assist with Chris Law + MariaDB SkySQL with Robert Hedgepeth <a href="https://www.gcppodcast.com/post/episode-235-active-assist-with-chris-law-and-skysql-with-robert-hedgepeth/" rel="nofollow" target="_blank"> podcast</a></li> </ul> </li> </ul> Interview <ul> <li>SQL Commenter <a href="https://google.github.io/sqlcommenter/" rel="nofollow" target="_blank">site</a></li> <li>Sequelize <a href="https://sequelize.org/" rel="nofollow" target="_blank">site</a></li> <li>SQL Alchemy <a href="https://www.sqlalchemy.org/" rel="nofollow" target="_blank">site</a></li> <li><a href="http://ADO.net" rel="nofollow" target="_blank">ADO.net</a> <a href="https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-overview" rel="nofollow" target="_blank"> site</a></li> <li>GCP Podcast Episode 247: Cloud SQL Insights with Nimesh Bhagat <a href="https://www.gcppodcast.com/post/episode-247-cloud-sql-insights-with-nimesh-bhagat/" rel="nofollow" target="_blank"> podcast</a></li> <li>OpenTelemetry <a href="https://opentelemetry.io/" rel="nofollow" target="_blank">site</a></li> <li>Splunk <a href="https://www.splunk.com/" rel="nofollow" target="_blank">site</a></li> <li>Cloud Monitoring <a href="https://cloud.google.com/monitoring" rel="nofollow" target="_blank">site</a></li> <li>Cloud Spanner <a href="https://cloud.google.com/spanner" rel="nofollow" target="_blank">site</a></li> <li>Cloud SQL <a href="https://cloud.google.com/sql" rel="nofollow" target="_blank">site</a></li> <li>Cloud Trace <a href="https://cloud.google.com/trace" rel="nofollow" target="_blank">site</a></li> <li>Sqlcommenter now extending the vision of OpenTelemetry to databases <a href="https://cloud.google.com/blog/products/databases/sqlcommenter-merges-with-opentelemetry" rel="nofollow" target="_blank"> blog</a></li> </ul> Hosts Mark Mirchandani and Jan Kleinert

SQL Commenter with Nimesh Bhagat and Morgan McLean

Optimizing or debugging database calls has to become as easy as optimizing your application code based on logs, metrics or traces your observability platform provides to developers. It has to be doable by the development and DevOps teams who are becoming more end-2-end responsible which includes new database services that are running in some managed cloud service.In this episode we hear from Nimesh Bhagat, Product Manager at Google, how modern database observability supports development and DevOps teams to better understand, optimize and operate their end-2-end service flow. A great project Nimesh has been working on is sqlcommenter which uses OpenTelemetry to continue distributed traces started in the application into the internals of the database engine.If you want to learn more check out the sqlcommenter documentation or the Google Podcast on Cloud SQL Insights.Show LinksNimesh on Linkedinhttps://www.linkedin.com/in/nimesh-bhagat-b062354/SQLCommenterhttps://cloud.google.com/blog/products/databases/sqlcommenter-merges-with-opentelemetrySQLCommenter Documentationhttps://google.github.io/sqlcommenter/Google Podcast on Cloud SQL Insightshttps://www.gcppodcast.com/post/episode-247-cloud-sql-insights-with-nimesh-bhagat/

Optimizing or debugging database calls has to become as easy as optimizing your application code based on logs, metrics or traces your observability platform provides to developers. It has to be doable by the development and DevOps teams who are becoming more end-2-end responsible which includes new database services that are running in some managed cloud service. In this episode we hear from Nimesh Bhagat, Product Manager at Google, how modern database observability supports development and DevOps teams to better understand, optimize and operate their end-2-end service flow. A great project Nimesh has been working on is sqlcommenter which uses OpenTelemetry to continue distributed traces started in the application into the internals of the database engine. If you want to learn more check out the sqlcommenter documentation or the Google Podcast on Cloud SQL Insights. Show Links Nimesh on Linkedin <a href="https://www.linkedin.com/in/nimesh-bhagat-b062354/" rel="noopener nofollow" target="_blank">https://www.linkedin.com/in/nimesh-bhagat-b062354/</a> SQLCommenter <a href="https://cloud.google.com/blog/products/databases/sqlcommenter-merges-with-opentelemetry" rel="noopener nofollow" target="_blank">https://cloud.google.com/blog/products/databases/sqlcommenter-merges-with-opentelemetry</a> SQLCommenter Documentation <a href="https://google.github.io/sqlcommenter/" rel="noopener nofollow" target="_blank">https://google.github.io/sqlcommenter/</a> Google Podcast on Cloud SQL Insights <a href="https://www.gcppodcast.com/post/episode-247-cloud-sql-insights-with-nimesh-bhagat/" rel="noopener nofollow" target="_blank">https://www.gcppodcast.com/post/episode-247-cloud-sql-insights-with-nimesh-bhagat/</a>

OpenTelemetry for Databases: Empowering DevOps through sqlcommenter with Nimesh Bhagat

This week on the podcast, Mark Mirchandani and Gabi Ferrara talk with Nimesh Bhagat about Cloud SQL Insights. This powerful tool enables developers to diagnose database issues for faster, smoother performance. Nimesh tells us the inspiration for Cloud SQL Insight’s development and describes its biggest benefits. One of the important aspects of Insights is the ability for developers to gain an application-centric view by allowing them to tag database queries with SQL comments. These tags are aggregated in Insights and give developers a visual of the database queries. Here, developers can see load patterns and use that information to improve database efficiency. Cloud SQL Insights offers managed database analysis that helps developers understand the past and predict the future. Simplifying the journey of database debugging, Nimesh explains, was the goal of creating Cloud SQL Insights. He takes us through the process of using the software, pointing out the improvements Insights makes over the old way. Cloud SQL Insights only launched in January, but it’s already helping numerous clients with their projects. Nimesh describes these real-world uses, including Major League Baseball experience as part of Insights Early Access Program. Nimesh Bhagat Nimesh is a product manager at Google Cloud, he leads Cloud SQL Insights. He has worked across engineering and product roles, building highly available and high performance enterprise infrastructure used by Fortune 500 companies. His passion lies in combining powerful infrastructure with simple user experience so that every business and developer can build software at scale and velocity. Cool things of the week  A new collaboration with Google Cloud  blog Don’t fear the authentication: Google Drive edition  blog  Interview  Cloud SQL Insights docs Cloud SQL Documentation docs GCP Podcast Episode 163: Cloud SQL with Amy Krishnamohan  podcast Google Cloud Monitoring site Database observability for developers: introducing Cloud SQL Insights  blog Introduction to Cloud SQL Insights  codelab Boost your query performance troubleshooting skills with Cloud SQL Insights  blog Introducing Sqlcommenter: An open source ORM auto-instrumentation library  blog Introducing Cloud SQL Insights video Cloud SQL Github site  What’s something cool you’re working on? Gabi is working on several things, including Schema Migrations with CI/CD pipelines. She is always available on Twitter and she offers free office hours! Sound Effects Attribution  “Small Audience Laugh” by Tim Kahn of Freesound.org 

This week on the podcast, <a href="https://twitter.com/markmirch" rel="nofollow" target="_blank">Mark Mirchandani</a> and <a href="https://twitter.com/gabidavila" rel="nofollow" target="_blank">Gabi Ferrara</a> talk with Nimesh Bhagat about Cloud SQL Insights. This powerful tool enables developers to diagnose database issues for faster, smoother performance. Nimesh tells us the inspiration for Cloud SQL Insight’s development and describes its biggest benefits. One of the important aspects of Insights is the ability for developers to gain an application-centric view by allowing them to tag database queries with SQL comments. These tags are aggregated in Insights and give developers a visual of the database queries. Here, developers can see load patterns and use that information to improve database efficiency. Cloud SQL Insights offers managed database analysis that helps developers understand the past and predict the future. Simplifying the journey of database debugging, Nimesh explains, was the goal of creating Cloud SQL Insights. He takes us through the process of using the software, pointing out the improvements Insights makes over the old way. Cloud SQL Insights only launched in January, but it’s already helping numerous clients with their projects. Nimesh describes these real-world uses, including Major League Baseball experience as part of Insights Early Access Program. Nimesh Bhagat Nimesh is a product manager at Google Cloud, he leads Cloud SQL Insights. He has worked across engineering and product roles, building highly available and high performance enterprise infrastructure used by Fortune 500 companies. His passion lies in combining powerful infrastructure with simple user experience so that every business and developer can build software at scale and velocity. Cool things of the week <ul> <li>A new collaboration with Google Cloud <a href="https://blog.twitter.com/engineering/en_us/topics/infrastructure/2018/a-new-collaboration-with-google-cloud.html" rel="nofollow" target="_blank"> blog</a></li> <li>Don’t fear the authentication: Google Drive edition <a href="https://cloud.google.com/blog/topics/developers-practitioners/dont-fear-authentication-google-drive-edition" rel="nofollow" target="_blank"> blog</a></li> </ul> Interview <ul> <li>Cloud SQL Insights <a href="https://cloud.google.com/sql/docs/postgres/insights-overview" rel="nofollow" target="_blank">docs</a></li> <li>Cloud SQL Documentation <a href="https://cloud.google.com/sql/docs/postgres" rel="nofollow" target="_blank">docs</a></li> <li>GCP Podcast Episode 163: Cloud SQL with Amy Krishnamohan <a href="https://www.gcppodcast.com/post/episode-163-cloud-sql-with-amy-krishnamohan/" rel="nofollow" target="_blank"> podcast</a></li> <li>Google Cloud Monitoring <a href="https://cloud.google.com/monitoring" rel="nofollow" target="_blank">site</a></li> <li>Database observability for developers: introducing Cloud SQL Insights <a href="https://cloud.google.com/blog/products/databases/get-ahead-of-database-performance-issues-with-cloud-sql-insights" rel="nofollow" target="_blank"> blog</a></li> <li>Introduction to Cloud SQL Insights <a href="https://codelabs.developers.google.com/codelabs/cloud-sql-insights-intro#0" rel="nofollow" target="_blank"> codelab</a></li> <li>Boost your query performance troubleshooting skills with Cloud SQL Insights <a href="https://cloud.google.com/blog/topics/developers-practitioners/boost-your-query-performance-troubleshooting-skills-cloud-sql-insights" rel="nofollow" target="_blank"> blog</a></li> <li>Introducing Sqlcommenter: An open source ORM auto-instrumentation library <a href="https://cloud.google.com/blog/topics/developers-practitioners/introducing-sqlcommenter-open-source-orm-auto-instrumentation-library" rel="nofollow" target="_blank"> blog</a></li> <li>Introducing Cloud SQL Insights <a href="https://www.youtube.com/watch?v=qN7x3ngwz1o&amp;feature=emb_logo" rel="nofollow" target="_blank">video</a></li> <li>Cloud SQL Github <a href="https://github.com/GoogleCloudPlatform/cloudsql-proxy" rel="nofollow" target="_blank">site</a></li> </ul> What’s something cool you’re working on? Gabi is working on several things, including Schema Migrations with CI/CD pipelines. She is always available on Twitter and she offers free <a href="http://gabi.tips/slots" rel="nofollow" target="_blank">office hours</a>! Sound Effects Attribution <ul> <li>“Small Audience Laugh” by Tim Kahn of <a href="https://Freesound.org" rel="nofollow" target="_blank">Freesound.org</a></li> </ul>

Cloud SQL Insights with Nimesh Bhagat