DevX Tips Bank: Database Administration

Get the First Day of the Current Month

Language: SQL, Expertise: Beginner - Learn how to find the first date …

Rebuild All Database Indexes

Language: SQL, Expertise: Intermediate - See how to rebuild all of the …

Obtain the Oldest Open Transaction

Language: SQL, Expertise: Advanced - See how to determine the oldest …

Suppress Errors When Duplicate Data Is Inserted in MySQL

Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE …

A Handy Delete Stored Procedure

Language: SQL, Expertise: Intermediate - Ensure that your data is safe …

Identifying all the Index(s) Available on a Table in MySQL

Language: SQL, Expertise: Intermediate - Learn a way to increase …

Create a Snapshot of Your Database

Language: SQL, Level: Intermediate: - Use this code to create a …

Identify Tables Without an Identity Column

Language: SQL, Level: Beginner: - This query will enable you to list …

Get the Total Number of Rows for Each Table in Your Database

Language: SQL, Level: Beginner: - Use the following query to get the …

Knowing the Version and Supported Engines in MySQL

Language: SQL, Level: Intermediate: - These commands are handy to find …

Purging Binary Logs in MySQL

Language: SQL, Expertise: Intermediate - Stay out of trouble regarding …

Making a Column Autoincrement the Value Itself in MySQL

Language: SQL, Expertise: Intermediate - Learn how to make a column …

Check if a Primary Key Exists on a Table

Language: SQL, Expertise: Intermediate - Learn how to check whether a …

Updating a Column with the Current Time Stamp in MySQL

Language: SQL, Expertise: Intermediate Learn how to add the current …

Identifying Unused Tables with T-SQL

Language: SQL, Expertise: Intermediate - Learn how to easily identify …