• October CASSUG Monthly Meeting

    Datto

    Our October speaker is Tracy Boggiano! She will present her topic titled "Intro to Query Store." In this session, we will look at the new Query Store feature in SQL Server 2016, 2017, and 2019. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016. Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues. In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019. About Tracy: Tracy Boggiano is a Senior Database Administrator for FM:Systems. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as a MCSE Data Platform. She has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council. Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.

    3
  • September CASSUG Monthly Meeting

    Datto

    Our September speaker is our own Greg Moore! He will do his presentation titled: "Pocket-sized Server: SQL Server for under $200!" With a growing focus on large data solutions that span terabytes and use dozens of CPUs and vast amounts of memory, sometimes the smaller solutions are overlooked, especially when considering the Internet of Things where often you may want data collection close to the data you're collecting. At the other end of the spectrum there's an amazing amount of power available in very small form-factors. This session will explore what can be done with cheap off the shelf "computers on a board" form factors and Linux to build cheap and easy to deploy small SQL solutions that can be useful for a variety of data collection activities. About Greg: Greg Moore is a graduate of RPI. There, he majored in CompSci, but probably spent as much time hiking, canoeing, caving and rock-climbing as he did studying. He started working with SQL Server 4.21a in 1995 and has survived numerous upgrades. He's been a Director and later VP of IT at several startups including PowerOne Media, TownNews and Traffiq and now consults. These days, when he's not busy with playing with SQL Server or spending time with his family, he can often be found underground caving or teaching cave rescue with the NCRC. While his focus is on the operations side of DBA, his interests include DR, performance and general IT problem solving. He is the author of: IT Disaster Response: Lessons Learned in the Field. Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.

  • August CASSUG Monthly Meeting

    Datto

    Our August guest speaker is Matt Cushing! He will do his presentation: "Networking 101: Getting Ready for a SQL Event!" Looking to get the most out of your SQL Saturday, PASS Summit, or local user group meeting? Plan ahead! Events aren't just about learning new things, they're about meeting new people, networking with peers, and learning different approaches to common issues. In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer. About Matt: Matt started out his career in Accounting and quickly realized he liked data a whole lot more! Starting as a help desk associate, he's moved through support, development, data, and management positions before settling back to his passion for data. Currently working for Applegate Farms in NJ, he loves the people he works with and for, and the company as a whole. Thanks to the input and help from the SQL community, he was able to be ready for the right opportunity in his current position as a BI developer. He also teaches a Database Management class at Rutgers University. Ask him about the Red Sox sometime if you want your ear talked off ;). Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.

    1
  • NY Tech Loop Night at the Ballpark

    Joseph L. Bruno Stadium

    Our friends at NY Tech Loop are hosting a night at the ballpark! Come out to Joe Bruno Stadium on August 6 as the Tri-City ValleyCats (Houston Astros affiliate) take on the Lowell Spinners (Boston Red Sox affiliate)! Theme night: the office (TV Comedy) Including Office trivia and between innings Office Olympics When: Tuesday August 6th 7pm Joseph L. Bruno Stadium (HVCC) Visit www.tcvalleycats.com/groupticketportal Search for NY Tech Loop, and enter password 'techloop' to purchase discounted tickets. (Premium $9, Reserved, $7, Grandstand $4.50) Buy them for your company and show your spirit or offer it to your employees for them and their families.

  • SQL Saturday Albany 2019

    University at Albany

    SQL Saturday is a free technical training event that draws speakers, sponsors, and attendees from around the world to enrich our local and regional community. Topics will vary from database administration, data science, analytics, data security, application development, and more! For more information, to register for the event, or to submit a presentation, go to https://www.sqlsaturday.com/855/EventHome.aspx If you are with a business or organization interested in sponsoring SQL Saturday Albany, you may sign up here: https://www.sqlsaturday.com/855/Sponsors/SponsorSignup.aspx

    4
  • July CASSUG Monthly Meeting

    Datto

    We will have lightning talks for our July monthly meeting! We will post details about each lightning talk as we receive them! Lightning talk topics include: Terese Cavaggioni: "Engineers New Favorite Child JSON Wants to Live In Your Database: My Thoughts and Complaints" Ray Kim: "Business cards: the most important networking tool" Ed Pollack: TBD Interested in doing a lightning talk for July? Email us at [masked]! Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.

    3
  • Modern Migration Tour

    Hampton Inn & Suites Albany-East Greenbush

    Description End of support for SQL Server 2008 is almost here (ends in July!), which means it’s time to take flight on your migration strategy. But, do you have a plan in place? What approach should you take to ensure a smooth transition? To guide you through these questions, PASS, Microsoft, and Intel® have teamed up for a series of expert-led events, giving you all the tools you need to get to the final destination—a modern data platform. Not only will you receive insightful views on migration, but you’ll also walk away with an actionable plan for the year ahead. What can you expect from this FREE local event? -Networking and training from peers and experts -Access to purpose-built training developed by engineers at Microsoft and -Intel -Lots of fun and cool swag! -Breakfast and lunch will be provided (dietary requests should contact the event organizer). REGISTRATION: https://www.eventbrite.com/e/modern-migration-tour-2019-new-york-tickets-61811331356 *****You must register on EventBrite to reserve a seat at this event*****

    2
  • June CASSUG Monthly Meeting

    Datto

    Our June guest speaker is Susan Lundberg! She will give her presentation titled: "Why should networking be important to you?" Topics covered: Learn easy tips How to use technology to assist in networking The value of networking About Susan: President Capital Tech Search for 20 years, specializing in IT placements in the greater Capital District. Building strong bonds with companies and candidates. President NY Tech Loop The New York Tech Loop is pivoting its blogs to be more technical and job/opportunity focused in nature. These quick reads will be shared weekly and will give you updates on the software-related events happening in the Capital Region. Please sign up by visiting www.nytechloop.org and clicking on the “Get Looped In” button. Also, please follow us on social media for updates @nytechloop. (We respect your privacy. Your email will not be shared.) Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.

    3
  • May CASSUG Monthly Meeting

    Datto

    Our May guest speaker is Mike Jones! He will do his presentation titled: "Using Pure ActiveCluster for SQL High Availability"! Topics will include: * Intro to Pure Storage * Why FlashArray is a strong platform for SQL Server * SQL Anywhere and Pure ActiveCluster About Mike: Mike came to the Capital District in 1978 to attend RPI, leaving in 1983 with a math degree to take a job as a software developer at IBM in Boca Raton. Ten years later, he'd made his way back to the area with a local consulting firm focused on Unix system administration. He's been in the area ever since doing things ranging from Unix system administration to information security consulting and presales systems engineering for Sun Microsystems, Symantec/Veritas, DellEMC, and is currently a presales engineer covering SLED in upstate NY for Pure Storage. Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.

    1
  • April CASSUG Monthly Meeting

    Datto

    ************************************************************************ IMPORTANT NOTE -- PLEASE READ!!! DATTO/AUTOTASK HAS MOVED!!! We will be meeting at the new location! The new address is 33 Tech Valley Drive. Please do NOT map this address, as online maps are not yet updated, and may not be accurate! Go to our old building (26 Tech Valley Drive) and continue to the end of the road, where the new building is located. We will have signs posted in the new building to direct you to the meeting room. We will continue to refine these instructions as we learn more about our new location! ************************************************************************ Our April guest speaker is Monica Rathbun! She will do her presentation titled Performance Tuning, Getting the Biggest Bang for Your Buck! Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them. About Monica: Monica lives in Virginia and is a Microsoft MVP for Data Platform. She is an MCSE in Data Management and Analytics and has over 15 years of experience working with a wide variety of database platforms with a focus on SQL Server. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. Our meeting schedule is usually as follows: 5:30 PM Food, soft drinks, and networking 6:15 PM Chapter news and announcements 6:20 PM Presentation (topic changes monthly) We usually wrap up between 7:30 PM and 8:00 PM.