talk-data.com

Greetings, data enthusiasts!

Our May meeting is scheduled for Monday, May 12th, 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. This is a ROUNDTABLE meeting, therefore the schedule, topics, and presentations will be shorter, more casual and ad-hoc. Dinner will be pizza ordered from the venerable DeFazio's!

Our meeting schedule is as follows:

5:30 PM: Food, soft drinks, and networking 6:15 PM: Chapter news and announcements 6:30 PM: Presentation We will wrap up between 7:30 PM and 8:00 PM.

This month's meeting is a CASSUG Roundtable! Bring your own topics and we will discuss and try to solve them! Some ideas on what makes a successful roundtable:

Questions Discussions Conundrums Challenges Personal victories Code sharing Job search status/requests

While there will not be a formal speaker for this meeting, having an agenda makes things move more smoothly. If you have anything to present, discuss, or ask and know in advance, please message me or reply to this event and I will create a rough agenda of what we will tackle! As a bonus, this allows us to prepare a bit more and look up some resources ahead of time.

Details on topics, proposals, and requests will be added closer to the meeting date. Feel free to bring your own content or ideas to share, as this is a casual/relaxed meeting.

Greetings, data enthusiasts!

Our May meeting is scheduled for Monday, May 13th, 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/297656972/ if you are attending, so we can purchase an appropriate amount of food for everyone. Food for this month will be pizza from the venerable DeFazio's! As always, we'll order a wide assortment of toppings, ranging from cheese to some unusual stuff :-)

Our meeting schedule is as follows:

• 5:30 PM: Food, soft drinks, and networking
• 6:15 PM: Chapter news and announcements
• 6:30 PM: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

This month, Andy Levy will be joining us in-person all the way from Rochester, NY to present: Answering the Auditor's Call with Automation.

As data professionals, we are called on regularly to produce documentation for security & compliance audits. Being able to show who has what level of access to an instance is the minimum, but we're often asked for more. Collecting this information and compiling it into something usable by auditors could take you hours or even days. But with automation, you can pull it all together in a matter of minutes while you're getting that second cup of coffee from the kitchen.

Through the PowerShell demos presented in this session, you'll learn how to build documentation of your backup regimen, who has access to your databases, and show that you're staying current with SQL Server patches from Microsoft. Whether you have one SQL Server instance or one hundred, you'll be able to create a script to automatically format this data so that it's usable for your auditors - and hopefully be so complete that you don't receive follow-up questions.

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:

• 5:30 PM: Food, soft drinks, and networking
• 6:15 PM: Chapter news and announcements
• 6:30 PM: Presentation

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.