Backing up MySQL Part 1: mysqldump

mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforward to use. As far as MySQL or its flavors (MariaDB and Percona Server) are concerned, this command line-based tool is one of the top choices for junior and senior database engineers across the world alike.

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER(), and STARTOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.

SQL Server Indexes to Improve Query Performance

In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.

Leveraging the Script Activity within Azure Data Factory

Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.

The Azure Database Timezone

Cassandra Springboot Integration

In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.

Introducing the MySQL INSERT statement

In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.

PARSEing strings

The Scariest Data Type

SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling

This article shows how one can use SSIS to find differences in SAP.