MySQL management, tutorials, scripts, coding, programming and tips for database administrators

MySQL

Working with SQL Cursors 03/23/2020

In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from them, and then close them.

Connecting to a MySQL Database in .NET 03/16/2020

Learn how to connect to a MySQL database from a .NET application.

Adding Data to a Cloud Firestore Database 03/11/2020

Learn how to add data to a NoSQL Cloud-based database (Firebase Firestore) from a simple web application.

Introduction to Firebase 03/09/2020

If you are doing a mobile or web-based app that need scalable access to a scalable, multi-user Cloud-based database that includes analytics and other features, then Firebase is worth taking a look. Read on to learn about the no-cost version of this NoSQL database that you can get started with today!

Understanding Query Execution in Relational Database System Architecture 01/27/2020

What happens behind the scene in a modern relational database management system when a user submits a query until the result is obtained from the database? Read on to learn more!

A Quick Look at SQL Server Numeric Functions 12/19/2019

If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions

Query Performance Optimization in MySQL 12/02/2019

Discover a few optimization points to ponder upon while designing a better query in MySQL.

Understanding Schema Optimization in MySQL 11/11/2019

Optimizing Schemas for your data can involve trade-offs. Delve into the intricacies of schema optimization and how to achieve them in MySQL.

Using Five Types of JOIN in MySQL 10/21/2019

Learn how to use the different types of joins available in a MySQL database.

Planning for SAP HANA Deployments in Public Cloud Environments 10/07/2019

Learn about the factors that should be taken into account if you are considering hosting SAP HANA in a public cloud. Read on...

Database Tools and Extensions for Visual Studio 2019 09/23/2019

In this article, you will explore tools and extensions that can be used with Visual Studio 2019 to improve your database experience irrespective of what database you use.

Polling and Survey Data Transparency 07/01/2019

Polls and surveys are increasing in use. If you are a DBA, developer, or data scientist, then it is good to understand how to structure your systems for transparency and proper use.

Ten SQL Commands You Should Be Using 06/03/2019

Most developers, regardless of their skill level would know the commands for the basic CRUD (Create, Read , Update, Delete) operations in SQL These include the Create, Update, Insert, and Delete commands. From this article you will be presented with ten other SQL commands that you really should be using, that you might not be as familiar with. Read on...

Database Development in an Open Source World 05/30/2019

Open source database tools are found in many categories, including engine, modeling, script management, metadata, interactive query, semantic layer development, governance and more. Data development in a pure open source environment is possible.

MySQL 8 Security Tips 04/29/2019

If data security is not a top priority at your organization, it's time to make it one. It's up to you to protect both your customers' sensitive data and your reputation.  Learn some tips and tricks for securing your MySQL or MariaDB databases!