• Monthly Meeting A Dive into the System Databases

    Infotec of Virginia

    This session will delve into details of the system databases. These are created when the system is installed and then DBAs pretty much forget about them. If you ask, they might have an idea of what their use is, but the truth is, they're sort of a black box to many. This session will cover how and when to back them up, how to move them if necessary and how to take advantage of that "model" database that seems to just sort of sit there. This Month's Speaker : Speaker: Greg Moore Bio: I am an RPI graduate who has worked in IT for over 20 years. For the first 8 years or so I did straight consulting in the upstate NY area with some trips to other parts of the country for my clients. In 1997 I started working for a local start-up company just as the first dot-com bubble was getting started. While there I worked with some great people and some great teams to build one of the best service providers for newspapers in the country. I honed my skills on working with SQL Server using replication, log-shipping and clustering to deliver the up-time demands of our customers. From there I moved on to a 4.5 year stint for another start-up called Traffiq. While based in NYC, I worked in the Virginia office and commuted most weeks from upstate NY down to the NYC office and the Virginia office. Again, I had the pleasure of working with some great people. Since August of 2011, I have been working on several new projects of my own, including QuiCR. When I’m not busy in front of the computer, you may find me watching spending time with my family, watching NCIS, hiking or crawling through a hole in the ground. Yes, I’m a caver (please, caver, not spelunker). I work with the NCRC (National Cave Rescue Commission) as an instructor and as the database coordinator. One of my projects in the last year was making our training database available online to authorized personnel. In addition to caving and computing, I like to muse on various topics such as how people think about problems, face certain dangers and react in various situations. Please feel free to comment and give me feedback or even point me to various topics you think might interest me. I’m always up for a good read.

  • Monthly Mtg Is My Bias Showing? Real World Implications of App & Machine Bias

    Computers can't be biased, right? I mean, it's just lines of code. Yes or No. Ones & Zeros. Those lines of code are written by people. People have life experiences that color how they see the world. Let's be blunt. People have baggage. And that baggage is seeping into your application, surveys and web forms. You've got an idea for a new app and it's going to change the world! Right? It's a brilliant idea & no one has ever thought of it before. You're working on the GUI for your company's web portal and you know just what information to collect from the user. Are you sure about that? Odds are pretty good that the information you're going to collect is a reflection of your life & your experiences. Learn how to identify bias when it seeps in, how to code to be inclusive instead of exclusive, and some quick tips & tricks to make sure you're accounting for all the users that will use YOUR application to change the world. Instead of just the ones that look like you. This Month's Speaker : Speaker: Rie Irish Bio: Rie Irish has been working with SQL Server since 1999, starting as a data analyst for a non-profit. She's worked in many industries over the years including pharmaceutical, e-commerce, legal, financial, education and both federal & state government. Most recently, she was director of database management, Integrated Payments for WorldPay, Inc. She is currently Senior Program Manager, MVP, Community & Data engineering with Microsoft. She is based out of Redmond, but works remotely from her home in Atlanta. Over the years, Rie has done extensive work with the SQL Community. She's been an MVP in the Data Platform for three years, speaking frequently at conferences across the US and moderating webinars, WIT panels and career panels. Next month, she'll be delivering the keynote for Atlanta Code Camp on Coding for Diversity & Inclusion and in December, she's presenting "How to Build a Disaster Recovery Plan" for the DBA Fundamentals Virtual Group. She's served on the program committee for PASS Summit, volunteered in various roles at the conference and host a Women in Tech Happy Hour leading up the conference. For the last three years, Rie served as Executive Director of SQL Saturday Atlanta & helps run the Atlanta SQL Saturday User Group. She is also co-leader of the PASS Women in Technology Virtual Group which highlights & showcases the great things women are doing in the data platform.

  • Monthly Meeting Managing In-Memory OLTP - A DBA Field Guide

    In-Memory OLTP can provide a significant performance boost to a range of workloads where lock contention, logging, and disk-based page structures limit query performance. In this session, we will explore the technology behind memory-optimized tables, what workloads will achieve the greatest performance gains, and highlight critical issues in implementing and managing SQL Server instances and databases containing in-memory objects. This Month's Speaker : Speaker: Justin Randall Bio: Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQL Saturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.

  • Monthly Meeting Top 5 Tips to Keep Always On AGs Always Humming and Users Happy

    Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet. This Month's Speaker : Speaker: Matt Gordon Bio: Matt is a Microsoft Data Platform MVP and has worked with SQL Server versions from 2000 up to and including SQL Server 2019. He is the leader of the Lexington, KY chapter of PASS, a frequent SQL Saturday and user group speaker, and speaker at PASS Summit 2017 and 2018. He's also been named an IDERA ACE and 2019 Friend of Redgate. His original data professional role was as a database developer, but that quickly evolved into query tuning work which further evolved into being a full-fledged DBA in the healthcare realm. He has supported critical systems utilizing SQL Server across multiple data centers and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes those years of real world experience as a national Microsoft data platform consultant helping clients design deployment solutions that meet their ever-changing business needs.

  • Monthly Meeting 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. This Month's Speaker : Speaker: Monica Rathbun Bio: Monica lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. 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.You can find Monica blogging at sqlespresso.com

  • SQL Saturday Virginia Beach Meetup

    ECPI University

    The Hampton Roads SQL Server User Group is are very excited to be hosting our very first SQL Saturday here in Virginia Beach. Join us for a FREE day of Data Platform and SQL Server training for all levels. Admittance to this event is free, however we do charge $12 for lunch & refreshments (fees are non-refundable). Please register soon as seating is limited, and let friends and colleagues know about the event. YOU MUST REGISTER FOR EVENT USING THIS LINK ONLY https://www.sqlsaturday.com/839/EventHome.aspx Event Overview Think of a SQLSaturday as a one-day free conference, linked to a network of similar conferences around the world, on six continents. We attract intelligent, volunteer speakers from around the United States, provide free lunch on site, and we have a dedicated exhibitor area set up for our attendees to meet with our sponsors. We work diligently to make our event a great experience for everyone, especially our sponsors who enable us to cover the working costs of this event. The event is attended by SQL Server engineers, developers, managers, and other IT professionals who attend topics of a wide range of technologies and soft skills. There will be high-quality technical sessions on not just SQL Server, but also .NET, SharePoint, Windows Server, PowerShell, mobile app development, project management, IT leadership and more. Consider SQLSaturday Virginia Beach your one-stop shop for recruiting, corporate marketing, IT staff training and continuing education. Who Attends SQLSaturday Virginia Beach? Folks with the following skillsets are drawn to SQLSaturday Virginia Beach because of the professional networking, free training, and giveaways: • SQL Server Administrators • Business Intelligence Developers • Data Analysts • ETL Developers • C#/VB.NET Developers • Mobile Developers • SharePoint Architects • SharePoint Developers • Network Administrators • Quality Assurance Analysts • IT Managers and CIO’s • Project Managers • Students What Sponsorship Opportunities Are Available? We offer a wide variety of sponsorship packages, which enable us to provide the one-day educational conference free to attendees. That’s right – unlike similar events, SQLSaturday Virginia Beach is completely free to attend – attendees receive the lunch, cold drinks, snacks or goodie bags all free of charge. A quick breakdown of our 2019 sponsorship levels. • Blog Sponsorship - $25 • Bronze Sponsorship - $300 • Silver Sponsorship - $600 • Gold Sponsorship - $1000

  • SQL Saturday VA Beach PRE CON- Intelligent Data Integration through SSIS

    SQL Saturday Pre Con - Core Level Practical Performance Monitoring ALL DAY w/ Senior Technical Subject Matter Expert Andrew Kelly Intelligent Data Integration through SSIS with Andy Leonard About this Event What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data Integration Lifecycle Management), produced using Biml (Business Intelligence Markup Language) and executed using an SSIS Framework. Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years (and delivered). Attendees will learn: - a holistic approach to data integration design. - a methodology for enterprise data integration that spans development through operational support. - how automation changes everything. Including data integration with SSIS. Topics include: 1. SSIS Design Patterns 2. Executing SSIS in the Enterprise 3. Custom SSIS Execution Frameworks 4. DevOps and SSIS 5. Biml, Biml Frameworks, and Tools Prerequisites: Familiarity with SQL Server Integration Services (SSIS). About Speaker Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS Trainer, Consultant, and developer, a Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks - A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page. He may be followed on Twitter @AndyLeonard. REGISTER USING THIS LINK ONLY (Copy and paste in your browser) http://bit.ly/SQLSatVASSISBIMLPreCon2019 Save $25 by registering BEFORE May 1st

  • SQL Saturday VA Beach PRE CON- Core Level Practical Performance Monitoring

    SQL Saturday Pre Con - Core Level Practical Performance Monitoring ALL DAY w/ Senior Technical Subject Matter Expert Andrew Kelly At some point in time every DBA struggles with the concepts and implementation of a proper performance monitoring strategy. This pre-con will cover the fundamental techniques and code snippets that will help you get to the bottom of who or what may be causing you problems. At the end of the day you will feel much more confident that you have the tools and the knowledge to start implementing a fundamental performance monitoring strategy that will work well for your environment. All the demo’s are based on actual code and techniques that anyone can use to obtain these goals. We will also cover the key aspects of SQL Server that you need to be aware of to make the right decisions regarding performance. • Learn the core aspects of SQL Server that require monitoring • Learn how to properly capture the required performance metrics • Learn how to analyze and understand the metrics to maximize your time and reduce your effort About Speaker Andrew Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Waynesboro, VA. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and has been a SQL Server / Data Platform MVP since 2001. REGISTER USING THIS LINK ONLY (Copy and paste in your browser) https://bit.ly/2TLqkle Save $25 by registering BEFORE April 1st

  • SQL Saturday VA Beach PRE-CON Managing & Architecting Azure Data Platform

    SQL Saturday VA Beach PRE CON Managing and Architecting Azure Data Platform ALL DAY w/ Microsoft Data Platform MVP John Morehouse About this Event In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier. You will learn about building IaaS solutions to support SQL Server as well as managing Platform as a Service offerings like Azure SQL Database. Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime. As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations About Speaker John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. John lead the Omaha SQL Server user group for 7 years and is now a leader of the Louisville SQL Server/Power BI user group. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. He has a passion around performance tuning, database life cycle management, database administration, disaster recovery, high availability, Azure and security. He is a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. In his spare time, you can usually find John on Twitter (@sqlrus) as well as chasing his two young sons around the house. REGISTER ONLY BY USING THIS LINK (Copy and paste in your browser) https://bit.ly/2SpYpCM Save $25 by doing do BEFORE April 1st

  • Monthly Meeting SQL Server Machine Learning Services in Production

    Writing code which uses SQL Server Machine Learning Services is easy enough, but that is just the beginning of the story. In this talk, we will cover the rest of the R development story for database administrators. We will look at the methods available to install and maintain R packages, learn good practices for deploying and maintaining custom SQL Server Machine Learning Services code, and learn where to find critical information when things break. These battle-tested tips will make it easier for you to integrate R and SQL Server Machine Learning Services in your existing deployment processes and get the most out of this feature. This Month's Speaker : Speaker: Kevin Feasel Bio: Kevin Feasel is a Microsoft Data Platform MVP and Engineering Manager of the Predictive Analytics team at ChannelAdvisor, where he specializes in T-SQL and R development, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com) and author of PolyBase Revealed (forthcoming). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.