- Main Meeting: Build Smart Apps w/ Xamarin, Cognitive Services, and ML.NET
- Database Time Traveling (aka Temporal Tables) - John Goodwin
Database Time Traveling (aka Temporal Tables) Ever wish you could time travel like the movies? Perhaps you can! In this session we will explore the topic of Temporal Tables. The concept allows us to travel through the database at different points in time. We will discuss: * What are Temporal Tables * How they work * Uses of Temporal Tables * Related features and support * Contrast with alternative options John Goodwin is a Principal Software Engineer at Metabolon. Metabolon tests and analyzes metabolites to create new insights into health and science.
- A Crash Course in SQL Server Query Plans
SQL query processing can seem mysterious, but SQL Server gives you many tools to determine what is going on under the hood. One of the most useful tools is the Execution Plan (a.k.a. Query Plan). Find out how to get query plans and the many things they can tell you. We are happy to have Jack Alvrus return as our speaker, who has already helped us learn about unit testing and reflection. Thanks to Vaco for hosting and sponsoring the event! Looking for a new opportunity? Check out what's available: https://jobs.vaco.com/
- Fake Your Database
Some of the scariest code to test can sometimes be your database dependency. Rather than let that stop you, let’s walk through some powerful ways to fake your database dependency to quickly and efficiently test code next to it. We will as a group: * Implement what is shown * Provide reasonings about the strategy of using fakes * Explain the in’s and out’s of one fake library https://github.com/jhgoodwin/FakeDbProvider * Provide discrete examples of how fakes can be leveraged in automated testing. Prerequisites to upgrade from listener to workshop participant: * Laptop with latest .NET Core SDK available installed: https://dotnet.microsoft.com/download * An editor, such as Visual Studio Code, Rider, or Visual Studio 2017/2019 * Working WIFI - room will have guest internet available. Food: Will be provided, likely will be Subway Speaker: John Goodwin John Goodwin is a Principal Software Engineer at Metabolon. Metabolon tests and analyzes metabolites to create new insights into health and science.
- Main Meeting: MVVM and MVU in Practice
- Mass Transit with RabbitMQ
Trialcard's Sr. Applications Architect Nick Randal will be the speaker. Topic: MassTransit w/ RabbitMQ An introduction to using MassTransit with RabbitMQ as the underlying infrastructure. Examples of some common patterns and some discussion of best practices with some issues to watch out for. 5150 McCrimmon Pkwy, Suite 411 Morrisville, NC 27560 Directions: From Durham: I-40 East Take exit 284A for Airport Blvd W (0.3 mi) Use any lane to turn right onto Airport Blvd (1.0 mi) Turn right onto McCrimmon Parkway (0.1 mi) Turn right (144 ft) Turn right (16 ft) *Destination will be on the left From Raleigh: I-40 West Take exit 284 for Airport Blvd toward RDU Int’l Airport (0.2 mi) Use any lane to turn left onto Airport Blvd (1.3 mi) Turn right onto McCrimmon Parkway (0.1 mi) Turn right (144 ft) Turn right (16 ft) *Destination will be on the left
- GitHub Essentials
This year at Vaco, we have discussed beginner-level Git topics, as well as advanced-level Git topics. Now it's time to discuss GitHub. Come learn the essential skills for interacting with GitHub. Learn the GitHub workflow, pull request best practices as well as commonly used GitHub tooling. We are happy to have Thomas Wiest return as our speaker, who has already helped us learn about advanced-level Git usage. Thanks to Vaco for hosting and sponsoring the event! Looking for a new opportunity? Check out what's available: https://jobs.vaco.com/
- Precompiled Azure Functions
In this presentation I will be covering how to create precompiled Azure Functions in Visual Studio and how to configure continuous integration and deployment pipelines. I will also be covering some concepts and design patterns that are important when working with serverless functions in production. The example Azure Functions in this presentation will expand on previous talks about hosting static websites, and how to add functionality to your static site. Presented by Adam Vincent I am a Software Engineer at Applied Information Sciences (AIS) and relatively new to the game with 3 years of experience in C# and the .NET stack. I am an advocate for Clean Code, Humane Code and other variants of developing software that is structured not only to meet the requirements of the user, but also software that can be read and maintained because the code clearly communicates the intent of the code. Food will be provided.
- Main Meeting: Better Background Tasks using Serverless Functions and SignalR
Web applications commonly need to run background tasks. The problem is that we want to run them outside of the web application while still providing feedback about their execution. Using a combination of serverless functions for processing and SignalR for communication, we can build web applications that can reliably run complex tasks while still providing real-time feedback to the user. This session will introduce both serverless functions and SignalR, and we will show how you can create a simple framework for your background tasks to use in all cloud providers. Speaker: Chris Dix Chris Dix is the CEO and Chief Developer at Thoughtpost. Chris has over 20 years of software development experience and has partnered with several MSPs to develop custom Connectwise integrations. A former Microsoft MVP, Chris has contributed to books and articles and spoken at many national industry conferences. At Thoughtpost, Chris leads the development of their messaging platform for MSPs, which provides deep integration support for Connectwise, Slack, and Microsoft Teams. Special thanks to our July sponsor: Gravity IT Resources "Gravity IT Resources is a talent centric, referral driven and culture focused IT staffing firm. Our programs and methodology are designed in the spirit of the sharing economy to meet the needs of both IT talent and discriminating clients that need IT talent to deliver results." Meeting Agenda: 5:30-6:00 - Welcome/Food 6:00-6:15 - Announcements 6:15-8:00 - Presentation
- SQL Server Standard Candles: Slow Queries vs. Fast Queries
SQL Server is Microsoft's flagship relational database product. It is powerful, popular, and battle-tested. It can store and query billions of rows of data without breaking a sweat. But sometimes we write a query, and it ends up being slow. What's going on here? In this presentation we will discuss query performance. We will get into the weeds here and there, but not so deep as to get lost. This is meant to be a presentation that gives practical tips for query performance improvement; it will not be a course on the implementation details of SQL Server itself. Here is a list of topics that will be briefly covered: How data is stored and accessed Data type storage sizes How data table design affects query performance How index design affects query performance How query design affects query performance Determining query performance when a stopwatch is not available Predicting optimal query performance Identifying queries that are already at or near peak performance We will not be covering: Hardware/File/OS performance improvement techniques Advanced T-SQL scripting Table/Query hints Concurrency Calling into SQL Server from other languages This presentation will exclusively cover SQL Server. No .NET language experience is required. This means everyone interested in SQL Server query performance is welcome, regardless of preferred programming language! Presenter: Derick Linkous