How to Use AI for SQL Tuning for a Real Automated Process
The rapid evolution in development from rigidly structured data to responsive, flexible databases...
MySQL SHOW USERS: How to List All Users in a MySQL
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...
Locking in SQL Server: Detailed Overview
In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size....
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
Understanding SQL Server Lockdown to Secure Database Environment
Security is the main concern these days in every sector. Database Security is also a major worry for any customer. SQL Server is designed...
SQL Server System Databases – Restore System Databases
In the previous articles of the SQL Server System Databases series, we have learnt the purpose of all SQL Server System databases that...
MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management
In the previous articles of the SQL Server System Databases series, we have gone through the System...
ML{.NET} Introduction
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....
TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database
In my previous article about SQL Server System Databases, we learned about each system database that comes as part of SQL Server...
ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips
MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You...
