- VTSQL UG: Power BI Paginated Reports
Description: Power BI paginated reports are optimized for printing, or PDF generation. They provide you with an ability to produce highly formatted, pixel-perfect layouts. In this presentation, you'll learn how to: * Design paginated reports * Retrieve report data * Parameterize reports * Publish and consume paginated reports * Choose the right report type About the speaker: Peter Myers is a consultant, trainer and presenter from Melbourne, Australia. He has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services. He has a broad business background supported by a bachelor's degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007. Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/879123533 Join from a video-conferencing room or system. Dial in or type:[masked] or inroomlink.goto.com Meeting ID:[masked] Or dial directly:[masked]@[masked] or[masked]##[masked] New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/879123533
- VTSQL UG: Enterprise Scaling with Advanced SQL Server Features (ONLINE)
Title: Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features Level: 300 Abstract: You have an OLTP database application which sustains a heavy mixed workload with lots of read and write transactions at the same time that it reports data to a client application. Performance was fine for a long time, but it is not meeting your needs now that it must scale to much higher workloads. What should you do? In this real-world case study, you’ll learn about a series of technologies that provide unprecedented scalability, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. We will walk you through a chronology of the application and database architecture, its changes over time, and the degree of performance improvement achieved with each new SQL Server feature applied. This session will teach you all about planning and implementing advanced SQL Server performance features and how each one impacts your system performance for applications with 100’s or 1000’s of concurrent users. Here’s what you’ll learn in this session: • Goal 1: Learn how to plan, prepare for, and implement advanced features on SQL Servers, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. • Goal 2: See the performance impact of each of the major feature implementations as they relieve performance bottlenecks. • Goal 3: Learn about the trade-offs in applying major new features, tips and tricks, and other advice for achieving enterprise scale in your SQL Server applications. Prerequisites: Intermediate experience with Microsoft SQL Server administration, application architecture, and SSMS. About the speaker: Kevin Kline is a noted database expert and software industry veteran currently serving as the Principal Program Manager at SentryOne, a leading vendor of database tools. A Microsoft Data Platform MVP since 2003, Kevin was a founding board member and former president of the Professional Association for SQL Server. He has authored more than ten books, including the best-selling SQL in a Nutshell. Kevin contributes a monthly column to Database Trends magazine. Kevin is a top-rated speaker on technology and professional development topics at conferences worldwide such as Microsoft Ignite/TechEd, the PASS Summit, DevTeach, Oracle OpenWorld, and IT/Dev Connections. He tweets at @kekline and blogs at http://KevinEKline.com. ------------ We will have a raffle for a $50 gift certificate to a local restaurant, courtesy of SentryOne. ------------ Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/884822485 Join from a video-conferencing room or system. Dial in or type:[masked] or inroomlink.goto.com Meeting ID:[masked] Or dial directly:[masked]@[masked] or[masked]##[masked] New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/884822485
- VTSQL UG: SQL Server Blocking and Locking (ONLINE)
Description: How to detect, analyze and minimize SQL Server Blocking and Locking. The goals of this session are to learn the good, the bad, and the ugly of blocking; to discover what is the difference between locking, blocking and deadlocking; to understand how to minimize blocking during OLTP operations, batch processing, bulk inserts, and large scale deletes, to study how to use the appropriate isolation levels to reduce/increase blocking and partitioning and blocking. Discover what Snapshot and Read Committed Snapshot Isolation levels are all about and when you should use them. Understand how to monitor locking and blocking. Learn about In Memory Tables. Learn how to monitor and troubleshoot blocking processes. About the speaker: SQL Server MVP Hilary Cotter is a 24+ year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has worked on some of the largest and challenging SQL Server topologies in the world. He has been a SQL Server MVP for 14 years now. He has worked on some of the more complex replication deployments in the world. Event info: Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/494063517 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) United States: +1 (872)[masked] - One-touch: tel:[masked],,[masked]# Access Code:[masked] Join from a video-conferencing room or system. Dial in or type:[masked] or inroomlink.goto.com Meeting ID:[masked] Or dial directly:[masked]@[masked] or[masked]##[masked] New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/494063517
- BTV Testers: An Evening of Lightning Talks
BTV Testers is back, with an evening of lightning talks and new presenters! Come join us for an informal evening of three presentations that will each be roughly 20 minutes, plus time for questions. Bethany Robinson will be presenting "Using TestSphere to Enhance Your Testing." Allison Lazarz will be talking about "Ensuring Quality the Easy Way with the Story Impact Checklist." And Molly Roy Yanus will be presenting as well. Topic TBD. We are still looking for one more presenter to serve as an alternate or go at the end if there is time. Presentations can be on a wide variety of testing / QA related topics. Please contact Brie Hoblin (@bhoblin on twitter) if you are interested in presenting. ************************* Whether you are a QA professional, a software dev interested in writing quality code, or someone just learning to code, come join us to learn more about Quality Assurance! Last but not least, thank you to our generous sponsors: VCET, Dealer.com, Symbiotic Labs, Union Street Media, and people like you! If you would like to support our meetup and others like it, please visit https://opencollective.com/burlington-code/ to learn more.
- VTSQL: New features in SQL Server Management Studio, Performance Troubleshooting
C2 - Competitive Computing
Title: New features in SQL Server Management Studio — Performance Troubleshooting made easier! Description: SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, which enabled rapid enhancement to the Execution Plan. Do you know that now you can see how many pages are spilled to disk for a sort, as well as the memory statistics for sort operator? Are you aware that you can see the top 10 waits for single execution and what trace flags were active during compilation, including the scope of the trace flags? Have you ever analyzed a big plan and wish you could search for the table name, index name, or column name without opening the XML plan? When you see an index used, do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows? In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier, and ready to tackle those nasty, hard to solve query plans. About the speaker: Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. During his last 13 years, he has worked with SQL Server and MongoDB platform both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays, and Azure conferences.
- DevOps: AWS Cloud Computing Open Forum
AWS Cloud Computing Open Forum: A short presentation on cloud computing followed by a discussion of services and resources in AWS. Please come with your questions about cloud computing and AWS - what would you like to know? Speaker: Dan Eyer is the founder of Green Mountain Cloud and has been a solutions architect in the AWS cloud space for the last five years. He's enthusiastic about sharing his passion for cloud computing with local organizations and turning the Green Mountain state into Silicow Valley. ---- To find others interested in "devops" topics such as cloud computing, containers, microservices, and more, please join the BTVDev Slack team at http://btvdev-slackin.herokuapp.com/ and then join the "#devops" channel.
- BTVJS Call For Speakers
- Tech Communities Holiday Party and Lightning Talks
Burlington Code (https://burlingtoncode.org/) and the Vermont Tech Alliance (https://www.vermonttechnologyalliance.org/) are co-hosting this event so that we can celebrate the year together as a community! This is a winter "meetup of meetups" and a chance for everyone to connect across technical disciplines and hear about what YOU are doing in our brave little state! There will be 5-minute lightning talks about a variety of technical topics. Pizza/drinks will be sponsored by Burlington Code. There will be a potluck of desserts! Schedule: 6pm-6:30pm - Pizza, non-alcoholic drinks, and networking 6:30pm-7:15pm - Lightning Talks 7:15pm-7:45pm - Break, Potluck desserts! 7:45pm-8:30pm - More Lightning Talks 8:30pm - Head down to Skinny Pancake for more conversation! We want to hear from YOU! Sign up to give a 5-minute lightning talk to tell us about something you learned this year, a project or organization you are building or contributing to, or share your successes (or failures) and what you learned from them. You don't even have to be physically present to present! If you live in another part of the state and want to share something you are doing, sign up and we will schedule your talk and livestream you remotely! Here is the link to sign up: https://forms.gle/w3nvpaRkxxnrZxAj6
- Working with React Hooks
React Hooks pose a very different way of thinking about components than how we've used React in the past. In our previous gathering we discussed the way hooks are used and the details of their syntax, but I think there's more to be said. In this talk I'll go over ways to transition the mental model of class components (implied state and component lifecycle) to the model that hooks provide (functional state and data lifecycle) as well as show how to build custom hooks, which is one of the biggest benefits they provide. Speaker: Payton Swick Thank you to our generous sponsors: Dealer.com, Symbiotic Labs, Union Street Media, and people like you! If you would like to support our Meetup and others like it, please visit https://opencollective.com/burlington-code/ to learn more.