Azure SQL Database is a fully managed platform as a service  (PaaS). Azure handles database management functions such as upgrading, patching, backups, and monitoring and we do not need to worry about these operations. In this article, we will see how to create an SQL database, connect to it, create a table in it and delete it at the end.

Last week, Jan 18th, we started 2022 with a new release of the MySQL Server suite (Router, Shell, Connectors, …).

MySQL is Open Source and each release contains contributions from our great Community. Let me thanks all the contributors on behalf of the entire MySQL Team: Thank you !

As Dave already mentioned already in his MySQL 8.0.28 Release Note Commentary post, this new version of MySQL includes contributions from Song Zhibai, Venkatesh Prasad Venugopal, Zheng Lai, Tingu Wei, Casa Zhang, Kevin Michel, our Øystein Grøvlen before his comeback, Tsubasa Tanaka, Brian Yue, Murakami Kohei, Casa Zhang, Hope Lee, Rahul Malik, Hobert Lu, Zhai Weixiang and Facebook.

Once again, thank you all for your …

We know how common and useful CSV files are. If you need to save a particular query’s results to a CSV file, it couldn’t be easier than with MySQL Workbench. I recently wrote a quick post over on my Medium account covering this and am sharing it here for any interested readers…

Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

Image by  …

The new version of Devart dotConnect for MySQL contains significant improvements in Entity Framework Core support. We supported new data types Uri, IPAddress, PhysicalAddress and expanded the capabilities for translating LINQ queries into SQL. Besides, we improved support for working with JSON in LINQ queries for EF6. Uri data type mapping For Entity Framework Core 3, 5, and 6, dotConnect for MySQL now supports mapping the internet/intranet System.Uri type to Oracle […]

The post Support for New Data Types and Other Improvements in dotConnect for MySQL 8.21 appeared first on Devart Blog.

I keep rolling in with new issues of OpenLampTech, the newsletter for PHP/MySQL developers and you keep reading them. Sounds like a fair trade to me! I have another fantastic, huge issue for all of your reading enjoyment in the PHP/MySQL world…

Get tailored articles with Refind delivered each day in your inbox. Refind is part of my daily reading habit. Make it part of yours by using my referral link. At no additional cost to you, I will be eligible for a premium subscription with more sign-ups from my link. “The essence of the web, every morning in your inbox. Subscribe for free“

The Newsletter for PHP and MySQL Developers

Let’s get right to …

The festive season has come to an end, but Devart is still receiving presents. We have great news that we would like to share. dbForge Studio for MySQL gained nine awards from G2. The collection of dbForge Studio for MySQL counts nine new badges: According to G2 users reviews, dbForge Studio for MySQL attracts by […]

The post Absolute Trophy Champion—dbForge Studio for MySQL Got Nine Awards appeared first on Devart Blog.

 MySQL 8.0.28 version is GA!!! , ready to use in production.Below is high level overview , more can be viewed from the weblink.

[1] Disabling Audit Logging for all connecting and connected sessions
SET GLOBAL audit_log_disable = true;
Setting audit_log_disable to true disables the audit log plugin. The plugin is re-enabled when audit_log_disable is set back to false, which is the default setting.

[2]- [Under Performance …

 MySQL Server version  8.0.28 was launched a few days ago and without a lot a fanfare. Which is a shame and I wish we had more of a splash for every release.  The release notes are available here. 

I would like to highlight some of the changes.

There are over a hundred bug fixes and big thanks to Hope Lee, Casa Zhang, Øystein Grøvlen, Song Zhibai, Facebook, Hobert Lu, Brian Yue, Zhai Weixiang, Murakami Kohei,  Venkatesh Prasad Venugopal, and the Tencent team.

The Highlights

This release does not have a lot of 'wow' new features but shows a lot of solid work in evolving the product. 

• The new audit_log_disable system variable …

Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in case of an unwanted event with your data.

We always work on trying to improve Percona XtraBackup reliability, always favoring consistency, attempting to make unwanted outcomes be noticed as earlier as possible in the process.

Enabling –strict by Default

As of the upcoming release of 8.0.27, XtraBackup will no longer accept invalid parameters. Since the beginning of the times, validation of parameters has been a difficult task for XtraBackup as it mixes server-side and XtraBackup only parameters.

Starting at Percona XtraBackup 8.0.7 we implemented …

In this tutorial, we’re going to show you how to install MySQL on CentOS. Step-by-step instructions on how to configure and install MySQL. Alternative recommended read: How to Install MySQL on Ubuntu. Prerequisites Before we begin, this is what you’ll need: A CentOS server. You can get one from Linode or Vultr. If you want […]

Source