Getting started with MySQL
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.
2022-02-23
MySQL
Dealing with Failed SQL Migrations in MariaDB or MySQL
Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
2021-10-25
Flyway with MariaDB for Those of a Nervous Disposition
This article from Phil Factor will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
2021-10-22
Azure Database for MySQL
In this article we take a look at setting up and configuring MySQL to run on Azure along with some performance metrics for this database platform running on Azure.
2020-10-02
Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
Blogs
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
Free Cloud Environment Setup: A Beginner’s Guide
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers