- "Is My Server Suffering From Memory Pressure?" with David Bland
Please join us for David Bland's presentation on "Is My Server suffering from Memory Pressure?" on August 7th at 5:30 PM. "As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure. During this session we will explore how SQL Server uses memory and how to properly configure memory settings. We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions." David and his insights can be followed here: Twitter: https://twitter.com/SQLDave29 Blog: http://davebland.com/ A little bit about David: "Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQL Saturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL." Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics Join online via Twitch: https://www.twitch.tv/fox_pass Details, resources, and links are also on https://fox.pass.org/default.aspx Thank you!
- FoxPass Timber Rattlers Social
Please join us July 17th for our social gathering at the Timber Rattlers Stadium. For the month of July, we wanted to have a social gathering for our members to get together and see what others might be working on or get some insight into newer technologies. Location: Fox Cities Stadium (2400 N Casaloma Dr, Appleton, WI 54913) Time: 6:30 PM Area: Grid 3 Map of stadium: http://www.milb.com/content/page.jsp?ymd=20081027&content_id=41061574&sid=t572&vkey=team2 Food and drink: --A few items from the the FoxPass leadership team will be provided, however BYOB and food to contribute --2 gas grills and 1 charcoal grill Link to purchase Timber Rattlers tickets : https://tr1.glitnirticketing.com/trticket/web/stadiumg.php?status_id=2&event_id=99&tfl=timber_rattlers-tickets-na-single_game_tickets-x0-unknown-unknown
- What Else Can Indexes Do?
Please join us for the presentation on June 5th at Secura Insurance (East Building) where we will have special guest Erik Darling from Erik Darling Data. (Erik will be remote for this session) Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's had some terribly boring DBA jobs, and been a consultant for Some Guy You've Never Heard Of™(Brent Ozar). He enjoys public arguments with optimizer and wine photography. You can find out more on his official website: https://erikdarlingdata.com/ A little bit about the discussion: "Lots of sessions about indexes give you technical, but not practical information. It's not that the information is bad, it's just that you can't take it and apply it to your problems. In this session, we're gonna dive deep into how queries use indexes, and the warning signs you'll see when you have a problem indexing can solve. We're going to be looking at query plan stuff like memory grants, spools, and lookups. We're also going to look at how indexes can give you a leg up on locking. And best of all, you'll learn how to stop worrying about fragmentation and start fixing real problems."
- Tracking Data Transformations Using Temporal Tables
Please join us for the presentation on May 1st at the Secura Insurance (East Building) where we will have special guest Thomas M. Lane, PhD from Talavant. Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies. A little bit about Thomas's discussion: "Along with change tracking and change data capture, Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables. Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature. A temporal table truly introduces two tables into the mix: one for current data and another for historical data. This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing."
- SQL Server Management Studio Tips and Tricks
Please join us for the presentation on April 3rd at the Secura Insurance (East Building) where we will have special guest Gary D. Schultz from West Bend Mutual Insurance. Gary is a production DBA and Systems Engineer for West Bend Mutual Insurance (TheSilverLining.com). He is one of the chapter leaders for WISSUG and in his spare time, sings in the house band for WBMI, is learning guitar and bass for his church band, and serves on the board of Citizen Advocates of Washington County (CAwash.org – Our mission is to bring life-enriching relationships to people living with disabilities). A little bit about Gary's discussion: "Work smarter, not harder. Increase your productivity in coding and management of SQL server by understanding some of the “hidden” gems in SSMS, Visual Studio and Powershell IDE’s. Knowing just a few basic regular expressions could save you a lot of effort and there are some very useful extensions cost nothing to implement. There are also some newer features in the latest SSMS that you may not have had time to investigate. This talk will be one long demo, which will hopefully have something for every level of SQL server user or developer."
- Deconstructing Power BI
Please join us for the presentation on March 6th at the Secura Insurance (East Building) where we will have special guest Seth Bauer from Concurrency, Inc. Seth is a Microsoft Data Platform MVP (Power BI). He has been working with the Microsoft Enterprise Data stack for over 10 yrs, but his major focus area now is Power BI, and sharing what he’s learned with the User Community. He is a Microsoft Certified Professional, a co-leader of a Microsoft Power BI User Group, and a PUG Board of Advisors member. He enjoys implementing BI / Power BI solutions. A little bit about Seth's discussion: "Do you know Power BI? More often than not, the vast majority say yes when they've only begun to scratch the surface. This session will delve into the underlying structures of Power BI and raise your awareness of all the different components that you are using. Mixed in will be a slew of tips related to things to avoid and how to make the best choices for optimal performance."
- Real-time Analytics with Azure
Please join us for the presentation on February 6th at the Secura Insurance (East Building) where we will have special guest Jordan Anderson discussing "Real-time Analytics with Azure". A little bit about Jordan's discussion: "Ever wanted to analyze data as it happens? Azure provides an impressive suite of services to enable real-time analytics. We begin our session with an overview of real-time analytics and its role in business today, then we dive into streaming data architecture on Azure, followed by a demo where we build a fully-functional streaming data pipeline with Azure Stream Analytics and present insights in real-time with Power BI." You can also join the meeting through Skype: https://meet.lync.com/talavant/turner.kunkel/YZW691ZH
- "Azure Data Factory Ingestion Framework" with Sean Forgatch
Please join us for the presentation on January 9th at the Secura Insurance (East Building) where we will have special guest and former President of Fox Valley Microsoft Data Platform Users Group Sean Forgatch discussing "Azure Data Factory Ingestion Framework". A description of the talk: "In this session we will discuss Data Strategy around data lake ingestion and how that shapes the design of a framework to fuel Azure Data Factory. This session will take you through the development of a Metadata database designed using Data Vault modeling, the collection of the metadata, as well as building a fully automated Data Factory pipeline." You can also join the meeting through Skype: https://meet.lync.com/talavant/turner.kunkel/PR37CPPN
- "Locking and its effects on queries and maintenance tasks" with Jacob Manske
Please join us for the presentation on December 5th at the Skyline Technologies Garage where we will have special guest Jacob Manske discussing "Locking and its effects on queries and maintenance tasks". A description of the talk: "Multi-user systems are affected by how SQL Server locks resources to manage concurrent transactions. Understanding how SQL Server uses locks to isolate transactions from one another is important for both writing code and running maintenance tasks. In this session, we will discuss lock modes in SQL Server and how they impact your queries. We will show how different isolation levels change which locks are taken and for how long they are held. We will look at ways to avoid unnecessary blocking for maintenance tasks like index rebuilds. Assertions will be backed up with demo-based evidence. After this session, you will have the understanding you need to start writing application code and maintenance jobs suitable for concurrent systems by anticipating blocking issues due to locking." You can also join the meeting through Skype found here: https://meet.lync.com/talavant/turner.kunkel/FH36QQNC Thank you!
- FoxPass (ByPASS Summit) Social
Can't make it to Summit? Fox Valley Microsoft Data Platform would like to welcome you to our November event! Please join us at Beefeaters British Grille for some food, networking, and trivia. Light appetizers will be provided. Drinks and extra food are separately available for purchase. Schedule of the night: 5:45: A short FoxPass update presentation. 6:45: Tech Trivia. The event is free, but limited to 30 attendees. We hope to see you there! Please contact [masked] with any questions or comments. Thank you.