talk-data.com
Activities & events
| Title & Speakers | Event |
|---|---|
|
SQL Server Detective: Investigating Logs and Traces for Optimal Performance
2025-10-13 · 18:30
Taiob Ali
– Microsoft MVP
Your role as a DBA is crucial, as a pivotal figure in the realm of Microsoft SQL Server. Your ability to monitor and analyze your server's performance and troubleshoot issues is essential, and it's what keeps the system running smoothly. One of the most effective ways to do this is by utilizing the built-in data collection, which records a wealth of information. This session will delve into six collections (Logs and traces) that can provide valuable insights into your server's configuration, health, and performance. By the end of this session, you will be equipped with practical knowledge that will empower you to handle any SQL Server issue confidently. • Default trace • SQL Error log • SQL Agent Error log • System_health • AlwaysOn_health • Telemetry xEvents I will show you each one's default location, retention, and content captured. We will discuss how to access and interpret these logs and demonstrate how they can be used to identify and diagnose issues such as failed logins and deadlocks, the health of the Windows cluster and availability group, and schema changes. By effectively utilizing the SQL Blackbox, you can ensure the smooth operation of your server and maintain the highest performance and reliability. Prerequisite: Familiarity with SQL Server administration Goals: 1. Know the default location, retention, and content of the six built-in SQL Server logs/collections. 2. Know how information from these collections can be extracted for different troubleshooting scenarios and ensure reliable and highly available database systems. |
October Monthly CASSUG Meeting
|
|
October Monthly CASSUG Meeting
2024-10-14 · 21:30
Greetings, data enthusiasts! Our October meeting is scheduled for Monday, October 14th, at 5:30 pm! We will meet in person at: Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY. Please RSVP at https://www.meetup.com/capital-area-sql-server-user-group/events/299931181/ if you are attending, so we can purchase an appropriate amount of food for everyone. Food is TBA (will be announced closer to the event). For this meeting, we are welcoming Michelle Gutzait and Christian Cote, who are joining us all the way from Montreal! Thank you, Michelle and Christian, for taking the time and energy to join us and share your knowledge! Our meeting schedule is as follows:
We usually wrap up between 7:30 PM and 8:00 PM. Michelle Gutzait and Christian Cote are presenting on a relatively new Microsoft/Azure offering that is a game-changer in the world of analytic data: Fabric from the Ground Up In this presentation, Christian and Michelle will talk about why do we want to use Microsoft Fabric and will explain the Fabric capacity, security and pricing models. They will also discuss the differences between a Lakehouse and a Warehouse, along with example use cases. Lastly, they will demonstrate the options, advantages and limitations of the Power BI Direct Lake access capability. |
October Monthly CASSUG Meeting
|
|
October Monthly CASSUG Meeting
2023-10-09 · 21:30
Greetings, data enthusiasts! Our October meeting is scheduled for Monday, October 9th, at 5:30 pm! We will meet in person at: Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY. Please RSVP if you are attending, so we can purchase an appropriate amount of food for everyone. Food is TBA (will be announced closer to the event). We are welcoming Deb from out-of-town to speak at CASSUG, so please thank her for taking a long drive to be here with us! Our meeting schedule is as follows:
We usually wrap up between 7:30 PM and 8:00 PM. This month, Deb Melkin is sharing this introductory presentation: Beyond the Basic SELECT The SELECT statement is one of the most used tools in our SQL toolbelt. While it’s the basis for what we do with data, it’s anything but basic. In this presentation, we will first explore how SELECT statements are processed. Then we will discuss various ways we build on to our SELECTs. We'll also examine how and why we may or may not want to use them. At the end of the session, we will have a greater understanding of how SELECTS work and how we can approach them so we can be smarter as we write more complex statements. While this is a beginner-level session, feel free to bring your own experiences to the table to share before/during/after the presentation. |
October Monthly CASSUG Meeting
|