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

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.

Use MySQL for Calculations

Fri, 19 Jul 2019 08:48:00 +0000 · Language: SQL, Expertise: Intermediate - See a few different ways to use MySQL to compute the result of a mathematical formula.

Check Whether or Not an IP Is Valid in C#

Wednesday, December 31, 1969 · Language: .NET, Expertise: Beginner - Learn more about a short function that validates a given IP address.

User Creation and Scenarios

Wed, 17 Jul 2019 08:24:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about the importance of providing a password during the user creation process itself.

T-SQL Performance Tip: The * Operator

Mon, 15 Jul 2019 09:04:00 +0000 · Language: SQL, Expertise: Beginner - Learn more about why you should use explicit column names in T-SQL.

Understanding NULL in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to work with NULL in MySQL. Examine a few examples in which you might be confused with the output unless you are very comfortable using NULL.

T-SQL Performance Tip: Owner or Schema Name

Mon, 08 Jul 2019 08:57:00 +0000 · Language: SQL, Expertise: Beginner - Learn more about how to improve query performance by including owner or schema name.

Using REGEX Case Sensitively

Wed, 03 Jul 2019 08:28:00 +0000 · Language: SQL, Expertise: Intermediate - See how to navigate using regex case sensitively in MySQL.

T-SQL FORCEPLAN

Mon, 01 Jul 2019 08:38:00 +0000 · Language: SQL, Expertise: Beginner - Learn more about what happens in the SQL Server query optimizer when Forceplan is set to on.

Understanding Checksum Table in MySQL

Fri, 28 Jun 2019 09:03:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to verify if the related files/contents are not tampered with or corrupted.

Set ARITHIGNORE to On

Mon, 24 Jun 2019 08:39:00 +0000 · Language: SQL, Expertise: Beginner - Learn how to control whether error messages will be returned from overflow or divide-by-zero errors occurring during a query.

Renaming a User in MySQL

Wed, 19 Jun 2019 09:00:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to change a user name in MySQL, as requirements may be updated along the development process.

Explore a Few Math Functions in SQL Server

Mon, 17 Jun 2019 09:41:00 +0000 · Language: SQL, Expertise: Beginner - See several math functions that can be used in T-SQL.

Setting Up a PROXY User in MySQL

Fri, 14 Jun 2019 09:09:00 +0000 · Language: SQL, Expertise: Intermediate - See how to set up a proxy user that has the same permissions as the original user.

Disabling Binary Logs in MySQL

Wed, 12 Jun 2019 08:58:00 +0000 · Language: SQL, Expertise: Intermediate - Sometimes there are just too many logs available to sift through efficiently. Learn how to disable the binary logs in MySQL to cut down on the clutter.

Using LOCK_TIMEOUT in SQL

Mon, 10 Jun 2019 08:36:00 +0000 · Language: SQL, Expertise: Beginner - See how to specify how long a statement should wait for a lock to be released.


· 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