Ciò che siamo
As SQL PASS ceased all operations effective January 15, 2021, this is the new platform for the previous PASS DBA virtual group.
The DBA Virtual Group aims to provide a global online platform for the DBA community. It provides a forum for open discussion and education on issues Microsoft database administrators face.
If you have any questions, comments, suggestions, or feedback about the group, please drop us a line at [email protected].
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.
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.
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 is 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 [email protected] as soon as possible.
DBAVUG reserves the right to bar any person who violates our Code of Conduct from attending the DBAVUG event in entirety or part, and/or to cancel tickets of any person.
Prossimi eventi (4)
Visualizza tutto- Discover SQL Server index prescriptions for the biggest performance improvementsLink visibile ai partecipanti
WHEN:
Wednesday, January 22, 2025, 1900 GMTDESCRIPTION of TALK
Title: Go Faster Sooner! Discover SQL Server index prescriptions for the biggest performance improvements
Your SQL Server wants to go faster - and it knows where it needs help! All you've got to do is ask. What makes this approach different? You'll learn different kinds of index pain and why they affect query performance. And how pain can identify the the quickest and biggest improvements. You don't have to address every index on every table to see improvement - just start with the ones in the most pain and watch your queries run faster!
89 SQL system views combine to create nearly 500 diagnostics and over 100 detailed index prescriptions to make your queries perform. All results are presented in Excel, highlighting the pains and detailing prescriptions for each table and index. From there leverage Excel's analytic powers to slice and dice your way through all that data! You no longer have to find, download, and run a bunch of scripts, glue results together, scroll through columns looking for patterns, and guess how and where to get started. It's all in there!
Prerequisites: Basic understanding of SQL Server index types
Session Goals:
- Identify when index tuning is the fastest way to the performance finish line
- Measure index pain and affect on query performance
- Prioritize & prescribe detailed index-level improvement actions
- Explore hundreds of diagnostics to gain further insights into your indexes
- Review index and table metadata & visually scrutinize performance metricsAll code can be found at https://github.com/SQLXL/SQLXL
