What we're about
Upcoming events (2)
Since databases became common with ERP systems over 20 years ago, developers could always say trust that whatever else happened, they would always have SQL. But now, that’s not the case. With the advent of SaaS in general and Cloud-Based Business Central in particular, life isn’t so simple. You now need to know about things like “ODATA and “APIs”. In this presentation, we’ll explain how these new approaches work. We’ll review the basics of JSON and RestAPIs and show you how you can do (almost) everything you need with PowerShell. We’ll even show you how to load this data into SQL Server (if you really want to.) Bio Adam Jacobson is founder and president of Red Three Consulting. He has over 20 years of experience in ERP and BI consulting. Adam has particular expertise in complex accounting and other multi-company and international reporting challenges. Technically, he focuses on Microsoft Technologies like SQL Server (including SSRS and SSAS Tabular) and PowerShell. Prior to founding Red Three, Adam was a partner in United Systems Consultants where he ran its 30-person Lawson software practice.
Jupyter Notebooks allow you mix documentation, code, and the output together in one file. They can show you how to set things up and prove that it worked. Imagine taking all of your documentation, all of your runbooks, all of your OneNote files, and making those code samples executable. Now your IT processes are repeatable, shareable, and editable. Finally, you can go on vacation. Traditionally notebooks have been used for training, but you can do much more than that! Some emerging trends Jupyter notebooks are being used for are: Troubleshooting Guides, Workflow Steps, Collaboration, & Operationalization. Now you can turn manual checks into automated jobs that save the result. This session will cover some examples for environment setup, collaboration, troubleshooting, and operationalization scenarios. Before this session is over, you’ll be able to start building Notebooks to use in your own environment BIO Aaron Nelson is an award-winning author, public speaker, blogger, & leader in the SQL Server community. He has over 20 years of experience in architecture, business intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is an eight-time winner of the Microsoft MVP Award. Aaron helps lead the PowerShell Virtual Group of PASS, helps run the GroupBy virtual conference, and is a volunteer at his local PASS chapter, AtlantaMDF.