Database administation

How to Use AI for SQL Tuning for a Real Automated Process

Automation, Database administation, Perfomance Tuning

The rapid evolution in development from rigidly structured data to responsive, flexible databases...
Read More

MySQL SHOW USERS: How to List All Users in a MySQL

Database administation, Database Optimization & Structure

This article explains different methods to populate the details of the Users in MySQL. We can view the list of users by using any of the...
Read More

Manage Transaction Concurrency Using Locks in SQL Server

Database administation, Security

In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size....
Read More

SQL Server User-defined Functions

Database administation, Database Optimization & Structure

User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
Read More

Understanding SQL Server Lockdown to Secure Database Environment

Database administation, Security

Security is the main concern these days in every sector. Database Security is also a major worry for any customer. SQL Server is designed...
Read More

SQL Server System Databases – Restore System Databases

Database administation, Database Optimization & Structure

In the previous articles of the SQL Server System Databases series, we have learnt the purpose of all SQL Server System databases that...
Read More

SQL Server System Databases – MSDB Maintenance

Database administation, Database Optimization & Structure, SQL Server

In the previous articles of the SQL Server System Databases series, we have gone through the System...
Read More

ML{.NET} Introduction

Automation, Database administation

Machine Learning (ML) has come from a buzzword that is nice to have in your application to a must-have feature that works and adds value....
Read More

SQL Server System Databases – the Tempdb Maintenance

Database administation, Database Optimization & Structure

In my previous article about SQL Server System Databases, we learned about each system database that comes as part of SQL Server...
Read More

ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips

Database administation, Work with data

MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You...
Read More
Close