HRSSUG March 2020 Meeting

This Month’s Speaker :

Speaker: Jamie Wick

Title: Monthly Meeting Designing Integrating On-Prem Data with Azure Apps

Abstract

Azure applications (PowerBI, Power Apps, Flow & Machine Learning, etc) can greatly enhance business processes. Most organizations, however, have already invested in on-premises infrastructure for storing their data (database & file servers). The problem therefore is: How can you use on-prem data sources with cloud-based (Azure) applications?
In this session we will look at using an Azure On-Premises Data Gateway to integrate local (on-prem) data sources with Azure-based applications.

Bio:

Jamie Wick is the Systems & Database Engineer for The College of William & Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer

Posted in Meetings, Uncategorized | Leave a comment

HRSSUG February 2020 Meeting

This Month’s Speaker :

Speaker: John Morehouse

Title: Monthly Meeting Designing Azure Data Disaster Recovery Strategies

Abstract

In an on-premises world many organizations did not have the option of multiple data centers or were limited in what that they could protect from disaster. Moving to the cloud evolves many technologies—disaster recovery being one of the most prominent ones. It can be quick and easy to protect your application in multiple regions worldwide. For any critical application disaster recovery should be at the forefront of your planning. The cloud does not change this. In the event of a regional outage, you still need to meet your recovery objectives. If you aren’t prepared for this failure, the downtime could be costly. In this session we will examine the ways to help protect your Azure Data footprint from outages. You will learn about strategies with Azure SQL Databases, virtual machines, and Managed Instances as well as how to protect your application tier. At the end of the session you’ll have a better understanding on how to ensure your data in the cloud is protected from failure.

Bio:

John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate, Sentry One PAC member & Community Ambassador. John has a passion around speaking, teaching technical topics and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, https://sqlrus.com.

Posted in Meetings, Uncategorized | Leave a comment

HRSSUG January 2020 Meeting

This Month’s Speaker :

Speaker: Andy Leonard

Title:  SSAS Tabular – Azure DevOps and the SSIS Development Lifecycle

Abstract

Data Integration Lifecycle Management – or DILM – is challenging regardless of your chosen data integration platform.
The primary goal of this session is an explanation – via demonstration – of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps – from initial development, through testing, to production.

Bio:

Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, 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.

Posted in Meetings | Leave a comment

December 2019 – Meeting

Gordon Biersch Brewery Restaurant
4561 Virginia Beach Boulevard
Virginia Beach, VA 23462

Wed, December 18, 2019 — 6:00 PM – 8:00 PM EST

Register for this meeting

Posted in Meetings | Leave a comment

HRSSUG November 2019 Meeting

This Month’s Speaker :

Speaker: Bryan Hundley

Title:SSAS Tabular – Scratching the Surface

Abstract

Data Warehouses are nothing new, and easy enough to come by. However, the expertise needed to query one efficiently and analyze the data within accurately can still be rare. How do you deliver the contents of a complex, yet high-performing data warehouse to your non-technical business users? Enter SQL Server Analysis Services. SSAS can allow for the various valid relationships in your data warehouse to be pre-processed for your end users so they only need to choose which fields to slice and dice by, and which measures they wish to see. The Tabular mode of SSAS is supported by the VertiPaq engine, which is also the underlying engine for Excel PowerPivot and Power BI. During this talk, we’ll briefly review the differences between setting up your data model in each of those products, along with the pros and cons of each and how to determine which solution is best for you.

Bio:

Bryan is a Senior Consultant and Team Lead with Marathon Consulting, LLC in Virginia Beach, VA. He is a 20 year veteran in the IT industry, specializing in the Data Platform space for the past 10 years, and is an active member of the local SQL Server and Power BI user groups. Recently, he has focused on designing data warehouses and business intelligence processes for multiple clients.

Posted in Meetings | Leave a comment