Capital Area SQL Server User Group

Greetings, data enthusiasts!

Our January meeting is scheduled for Monday, January 8th, 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 Ken Schwartz - a longtime local group member, speaker, and antagonist (in the best way possible)!

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, Ken Schwartz is presenting: Monitoring and Alerting on Database Configuration Changes.

This presentation concerns a reasonably straightforward way to monitor for, and alert on, changes to one or more database configurations.

This is an important, and often overlooked, task, especially if (like me) you happen to be working in an environment where people have permissions to modify settings, even though they are lowly developers.

Greetings, data enthusiasts!

Our February meeting is scheduled for Monday, February 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. Food is TBA (will be announced closer to the event).

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, Tracy Boggiano will be presenting: Migrating to Azure SQL Database: Because Life is Too Short to Manage Your Own Servers

Do you want to migrate to Azure SQL DB and finally get a good night's sleep, without having to worry about your servers misbehaving like a group of rowdy toddlers?

If so, we're tackling a topic near and dear to your hearts. That's where Azure SQL Database comes in - the cloud-based solution that lets us focus on what really matters (you know, living our lives). With its automatic backups, automated patching, and elastic scalability, we can finally say goodbye to the never-ending cycle of server management.

But let's not get too ahead of ourselves - we still need to make the migration and learn how to manage the database. From the initial planning stages to the final cutover, there are plenty of opportunities for things to go wrong. But with a little bit of humor and a lot of caffeine, we can conquer anything that comes our way.

Greetings, data enthusiasts!

Our March meeting is scheduled for Monday, March 11, 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. The jokes will be plentiful and cornier, too :-)

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'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.

Some topics that were mentioned in the Meetup questionnaire include:

• Cloud Databases/Python
• Partitioning
• Maintenance Tasks simplified. Can target partitions.
• Partition elimination.
• Partition trickery: swapping, truncation, MERGE, SPLIT
• Job search
• SQL Server vs. Postgres vs. Others. Where is the best place for MY data?!

I'll prepare something on partitioning, as this is a topic I've spent a lot of time on over the years.

If you have anything to discuss for or in addition to these, please let me know!