- RMC Agency Annual Summer BBQ / Cornhole Tournament Fundraiser
From Adrienne Moulton, RMC Agency:: I wanted to spread the word of RMC’s Annual BBQ in June. Returning for its 2nd year, we are doing a Cornhole Tournament Fundraiser to support Military Veterans and we are extending an invitation to the whole local Tech community to join us! BBQ buffet and beverages are included for Fundraiser participants. The Cornhole Tournament is a win and advance style play. Donation to play is $30 per team ($15 per person). It will be a lot of fun so the more the merrier! Grab a Cornhole partner and join us! Here is the link to our EventBrite to RSVP & register your team for Cornhole: https://rmc_bbq_cornholetournament_2019.eventbrite.com Hope to see you there!!
- Getting Started with Git/GitHub
**Note: this will be a remote presentation** ***Also, while this is not strictly a SQL Server topic, it should be of interest to anybody that needs to deal with source control, which is everybody!*** Abstract: If you manage code, you understand the struggle of choosing how you source control it. While there are many choices out there, Git has become a popular option for many development teams. While it has many strengths, understanding Git can be a struggle for developers who are not used to distributed source control. In this session, we will go over the basic concepts of Git, from building and cloning a repository to branching, forking, and code merges. We will use real world examples of how Git and GitHub can be used to manage global development teams. Attendees will leave with a solid understanding of how Git works, how to get started with their own GitHub repository, and some tools that can be used to manage their code. Speaker Bio: Mike Fal is a thought leader in database architecture and data management, leveraging my 15+ years of database administration, technology experience, and community activity to help companies develop first class data solutions. Specialties: Database architecture, automation, monitoring, performance troubleshooting, SQL Server, Powershell, cloud data technologies, NoSQL/non-relational data systems
- GLASS May Social
For May, the Greater Lansing Area for SQL Server will be holding a "social" at Lansing Brewing Company. No scheduled speaker, topics, or sponsor, just joining fellow SQL Server geeks to enjoy some delicious drinks and food while discussing anything to do with SQL Server, or not! No hard scheduled start time, though I will probably be there around 5:30 PM on Tuesday, May 14. Feel free to drop in and say hi!
- GLASS April 2019 - “Black Arts” Index Maintenance #3 – “Defragmented by Default”
Michigan High School Athletic Association
Abstract: “Black Arts” Index Maintenance #3 – “Defragmented by Default” Microsoft made many wonderful changes to SQL Server with the release of SQL Server 2005, especially when it comes to querying LOBs (MAX, XML, and other large data-types). They also made a not-so-well advertised change that seriously affects the way that LOBs are handled and stored by default. Most people don’t even know this change occurred and, for those that do, most are unaware of the ramifications and rather extreme collateral damage this seemingly innocuous change has caused. 1. Non-Lob (which is most of our queries) Clustered Index Queries run twice as slow and require two orders of magnitude more memory to do so. 2. Rampant “bad” page splits, which can lead to serious blocking. 3. Permanent and perpetual fragmentation of Clustered Indexes. 4. Increased data storage requirements. 5. Increased and totally unnecessary Index Maintenance. 6. Increased log file activity, which also affects query performance, backup storage requirements, and increased backup and restore times. Fixing any one of those problems would be a big help. In this session, SQL Server MVP Veteran (and official Godfather of GLASS) Jeff Moden shows us how and why the change causes all of these problems and then demonstrates how two simple changes to our tables fix it all. He also demonstrates how the same techniques can be used to make some non-LOB tables “Defragmented by Default”. Speaker Bio: With more than 48,000 posts and 3 dozen mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the "Tally Table" a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is "Performance is in the code".
- GLASS March 2019 - Exploring Why UDFs & Nested Views Hinder the Query Optimizer
Michigan High School Athletic Association
Abstract: Exploring Why UDFs & Nested Views Hinder the Query Optimizer Ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views? Did you know that object-oriented code reuse can significantly hinder the Query Optimizer? In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tool that will aid you in unraveling nested code. Speaker Bio: Andy Yun Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.
- Azure Data Studio – Cross-Platform Development and Operations Database Tool
Michigan High School Athletic Association
BE SURE TO READ TO THE END FOR OUR NEW LOCATION INFORMATION!!! Abstract: Azure Data Studio (formerly SQL Operations Studio) is the modern, cross-platform database management tool for SQL Server, both on-premise and in the cloud. A simple, clean approach to a UI creates an experience different from other SQL management tools today. Fully integrated intellisense with customizable code-snippets, connection management, and dashboards, Azure Data Studio, provides the T-SQL editor experience most of us expect today. Unlike other tools, Azure Data Studio is 100% open-source, easily extensible, and has full integration to modern source control solutions like GIT. In this session, we introduce Azure Data Studio, get comfortable with the editor and interacting with SQL Server environments. We will focus on productivity comparable to SQL Management Studio, shortcuts and time savers, as well as how to leverage source control. Lastly, we will cover extending Azure Data Studio by setting up a development environment, and walking through the process of build and debugging a custom dashboard component, using Electron, Node.js, and VSCode. Bio: Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member. ATTENTION!!! WE HAVE A NEW HOME! New Horizons Computer Learning Centers has generously hosted our user group for nearly four years at their Reo Town location, but due to changes in how they provide their services (on-site and online), keeping a physical presence here just didn't make sense. I can't thank them enough for their generosity over the years, without them our group wouldn't have been the success it has become! And if not for that success, we may have never found our new home! The Michigan High School Athletic Association has generously offered to host our user group going forward! Located just off of Coolidge Road on Ramblewood Drive (Near US-127 and Lake Lansing Road), it's truly a convenient location. You will see a sign for "MSHAA" at the corner of Coolidge and Ramblewood. If Google tries to take you to a drive with "Michigan Surgical Associates" and "LOEYE Care" instead, it's wrong. It will put you in a parking lot physically "near" the MSHAA location, but you'll have to hike through a swampy creek area. Just turn onto Ramblewood and follow to the end of the street.
- GLASS January 2019 Meetup - Are you ready for the Cloud?
New Horizons Computer Learning Centers of Lansing, MI
Abstract: Are you ready for the Cloud? Moving to the cloud sounds so simple. But, there are several areas of the business to consider outside of the pure technical aspects. This presentation will touch upon several other business departments that will need to be engaged and ready to adopt this change as well. Speaker: Greg Cook is a BI Professional with over 10 years experience utilizing the Microsoft BI stack. He has been involved in several BI environments across a variety of different industries. He has presented at past conferences on a variety of topics from business intelligence to process improvement and process automation.
- GLASS Winter Social
For December, the Greater Lansing Area for SQL Server will be holding a "social" at Lansing Brewing Company. No scheduled speaker, topics, or sponsor, just joining fellow SQL Server geeks to enjoy some delicious drinks and food while discussing anything to do with SQL Server, or not! No hard scheduled start time, though I will probably be there around 5:30 PM on Tuesday, December 11. Feel free to drop in and say hi!
- PASS Summit 2018 Recap
PASS (Professional Association for SQL Server) held its annual Summit the week of November 5 that I just returned from. For this month's meeting I'm hoping to go over some of what I picked up from the week and share some of the swag I picked up from the vendors (I hope you like rubber ducks). I have reached out to some of the other people from the area that I know attended to see if they will be available to talk this night as well. If nothing else I should be able to find plenty to fill the time!
- The "Black Arts" of Index Maintenance
Abstract: The "Black Arts" of Index Maintenance Note: this will be a 2 hour session! Most people don’t know it but the current “Best Practice” Methods are actually the leading cause of perpetual logical and physical fragmentation, costly and continuous “Bad” page splits, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, the whole reason for why we have to do so much index maintenance. This isn’t your typical presentation on Index Maintenance. In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code. In this second of two back-to-back sessions, we’ll learn of several incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad” page splits, reduce wasted memory, make your log file and log file backups a whole lot more happy, and increase the overall performance of even perfect code. We’ll also learn that no simple method is a panacea, what to do about the horror of "expAnsive" updates, and how to make even GUID-keyed indexes work well. Speaker: Jeff Moden With more than 48,000 posts and 3 dozen mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the "Tally Table" a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is "Performance is in the code".