April 2019 – Meeting

Speaker – Anders Pedersen (view bio)

Session – “Cursors are bad, never use them!”

How many times have you been told this by your senior DBAs or developers? In this session I will explore why I use cursors to solve certain problems. Discuss when they are appropriate, and when they are not.

Register for this meeting

Posted in Meetings | Leave a comment

HRSSUG March 2019 Meeting

This Month’s Speaker :

Speaker: Cameron Snapp

Bio:

Cameron Snapp is a MCSE and PMP certified IT Consultant with over 15 years of database architecture and development experience. He has worked on dozens of Microsoft SQL Server OLTP, Data Warehouse, and Business Intelligence projects. He holds a Computer Science degree from the University of Richmond and a Master’s degree in IT Management from the University of Virginia. Cameron specializes in IT Projects related to data strategy, modeling, integration and reporting.University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Title:

Azure Data Engineering

Abstract:

As Microsoft releases new Azure features, migrating your ETL processes to the cloud is becoming easier all the time, but also more confusing. Understanding the use and connectivity of the different storage and services is more critical than ever. I’ll start with an overview of Azure data components, detail how they can be integrated, and demo the lift and shift of existing SSIS packages to Azure. I’ll also demo some dynamic ways to program Data Factory and the features of the brand new Data Factory Data Flow! Throughout, we’ll discuss best practices for different Azure centric data migration strategies and explore the benefits of adopting an ELT approach.

Posted in Meetings | Leave a comment

February 2019 – Meeting

Speaker – Andrew J. Kelly (view bio)

Session – Getting your Daily Debrief

We will walk thru the code and process to automate the collection of several key aspects of your SQL Server instance that you should be aware of each day. This will include parsing the SQL Server Error logs, extracting key DDL / Audit events and finding the top offending SQL statements. The automation will include scheduled jobs that use standard TSQL, Extended events and PowerShell to gather and extract the necessary information so they can be loaded into tables for easy reporting.

Register for this meeting

Posted in Meetings | Leave a comment

HRSSUG January 2019 Meeting

This Month’s Speaker :

Speaker: Joseph D’Antoni

Principal Consultant, Denny Cherry and Associate

Bio:

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Title:

Automagic Tuning – SQL Server 2017 and Beyond

Abstract:

Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2017 takes that power a few steps further. Have you ever:• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish? Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.

Posted in Meetings | Leave a comment

HRSSUG December 2018 Meeting

Map to Gordon Biersch

Register for this meeting

4561 Virginia Beach Blvd, Virginia Beach, VA 23462

Posted in Meetings | Leave a comment