Showing entries 1 to 10 of 68
10 Older Entries »
Displaying posts with tag: Tutorials (reset)
Connect MySQL™ to Power BI – Step by Step

 

In today’s data-driven world, organizations rely heavily on data analysis and visualization to make informed decisions and gain a competitive edge. Microsoft Power BI and MySQL are two powerful tools that can facilitate this process. In this article, we will explore the process of how to connect MySQL to Power BI, a leading business intelligence tool.

Understanding Power BI Definition and Purpose

Power BI is a business analytics service that can gather all your data in a single platform and enable users to analyze and visualize easily. It provides a user-friendly interface and a wide range of tools to transform raw data into meaningful insights.

Key Features

Power BI offers an array of features, including interactive dashboards with a drag and drop interface, real-time data monitoring, natural language queries, and seamless integration with other Microsoft applications …

[Read more]
Master MySQL Point in Time Recovery

Data loss or corruption can be daunting. With MySQL point-in-time recovery, you can restore your database to the moment before the problem occurs.

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity.

Key Takeaways

  • MySQL Point in Time Recovery (PITR) enables restoration to a specific point after a full backup. It relies heavily on binary log files to record the incremental changes needed for recovery.
  • Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Monitoring and managing binary log activities, such as file retention, are essential for effective recovery.
  • Executing PITR requires …
[Read more]
Sync user data between Clerk and a PlanetScale MySQL database

Learn how to sync user data from a Clerk project into your PlanetScale MySQL database with webhooks using Netlify and Netlify Functions.

Build a contacts app with Node, Express, and MySQL

Learn how to build a contacts web app with Node, Express, and PlanetScale.

Build a library app with Laravel 10 and MySQL

Learn how to build a Laravel application backed by a MySQL PlanetScale database.

Build an expense tracker app with Symfony and MySQL

Learn how to build a use MySQL with Symfony by building an expense tracking application using a PlanetScale MySQL database.

Build a Rust API with Rocket, Diesel, and MySQL

Learn how to build a Rust API using Rocket, Diesel, and a MySQL database hosted on PlanetScale.

How to Upgrade from MySQL 5.7 to 8.0

Learn what you should look out for when upgrading an existing database from MySQL 5.7 to 8 and how to change your database to be compatible with the new version.

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Read the full story

Build a products listing application with Golang and MySQL

Learn how to build a products listing application with Golang and a MySQL database.

Showing entries 1 to 10 of 68
10 Older Entries »