What we're about

As SQL PASS ceased all operations effective January 15, 2021, this is the new platform for the previous PASS DBA virtual group.

As we retool and rebuild, we will keep you in the loop on all of the advancements and notifications for future events. Thank you for your understanding, and we look forward to rebuilding this great community with you in 2021.

The goal of the DBA Virtual Group is to provide a global online platform for the DBA community. It provides a forum for open discussion and education on issues that face SQL database administrators.

If you have any questions, comments, suggestions, or feedback about the group please drop us a line at dbavug@outlook.com.

The Virtual Group Leaders have overall responsibility for the activities of the virtual group. This person coordinates the activities of the Group Admins in meeting planning.

Interested in Presenting at the DBA Virtual Group?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract, and a brief bio to DBA VUG Leadership Team (dbavug@outlook.com).

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to DBA VUG Leadership Team (dbavug@outlook.com).

Code of Conduct

Database Professionals Virtual Meetup Group supports the diversity of our community. We strive to welcome different perspectives in a community where everyone feels respected and valued, and are committed to inclusion across race, gender, gender identity and expression, sexual orientation, age, ability, geography, religion, identity, and experience. Above all, we ask that all DBAVUG members be kind to one another and conduct themselves respectfully, creating a positive experience for everyone involved.

• Conduct yourself with integrity, respect, honesty, and credibility.

• Approach all events and interactions in accordance with the highest ethical standards of professionalism and personal conduct.

• Embrace the diverse community of professionals and learners, and be inclusive of all audiences in your presentations, demonstrations, conversations, and comments.

If you are subject to unacceptable behavior, notice that someone else is being subject to unacceptable behavior, or have concerns that this Code of Conduct is not being followed, notify us at DBAVUG@outlook.com as soon as possible.

DBAVUG reserves the right to bar any person who violates our Code of Conduct from attending DBAVUG event in entirety or in part, and/or to cancel tickets of any person.

Upcoming events (4+)

Principles of architecting a cloud data migration ~ Surbhi Pokharna

Link visible for attendees

WHEN:

Wednesday, December 14th, 2022, 1700 GMT

DESCRIPTION of TALK

Title: Principles of architecting a cloud data migration

Is your company planning to move your on-prem, hosted application to cloud? Have you been asked to assess your on-prem data workload and design the new castle in the cloud?

Designing the new castle is an important aspect but also it is more important to live happily in that castle once you migrate to the cloud. That’s where the art of architecting the operationalization aspect comes into play.

In this demo centric session, we will understand the fundamental building blocks of migrating on-prem SQL server workload to cloud via lift and shift or to Azure SQL/Managed Instance. We will build our hierarchy of needs checklist, a secured data migration plan and perform a sample migration to IaaS and PaaS Azure SQL databases keeping Data Security, Size, Performance, and Cost aspects in mind. By the end of this session, you will have a good idea on how to execute a secured and scalable cloud data migration solution in IaaS and PaaS.

ABOUT THE SPEAKER

Surbhi is a data professional with over two decades of architectural/administration experience in the financial domain. She has led global teams, managed enterprise-scale, highly-available environments with deep attention on resiliency, data security, and performance tuning.

She has in-depth expertise in Azure IaaS, PaaS large scale cloud data migrations, building best practices, optimizing and operationalizing data solutions in SQL Server, Azure SQL, Managed Instance and Snowflake.

Optimizing Backup Performance using Data Science Techniques ~ Kevin Feasel

Link visible for attendees

WHEN:

Wednesday, January 11, 2023, 1700 GMT

DESCRIPTION of TALK

Recent updates to the DBA’s toolbox

One of the most important tasks for a database administrator is taking (and testing!) backups. As databases get larger and larger, the amount of time it takes to perform a backup can grow as well, to the point where your backups take longer than your available backup window. There are several settings we can use to optimize backup performance, such as buffer counts, maximum transfer size, and the number of files, but trying every combination of settings on a single production-sized database could take weeks or even months. In this talk, we will apply data science techniques to the problem of backup settings optimization and look at different models for approaching the problem and analyzing data. Some statistics background would be helpful, but is not required; the big requirement is a desire to speed up backups.

ABOUT THE SPEAKERS

Kevin Feasel is a Microsoft Data Platform MVP and CTO at FareGame Inc, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

MS SQL New functions, syntaxes, tips & tricks - SQl 2022 ~ Damir Matešić

Link visible for attendees

WHEN:

Wednesday, January 25, 2023, 2000 GMT

DESCRIPTION of TALK

Title: MS SQL New functions, syntaxes, tips & tricks - SQl 2022

In this session we will see what bring us some newly introduced MS SQL functions. Accompanied with multiple examples, this session will show you many interesting topics from SQL 2016 to 2022.

ABOUT THE SPEAKER

For many years Damir is a passionate programmer and a Microsoft SQL Server developer (ver. 2000+). He is a certificated Microsoft professional on various technologies. He leads the Croatian SQL Server User Group and he introduced SQL Saturday Event in Croatia. He organizes various Data Platform events in Croatia. Founder and organizer of #DataWeekender. #DataWeekender is a popup online conference, organized by a group of European based Microsoft data platform professionals. Originally created as a response to Covid-19, this is now a regular online event. He is currently working as Senior Database Developer @Span.eu. Damir speaks on various community events, conferences and user groups. When free he blogs about SQL @ https://blog.matesic.info.

Cosmos Db for SQL Server DBAs ~ Warner Chaves

Link visible for attendees

WHEN:

Wednesday, February 8, 2023, 1700 GMT

DESCRIPTION of TALK

Title: Cosmos Db for SQL Server DBAs

Cosmos Db is Azure's NoSQL Database as a Service, born in the cloud and designed take advantage of the flexibility, elasticity and global reach of cloud computing.

Cosmos offers different access APIs, consistency models and performance management models that are different from a classic relational database like SQL Server. However, the same principles that you already apply as a SQL Dba are as important as ever to build a Cosmos application that performs well, is cost efficient and resilient to failures.

In this session we will explore the fundamental concepts behind Cosmos Db, how it compares to SQL Server and perform demos to understand Cosmos Db's behavior with a live workload.

ABOUT THE SPEAKER

Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of multi-platform consultants and engineers.

Past events (42)

Using the TSQL OUTPUT Clause ~ Steve Stedman

Needs a location

Photos (13)

Find us also at