Subscribe: DevX: Latest Database Content
Preview: DevX: Latest Database Content

DevX: Latest Database Content

Published: Mon, 19 Mar 2018 16:06:53 -0700

Last Build Date: Mon, 19 Mar 2018 16:06:53 -0700


Create a Table from an Existing Table in MySQL

Fri, 16 Mar 2018 02:04:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to easily create a new table that includes the indexes of the source table.

Finding All Currently Blocked Requests in SQL

Thu, 15 Mar 2018 02:01:00 -0700

Language: SQL, Expertise: Intermediate - Check out this quick way to find all currently blocked requests in SQL.

Understanding UNION in MySQL

Mon, 12 Mar 2018 02:06:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to identify unique records in MySQL.

Using dm_exec_function_stats in SQL Server 2016

Thu, 08 Mar 2018 02:10:00 -0800

Language: SQL, Expertise: Intermediate - Check the execution details of a function in SQL.

Suppress Errors When Duplicate Data Is Inserted in MySQL

Tue, 06 Mar 2018 02:04:00 -0800

Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE in MySQL for cases in which ignoring duplicates might be useful.

A Handy Delete Stored Procedure

Thu, 01 Mar 2018 02:07:00 -0800

Language: SQL, Expertise: Intermediate - Ensure that your data is safe when you make use of Transactions to do any data manipulation with this sample stored procedure.


Tue, 27 Feb 2018 02:04:00 -0800

Language: Java, Level: Intermediate: - Check out this MySQL command to handle null effectively in your code.

Allow SQL Server to Silently Truncate Data

Thu, 22 Feb 2018 01:08:00 -0800

Language: SQL, Expertise: Beginner - See two ways to prevent SQL from throwing this error.

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

Tue, 20 Feb 2018 02:02:00 -0800

Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.

Transpose Columns into Rows in SQL

Thu, 15 Feb 2018 02:09:00 -0800

Language: SQL, Expertise: Intermediate - Learn a different, albeit complicated, way to transpose columns into rows.

Quickest Way to Copy the Structure of a Table

Thu, 08 Feb 2018 02:06:00 -0800

Language: SQL, Level: Intermediate: - This quick tip demonstrates how to copy a table's data, as well as only the structure of a table.

Secure Your Data in SQL 2016 with Row Level Security (RLS)

Wed, 07 Feb 2018 02:03:00 -0800

Language: SQL, Expertise: Advanced - Learn to implement restrictions on data row access in SQL 2016.

Create a Snapshot of Your Database

Thu, 01 Feb 2018 02:01:00 -0800

Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.

Identify Tables Without an Identity Column

Thu, 25 Jan 2018 02:35:00 -0800

Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.

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

Thu, 18 Jan 2018 02:33:00 -0800

Language: SQL, Level: Beginner: - Use the following query to get the total number of rows for each table in your database

Knowing the Version and Supported Engines in MySQL

Fri, 12 Jan 2018 06:06:00 -0800

Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.

Extract All Numbers from a String in SQL

Mon, 08 Jan 2018 02:34:00 -0800

Language: SQL, Level: Intermediate: - Learn this easy way to extract numbers from a string.

Disable Indexes with SQL

Thu, 21 Dec 2017 05:36:00 -0800

Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.

Purging Binary Logs in MySQL

Mon, 18 Dec 2017 05:14:00 -0800

Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.

The sp rename SQL Stored Procedure

Thu, 14 Dec 2017 14:22:00 -0800

Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.

Understanding Null Values Returned in MySQL

Thu, 07 Dec 2017 01:23:00 -0800

Language: MySQL, Beginner: Intermediate - Learn why the null value often needs special attention in your code to work effectively.

Pass Comma Separated Values as a Parameter to an SQL Stored Procedure

Wed, 29 Nov 2017 02:35:00 -0800

Language: SQL, Expertise: Intermediate - There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn't support this. See how to get around this issue.

Limiting the Rows Returned in MySQL

Tue, 28 Nov 2017 13:21:00 -0800

Language: SQL, Expertise: Intermediate - In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided.

Using the SQL FORMAT Function

Thu, 23 Nov 2017 02:31:00 -0800

Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.

Using BETWEEN in MySQL Queries

Wed, 22 Nov 2017 02:49:00 -0800

Language: SQL, Expertise: Intermediate - See how to filter a column based on dates and time using BETWEEN.