Daily news, white papers, tutorials and articles on databases.


The links below take you to the DevX: Latest Database Content web site. This is a free off site content service. We're not responsible for the linked content. If nothing displays below, the DevX: Latest Database Content blog or news channel is currently unavailable, please try again later.

DevX: Latest Database Content

www.DevX.com

How to Pass Parameters in @Query

Fri, 15 Nov 2019 09:09:00 +0000 · Language: Java, Expertise: Intermediate - Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.

Object Explorer Details

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to use the Object Explorer feature in SQL to find a particular stored procedure from a long list of available options.

Locking a User Account in MySQL

Mon, 11 Nov 2019 09:47:00 +0000 · Language: SQL, Expertise: Intermediate - MySQL provides a mechanism to alter the user properties, thereby allowing you to lock the user account.

Using Multi Edit Mode

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually. See a neat trick to automatically add the required commas.

Get All Columns in All Tables of a Specific Data Type

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.

Set Up a Database Dialect in Spring Boot

Wednesday, December 31, 1969 · Language: Java, Expertise: Intermediate - Learn how to use the spring.jpa.properties.hibernate.dialect property to set the database dialect in Spring Boot.

Using MICROSECOND in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Developers often work with time in terms of hours, minutes and seconds. Learn how to break it down to the microsecond level.

3 More Hints for Building Faster SQL Queries

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Follow these three tips to help improve your SQL query performance.

Finding the Current Quarter in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to use MySQL to find the current financial quarter.

Using ENUM to Pre-define Column Values in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how the values for a particular column can be pre-defined during the table definition. These values will be validated when the records are inserted or updated in the table.

Creating an SQL Query that Generates Dynamic LIKE Statements

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to construct a query that can generate dynamic LIKE statements in SQL.

Converting UNIX_TIMESTAMP to Readable Format in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn more about a quick and neat way of converting the current time from Unix format to Readable format.

3 Hints for Achieving Faster SQL Queries

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Follow these three tips to help increase the performance of your SQL queries.

Understanding TOP WITH TIES in SQL

Wed, 25 Sep 2019 09:17:00 +0000 · Language: SQL, Expertise: Intermediate - See what the Top with Ties clause actually does in SQL>

Difference Between RANK, DENSE_RANK and ROW_NUMBER SQL Statements

Wed, 18 Sep 2019 08:39:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about how to use three very different SQL statements.

Three Levels of Data Abstraction in SQL

Wed, 11 Sep 2019 08:30:00 +0000 · Language: SQL, Expertise: Beginner - Learn more about the levels of data abstraction employed in SQL to hide irrelevant details from users.

Delete Data Safely with SQL

Wed, 04 Sep 2019 08:37:00 +0000 · Language: SQL, Expertise: Intermediate - Explore to how to safely delete data in SQL.

Name All of the Normalization Forms in SQL

Wed, 28 Aug 2019 08:33:00 +0000 · Language: Java, Expertise: Beginner - Explore a list of the names of all normalization forms in SQL.

Discovering the Reason for Poor Query Performance

Wed, 21 Aug 2019 08:37:00 +0000 · Language: SQL, Expertise: Beginner - Explore some of the reasons why your query performance might not by up to expected speeds.

Types of Indexes that Exist in SQL

Wed, 14 Aug 2019 08:35:00 +0000 · Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.

Getting the Last ID in MySQL

Wednesday, December 31, 1969 · Language: SQL Expertise: Intermediate - Explore how MySQL supports AUTO_INCREMENT column types when many instances require the last value that was inserted to be used in reporting.

Understand the AES Encryption Method

Fri, 02 Aug 2019 09:02:00 +0000 · Learn how to understand the AES ENCRYPTION method that is supported by MySQL.

Using the WEEKOFYEAR Function in MySQL

Wed, 31 Jul 2019 08:52:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to use calendar functionality in MySQL to figure out in which week a given date belongs.

T-SQL Performance Tip: Stored Procedure Names

Mon, 29 Jul 2019 09:17:00 +0000 · Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.

T-SQL Performance Tip: NOT IN vs NOT EXISTS

Mon, 22 Jul 2019 08:11:00 +0000 · Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.


· Home

· Databases

· DevX

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help


Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly


Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking



Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed



To eliminate unwanted email from ALL sources use SpamArrest!






Digg this · Add to del.icio.us · Add to Furl · We Can Help You!




Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives


Top of page

No Ads


Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy