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

Quickly Monitor Log Space in SQL Server

Wed, 25 Mar 2020 08:02:00 +0000 · Language: Java, Expertise: Beginner: Learn how to easily monitor free space in your database log files.

Using DBCC SHRINKDATABASE

Wed, 18 Mar 2020 08:01:00 +0000 · Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.

Find Error Log Location

Wed, 11 Mar 2020 08:05:00 +0000 · Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.

SQL Injection Tips, Part 3

Wed, 04 Mar 2020 09:17:00 +0000 · Language: SQL, Expertise: Intermediate: SQL injection is probably the most common hacking technique out there. Learn more about hacking techniques to keep your data secure.

Understanding What Grants a User Has in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to view what permissions a given user has been granted.

Get the First Day of the Current Month

Wed, 26 Feb 2020 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

Wednesday, December 31, 1969 · Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.

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.

Get All the Tables with a Count of Their Records

Wed, 19 Feb 2020 09:08:00 +0000 · Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.

Using AUTO_INCREMENT in MySQL

Wednesday, December 31, 1969 · 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.

SQL Injection Tips, Part 2

Wed, 12 Feb 2020 09:16:00 +0000 · Language: SQL, Expertise: Intermediate: Learn more about how to avoid issues with SQL injection.

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.

SQL Injection Tips, Part 1

Wed, 05 Feb 2020 09:55:00 +0000 · Language: SQL, Expertise: Intermediate: Learn more about how to avoid SQL injection issues.

Finding the Current User in MySQL

Fri, 31 Jan 2020 10:08:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.

Read All SQL Server Log Files

Wed, 29 Jan 2020 09:34:00 +0000 · Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.

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.

Using COMPRESS in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate: See how to easily encrypt text in MySQL with the compress method.

Understanding INSERT IGNORE in MySQL

Fri, 17 Jan 2020 09:12:00 +0000 · Language: SQL, Expertise: Intermediate: MySQL supports something named IGNORE along with INSERT, which captures the error as a WARNING. See it in action.

Using the STRING_AGG SQL Server 2017 Function

Wed, 15 Jan 2020 09:02:00 +0000 · Language: SQL, Expertise: Beginner: Learn how to perform grouped string concatenation.

Using REPEAT in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate: See how to repeat a particular string a defined number of times.

Understanding UNCOMPRESSED_LENGTH in MySQL

Fri, 10 Jan 2020 09:17:00 +0000 · Language: SQL, Expertise: Intermediate: Learn how to get the compressed text results to be the exact length of the original text.

SQL Statistic Tests to Look Into

Wed, 08 Jan 2020 12:59:00 +0000 · Language: SQL, Expertise: Beginner: Check out these six tests if you want to explore statistics in SQL.

How to Set hibernate.format_sql in a Spring Boot Application

Wednesday, December 31, 1969 · Language: Java, Expertise: Intermediate: See how to format the SQL statements for a Spring Boot application.

Understanding sql_mode in MySQL

Mon, 06 Jan 2020 09:27:00 +0000 · Language: SQL, Expertise: Intermediate - See how to use sql_mode to set values in MySQL.

Understanding FULLTEXT Searches

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - In MySQL, there is a provision to search based on natural mode. Follow this example to understand the process in detail.


· 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