I’m presenting at All Day DevOps
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
I’m super excited to present From Oops to Ops: Incident Response with Jupyter Notebooks on Oct 28, 2021. While I have presented this topic before for data professionals, this session at All Day DevOps (ADDO) 2021 will cover the broader Site Reliability Engineer audience. In case you would like to follow along the slides and the session notes, you can find them on my GitHub repo: Slide Deck Session Notes From Oops to Ops: Incident Response with Jupyter Notebooks Abstract: What if you can apply software engineering practices to your troubleshooting guides (TSGs) / knowledge base for your team ..read more
Visit website
“You have to be technical” and its relevance
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
Since a large number of people in my network are either looking for new opportunities or hiring today, I think it’s time for me to share this for you to internalize[1]. I’ve held off this post for a few years as I was still in the process of making sense of it. Hope this is useful for you who are in the job market. The phrase “You have to be technical” was directed at me during an interview a few years ago while I already had a decade of consulting projects in Data and implemented one of the largest Business Analytics solutions on the planet. This is not an imposter syndrome blog post. Here’s ..read more
Visit website
Automating SQL & PowerShell notebook execution
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
When I first think about automation, I generally think in the following way: in order to automate a script, we want to ensure that the script itself can be run via a command line interface (CLI) and with almost no user interaction (except for input and output parameters). Now, how do we apply this to Jupyter Notebooks so that we can automate SQL notebooks or PowerShell Notebooks? The good news is that these SQL notebooks and PowerShell notebooks that we’ve created using Azure Data Studio, can be run on PowerShell CLI. If these notebooks can be run on PowerShell CLI, that means any automation s ..read more
Visit website
Improved large Jupyter Notebook loading time in Azure Data Studio
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
I’m super excited when I got this latest bit from the Engineering team in Azure Data Studio a couple of days ago. So I thought, let’s blog this! Some of you may have tried loading a very large notebook in Azure Data Studio that takes a log time to load. Sometimes it might say that the application is not responding, do you want to keep waiting or just exit it all together. Thank you for your feedback that we receive during various presentations and on GitHub. Here’s the good news! The Azure Data Studio team is working on this and we have something for you to try. The improvement is down from mi ..read more
Visit website
Analyzing your Azure serverless app performance stored in Application Insights using Kqlmagic
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
Lately, I’ve been playing around a bit with Serverless Architecture using Azure. This weekend, I thought it’d be great to play around with Azure Function a little bit. It turns out when you create an Azure Function resource, it automatically collects log data in Application Insights (AppInsights). Check out getting started Azure Function. This means that we can use KQL and create custom queries to analyze the log data using Kqlmagic in Jupyter Notebooks in Azure Data Studio. See an example of Kqlmagic notebook connecting to AppInsights on my GitHub. The notebook analyzes response times, perfor ..read more
Visit website
Incident Response with Jupyter Notebooks for the DBAs – join me at SQL Port on Jul 21, 2021
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
I’m super excited to be speaking at SQLPort on Jul 21, 2021 at 18:15 (WEST / GMT +1) on “Incident Response with Jupyter Notebooks for the DBAs”. CXXVII Encontro da Comunidade SQLPort with Julie Koesmarno | Meetup If you are using Azure SQL or SQL Server today, you’ll learn how to create a Jupyter Notebook for diagnostic use cases and schedule it for automation in this session. If you’re new to Azure Log Analytics / Azure Monitor Log / Azure Logic Apps / Azure Automation and curious how this can be put together, this session would be great for you also. Auto diagnostic on Azure SQL with Jupyter ..read more
Visit website
Join us as a UX focused Program Manager!
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
Great news! My manager Vicky Harp ( b | t | l ) is hiring a UX focused Program Manager for Tools and Experiences team within Azure Data at Microsoft. The job description also includes where you can apply directly. My team is looking to hire a PM with a love for accessible design to work on the SQL experiences team, focusing on the Azure SQL portal. We welcome applicants who are committed to growing a psychologically safe and inclusive team. https://t.co/jw4dGLfLO9 — Vicky Harp (@vickyharp) June 22, 2021 Excerpt from the job description: The Tools and Experiences team within Azure SQL focus ..read more
Visit website
From Oops to Ops: Incident Response with Notebooks
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
Earlier today May 18, 2021, Shafiq Rahman and I presented From Oops to Ops: Incident Response with Jupyter Notebooks virtually at Techorama Belgium. In this one hour session, we covered the following: What if you can apply software engineering practices to your troubleshooting guides (TSGs) / playbook / runbook for your team’s on-call? What if you can reduce stress and mistakes in your incident response workflow? Join this session to learn more about TSG Ops framework, where we revolutionize how Database Administrators and Data Engineers can be more effective and feel empowered during incident ..read more
Visit website
Jupyter Notebook helps me become a better learner!
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
This month’s T-SQL Tuesday is being hosted by Steve Jones (b|t). The topic is using Jupyter Notebook every day. As Steve describes it, “I want you to write about how you have used, or would like to use, a Jupyter notebook“. This is a super cool topic! Yes, I’m a PM working on Jupyter Notebook in Azure Data Studio along with my peers; and we can’t wait to see people’s posts on this. Since I’m late in submitting , I thought it’d still be OK for me to share how I’ve used Jupyter Notebook recently and generally. The question is, what do I do everyday? Learn! So this blog post ..read more
Visit website
Adding Relative Links Easily in Notebooks
MsSQLGirl
by Julie (@MsSQLGirl)
1y ago
As you enrich your collection of notebooks (organized in a Jupyter Book, hopefully), you will likely want to link from one notebook to another notebook in the directory you are working on. If you are familiar with markdown, you know that this process can be painful as you’d need to know where the target link is located and where it is located in relation to the notebook that you want to link from. Luckily in Azure Data Studio v1.27.0, there is a new Insert Link button in the Text Cell that does the automatic translation “hard coded path” to “relative path” link. Check this out ..read more
Visit website

Follow MsSQLGirl on Feedspot

Continue with Google
OR