talk-data.com

Overview of Microsoft's Power Platform components (Power BI, Power Apps, Power Automate, Power Pages, and Dataverse) and how to design and create practical, low-code solutions using these integrated tools.

Greetings, data enthusiasts!

Our September meeting is scheduled for Monday, September 9th, 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/298352705/ if you are attending, so we can purchase an appropriate amount of food for everyone. Food will be ordered from Mi Casa in Troy. For this meeting, we are welcoming back John Miner to join us from the Rhode Island area. Thank you John for taking the drive out to the Capital Region to be with us (again!)

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, John Miner is presenting a great topic that spans multiple data platforms: "Moving on up, to the Azure cloud, with a PostgreSQL database in the sky":

Many companies are looking to reduce licensing costs by moving databases currently written for SQL Server to PostgreSQL. What are the technical pitfalls you might encounter when moving not only the database schema but re-factoring the code?

In this presentation, we will show how recreating the existing database schema in PostgreSQL is quite easy and migrating the data from MS SQL Server to PostgreSQL is not hard. However, the old saying of “garbage in equals garbage out” applies to both views and stored code.

These two types of pre-compiled code will challenge the developer to use their skills to decipher code written years ago and convert it to modern day code that is performant, uses intermediate steps for debugging and uses logging for run time metrics.

In short, this presentation is a must for database developers that are tasked with moving and modernizing older SQL Server databases to PostgreSQL!

Greetings, data enthusiasts!

Our September meeting is scheduled for Monday, September 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. Food is TBA, but since John (our speaker) is driving out from New England, I am letting him pick the cuisine. Can he say "Chowder"? We shall see :-)

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, we welcome John Miner to provide us an introductory presentation on Spark SQL. Here is the session info:

This presentation is a crash course covering the basics of Spark SQL for the Microsoft T-SQL Server developer.

Azure Databricks is a managed service which provides the latest versions of Apache Spark based upon open source libraries. Spin up clusters and build quickly in a fully managed environment with the global scale and availability of Microsoft Azure.

The Adventure Works database is provided as raw delimited files to transform. We will go over read and writing files to popular file formats using PySpark, a Python-based wrapper for the Scala API. The real power of PySpark is the ability to read a file into a data frame and abstract the contents of the file as a temporary view during processing. Optionally, the raw data files can be presented as tables in the hive catalog. Once this abstraction is complete, all the SQL skills that you have obtained over the years can be used to transform the views/tables in the hive catalog into refined data in the data lake.

Greetings, data enthusiasts!

Our September meeting is scheduled for Monday, September 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. Food is TBA, but since John (our speaker) is driving out from New England, I am letting him pick the cuisine. Can he say "Chowder"? We shall see :-)

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, we welcome John Miner to provide us an introductory presentation on Spark SQL. Here is the session info:

This presentation is a crash course covering the basics of Spark SQL for the Microsoft T-SQL Server developer.

Azure Databricks is a managed service which provides the latest versions of Apache Spark based upon open source libraries. Spin up clusters and build quickly in a fully managed environment with the global scale and availability of Microsoft Azure.

The Adventure Works database is provided as raw delimited files to transform. We will go over read and writing files to popular file formats using PySpark, a Python-based wrapper for the Scala API. The real power of PySpark is the ability to read a file into a data frame and abstract the contents of the file as a temporary view during processing. Optionally, the raw data files can be presented as tables in the hive catalog. Once this abstraction is complete, all the SQL skills that you have obtained over the years can be used to transform the views/tables in the hive catalog into refined data in the data lake.