Hampton Roads Sql Server User Group (HRSSUG)

Session: Practical Application of Storytelling Techniques in Power BI

Speaker: Meagan Longoria

In data visualization, we are inundated with the idea that we should be telling a story. But what is a story? And how do you use visual properties and navigation to tell a story? Join Meagan Longoria for this discussion of storytelling in data visualization and demonstration of storytelling techniques.

This will be a virtual meeting. Please register at https://www.meetup.com/Hampton-Roads-SQL-Server-User-Group/events/275175931/

Session: Why You Need Query Store

Speaker: Erin Stellato (Bio)

One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. If you’ve ever had to drop everything to troubleshoot a sudden drop in performance, then this is a feature you want in your environment. In this session we will discuss configuration options and best practices, step through using the built-in reports, and review plan forcing in Query Store. Get ready to make troubleshooting easier with this feature that’s included in Azure SQL and all editions of SQL Server 2016 and higher!

This will be a virtual meeting. Please register at https://attendee.gotowebinar.com/register/1356618539198144783

Session: Matters of Concurrency

Speaker: Louis Davidson (Bio)

OLTP databases can be constantly written to and even reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, and even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits

This will be a virtual meeting. Please register at https://www.meetup.com/Hampton-Roads-SQL-Server-User-Group/events/274077440/

Session: Deploying SQL Server on Kubernetes

Speaker: Anthony Nocentino (bio)

Are you thinking about running SQL Server in Kubernetes and don’t know where to start…are you wondering what you really need to know? If so, then this is the session for you! When deploying SQL Server In Kubernetes key considerations include data persistency, Pod configuration, resource management, and high availability/disaster recovery scenarios. In this session, we’ll look closely at each of these elements and learn how to run SQL Server in Kubernetes. Learning Objectives: Deploying SQL Server in Kubernetes Allocating Persistent Data Storage and configuring advanced disk topologies SQL Server Specific Pod Configuration Near zero-downtime upgrades High availability and Disaster Recovery Scenarios.

This will be a virtual meeting. Please register at https://www.eventbrite.com/e/hampton-roads-sql-server-user-group-oct-meeting-online-tickets-124126787563?ref=enivtefor001&invite=MTk5OTM1Nzkva2hqZW5zZW5Ac2VudGFyYS5jb20vMA%3D%3D%0A&utm_source=eb_email&utm_medium=email&utm_campaign=inviteformalv2&utm_term=attend

Session: Data Types Matter

Speaker: Angela Henry (bio)

They’re just numbers, right? A date’s a date. It’s just string data, who cares? I can’t tell you how many times I’ve heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.

This will be a virtual meeting. Please register at

https://attendee.gotowebinar.com/register/4813347855125010444