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

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.

How to Change the Storage Engine in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to change the storage engine used in MySQL to improve application performance.

Using NUMERIC_ROUNDABORT in T-SQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Learn how to specify the level of error reporting that has been generated when an expression being rounded has caused loss of precision.

Get All the Tables with a Count of Their Records

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.


· 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




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