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

Using the Locate Command in MySQL

Wednesday, December 31, 1969 · Language: MySQL, Expertise: Intermediate - Finding a particular string in a large data set can be extremely tedious. Fortunately, MySQL has a command called locate to help you find what you need.

Get the First Day of the Current Month

Wed, 22 May 2019 09:10:00 +0000 · Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.

Adjusting Views to Reduce Visibility of Data in MySQL

Mon, 20 May 2019 08:54:00 +0000 · Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.

Get All Columns in All Tables of a Specific Data Type

Fri, 17 May 2019 09:09:00 +0000 · Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.

How to Use the Show ProcessList in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to list all of the processes that hold a valid connection to the database.

Get the Last Day of the Current Month

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Use this easy query to discover the last day of the current month.

Get Current Precision Level Used by Numbers in SQL Server

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to get the current precision by executing the following command.

Rebuild All Database Indexes

Mon, 06 May 2019 09:08:00 +0000 · Language: SQL, Expertise: Intermediate - See how to rebuild all of the indexes in your database with this query.

Get Current Language of SQL Server

Wed, 01 May 2019 08:27:00 +0000 · Language: SQL, Expertise: Beginner - Learn an easy query to get the current language in SQL Server.

Recompile a Stored Procedure

Fri, 26 Apr 2019 08:17:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.

Using Find_in_Set in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to search for, or look up, a given string.

RESEED Identity Columns of All Tables

Mon, 22 Apr 2019 08:26:00 +0000 · Language: SQL, Expertise: Beginner - See how to loop through all the tables and execute the DBCC CHECKIDENT command.

Working with the IIF Statement in T-SQL

Wed, 17 Apr 2019 08:25:00 +0000 · Language: SQL, Expertise: Beginner - See how to quickly check for certain conditions.

Using the Insert on Duplicate Key Update in MySQL

Mon, 15 Apr 2019 08:21:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about the insert on duplicate key update and how to use it in MySQL.

Resize Your TempDB in SQL

Wed, 10 Apr 2019 08:56:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to resize the tempdb temporary database in SQL.

Understanding the AVG Function in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to use the AVG function to calculate the average in MySQL.

Get Current Language ID

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See which select statement to use to get the language ID.

Using sys.dm_db_index_physical_stats

Wed, 27 Mar 2019 08:35:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to return size and fragmentation information for the data and indexes of the specified table or view in SQL Server.

Using AUTO_INCREMENT in MySQL

Mon, 25 Mar 2019 09:10:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to set AUTO_INCREMENT values when they need to start from a number of your choice or as per some other criteria.

Write SQL Results to a Text file

Wednesday, December 31, 1969 ·

Finding the Current User in MySQL

Fri, 15 Mar 2019 09:08:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.

Diagnose System Slowdowns

Wed, 13 Mar 2019 08:54:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to quickly diagnose System slowdowns.

Identify Tables Storing GUID Values

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to identify tables that store a GUID (Globally Unique Identifier) value.

Using sys.dm_db_missing_index_group_stats

Wed, 27 Feb 2019 09:35:00 +0000 · Language: SQL, Expertise: Intermediate - See how to return summary information about groups of missing indexes, excluding spatial indexes.

Employing DROP USER in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn to how to properly use the drop user command in MySQL.


· 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