Tech Video Notes

https://www.pluralsight.com/courses/dot-net-6-application-performance-measuring-monitoring by Ivan Gavryliuk Module 1: Course Overview Course Overview Module 2: Basic Principles of Performance Monitoring Introduction Why Monitoring Monitoring is "Process of analyzing, evaluating, and interpreting data results from a measured parameter withing a specified time to verify conformity" monitoring framework became part of .net starting in .net 6 When Not to Care About Performance Performance optimization must be driven by business needs Any work on performance optimization should never be premature or happen before it's needed designing code for performance makes it more complicated and less maintainable. What to Monitor basic metrics: CPU, memory, disk and internet traffic you don't need to monitor these in .net, it is done by the OS What's Available tracing vs logging: tracing is for understanding program flow and investigative performance tracing: logs many events, p...

https://www.pluralsight.com/courses/building-no-code-apps-appsheet-foundations-5 by Google Cloud  Module 1: Introduction Course Introduction Module 2: AppSheet Overview Module Overview History of apps debut of iPhone in 2007 and its impact on apps requires software and programming skills Fundamentals of no-code app development definition: "The process of developing apps without writing any code" develop apps faster and cheaper develop apps 10 times faster no code vs low-code: no code requires no code at all, whilst low code require some coding strong foundational security protocols  who uses no code: process owners, decision makers, end users What is AppSheet? owned by Google AppSheet use cases Build an asset tracker app to track inventory in real time. Build a variety of front-line and customer experience apps. Build customized apps tailored to your HR needs. Demo 3 ways to start an app: start with your own data start with an idea start with a sample app you can build an...

https://app.pluralsight.com/library/courses/implementing-scrum-azure-devops/table-of-contents by Benjamin Day Module 1: Course Overview Course Overview Module 2: Scrum Overview Introduction Scrum Framework Overview - definition: “A process for delivering done, working software in 30 days or less” - scrum was first presented in 1995 by Ken Schwaber and Jeff Sutherland - you can become certified in scrum - scrum roles: project manager, developers, scrum master  - scrum events: the sprint, sprint planning, daily scrum, sprint review, sprint retrospective Definition of Done Definition of done should be documented  Definition of done should be clear and shared with everyone Without it, you are creating technical debt It is not just code compiles and has been checked in. Definition of done should include QA testing and deployment to production  PBIS Should Be Completed to Done in One Sprint pbis should be small enough to be completed in one sprint. the entire tea...

https://app.pluralsight.com/library/courses/troubleshooting-first-low-performing-t-sql-query/table-of-contents by Jared Westover Module 1: Course Overview Course Overview Module 2: Asking Questions about a Query Introduction What Is Low-performing? Developer Expectations - This course uses the WiredBrainCoffee database - shows how to enable line numbers in SSMS - shows how to refresh IntelliSense local cache   Demo: Setup Your Environment Start With Questions Demo: Ask Questions Breakdown Complex Queries Demo: Common Table Expressions - shows how to convert a derived query into a CTE - performance is about the same but CTE are more readable Demo: Nested CASE Expressions Summary Module 3: Sources of Query Performance Issues Introduction Clicking Execute overview of the execute phase: Parser -> Algebraizer -> Optimizer -> Execution. SQL Server Storage discusses how sql server caches results in pages Return Fewer Pages use where clause and indexes to return fewe...