Reset the Root Password of MySQL on Windows
When we install MySQL on Windows, we usually specify the password of the root user. This helps keep...
Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases
There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what...
SQL OR Statement: The Basics
Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
How to Use SQL SUM Function
SQL is a powerful and widely-used programming language for data storage, retrieval, and...
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 allows database administrators (DBAs) to...
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...
How to Get Tables Information in SQL Server via Stored Procedure
As a database administrator, developer, or data analyst, understanding the structure and details of...
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....
How to Show List of Indexes in SQL Server using Stored Procedure
As SQL Server DBAs, we’ve heard that index structures can dramatically improve the performance of any given query (or set of queries)....
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
