May Monthly CASSUG Meeting @CASSUG_Albany #SQLFamily

Greetings, data enthusiasts!

Our May meeting is scheduled for Monday, May 8, at 5:30 pm! We will meet in person at Rensselaer Chamber of Commerce, 90 4th Street, Troy, NY.

For more information and to RSVP, go to our Meetup event page at https://www.meetup.com/capital-area-sql-server-user-group/events/290678891

Our meeting schedule is usually 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.

Thanks to Datto for sponsoring our event!

Our guest speaker for the month is Deexith Reddy!

Topic: Automating Visualizations with Azure Data Factory, SQL Server, and Power BI: Data to Insights

Introduction to Azure Data Factory, SQL Server, and Power BI: Gain an understanding of these three powerful Microsoft technologies and their roles in automating data visualizations.

Data Integration and Transformation: Learn how to leverage Azure Data Factory to ingest and transform data from various sources, then store the processed data in SQL Server for further analysis.

Creating and Automating Power BI Reports: Discover how to create interactive Power BI reports and dashboards using data from SQL Server, and automate the process of updating these visualizations.

Scheduling and Orchestration: Understand how to use Azure Data Factory’s scheduling and orchestration features to automate the entire data pipeline, from data ingestion to visualization updates.

Real-Time Data Processing and Visualization: Explore the possibilities of real-time data processing and visualization using Azure Data Factory, SQL Server, and Power BI, enabling you to monitor and react to changes in your data as they occur.

Security and Compliance: Learn about the built-in security features and best practices for protecting your data and maintaining compliance throughout the automation process.

Best Practices and Tips: Gain valuable insights into best practices for automating data visualizations, including performance optimization, error handling, and maintaining data quality.

Advertisement

May Monthly CASSUG Meeting, May 9

Greetings, data enthusiasts!

Our May meeting will be a hybrid event! We will meet in person at the Rensselaer Chamber of Commerce, 90 4th Street, Troy, and online (the Zoom link can be found on our Meetup event link at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/285622042 )!

Our May speaker is Monica Rathbun!

Topic: Always Encrypted for Beginners
One of the biggest challenges to successful implementation of data encryption has been the back and forth between the application and the database. You have to overcome the obstacle of the application decrypting the data it needs. Microsoft tried to simplify this process when it introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. In this demo intense session, you will learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt. You will also learn about the current limitations of the feature and what your options are to work around them.

For more information and to RSVP, use our Meetup link above! Hope to see you there!

Thanks to Datto for sponsoring our event!

April Monthly CASSUG Meeting #SQLFamily #Azure #SQLAzure @CASSUG_Albany

Greetings, data enthusiasts!

Our April meeting will again be online. NOTE: you MUST RSVP to this Meetup at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/285058597/ to view the Zoom URL!

Our April speaker is Rie Merritt!

Topic: Transitioning your On-Prem Database Skills to Azure SQL

Adoption of Cloud is at an all time high, with no end in sight. Managing a small fleet of databases on-premises was something you long ago mastered. In this session, we’ll cover the most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Premises installs. One of the great things about Azure SQL is that the skill set your team has developed over the years translates well. The tools and technologies you’re familiar with are all there. Let’s modernize those existing skills to make you a cloud DBA.

About Rie:
Rie Merritt has been working with SQL Server since 1999, when she started as a data analyst for a non-profit. She’s worked in many industries over the years including pharmaceutical, e-commerce, legal, financial, education and both federal & state government. Most recently, she was director of database management, Integrated Payments for WorldPay, Inc. She is currently Senior Program Manager with Microsoft Azure Data, serving as the MVP PG lead and as liaison between the product group and the data community. She is based out of Redmond, but works remotely from her home near Atlanta.

Over the years, Rie has done extensive work with the SQL Community. She was an MVP in the Data Platform for three years, speaking frequently at conferences across the US and moderating webinars, WIT panels and career panels. She has also served co-leader of the PASS Women in Technology Virtual Group and Executive Director of SQL Saturday Atlanta. Most recently, Rie helps run the Atlanta Azure Data User Group heading up Microsoft’s efforts for the Azure Data Community.

Our online meeting schedule is as follows:

• 6:00: General chat, discussion, and announcements
• 6:30: Presentation

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

Please RSVP to this Meetup, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.

Thanks to our sponsor, Datto, for making this event possible!