Monitoring SQL Server without breaking the bank & I ain't a Data Scientist - Why do I need Jupyter Notebooks?
Monitoring SQL Server can become a very expensive business. Sure, the market offers countless paid solutions, but what if you have a large server estate and your budget is tight?
In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, dbatools and many more) to collect important performance metrics, analyze the data they collect, set up alerts for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
Jupyter Notebooks were once the realm of Data Scientists. New releases of Azure Data Studio, Visual Studio Code, and .NET interactive tooling have brought this tooling into the Operational team’s area. The biggest benefit of using Jupyter Notebooks is that you have your documentation, your code __and__ your results in the same source controllable document.
I will share with you all of the knowledge I have gained over the past 12 months implementing Jupyter Notebooks for Data Operation teams.
You will leave
– with a good understanding of possible use cases for Jupyter Notebooks
– being comfortable in using the different tooling
– with many examples that you can take back to work and start being effective immediately
Enabling collaboration with your team, simplifying common tasks, improving Incident Wash-Up meetings, creating run-books, easily creating code for others to use are some of the benefits that you will take away.
We will have fun as well.
Prerequisites: Working in an operational team supporting Data Platform systems.
Lack of pogonophobia!
Willingness to learn
We will use Azure Data Studio
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and US. He is currently working as lead DBA at a famous Formula 1 team.
Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP and a Data Platform MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.
He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.
He has a fabulous beard
|18u30||Welcome and introductions|
|18u45||Monitoring SQL Server without breaking the bank (60 minutes)|
|20u00||I ain’t a Data Scientist – Why do I need Jupyter Notebooks? (60 minutes)|
In between sessions, there’ll be a 15 minute break.