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

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.

Read All SQL Server Log Files

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.

Using the DATALENGTH SQL Function

Wed, 13 Feb 2019 10:14:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to use a SQL function to return the length of a column in a table.

Empowering MySQL to Send Batched Statements in a Single Request

Wed, 06 Feb 2019 09:34:00 +0000 · Language: SQL, Expertise: Intermediate - See how to empower MySQL to send batched statements in a single request.

Employing DBCC PINTABLE and DBCC UNPINTABLE Functions

Wednesday, December 31, 1969 · Language: SQL, Expertise: Advanced - See how to ensure a table always stays available in SQL Server's cache. You can Pin the table and Unpin it when it is not needed anymore.

Compress and Decompress SQL Functions

Wed, 30 Jan 2019 09:37:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to compress and decompress data in SQL.

Preventing SQL from Running on a Testing SQL Server

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See the two ways to prevent your SQL code from running on a testing or production server.

Knowing the Privileges of the Current User in MySQL

Fri, 18 Jan 2019 09:54:00 +0000 · Language: SQL, Expertise: Intermediate - See how to figure out what privileges users have in MySQL.

Transfer Data with JSON in SQL Server

Wed, 16 Jan 2019 09:48:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to transfer data with JSON in SQL Server.

Understanding the Unique Keyword in MySQL

Mon, 14 Jan 2019 09:50:00 +0000 · Language: SQL, Expertise: Intermediate - See how to ensure that a certain combination of column values is unique in a table.

Creating an HTML Table with SQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to produce HTML tables with this SQL example code.

Introducing the APPROX_COUNT_DISTINCT SQL Function

Wed, 02 Jan 2019 09:43:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to return the approximate number of unique non-null values in a group.

Auto Start the SQL Server Agent Service

Fri, 28 Dec 2018 09:54:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to ensure that your SQL Server Agent always restarts when the SQL Server restarts.

Figure Out the Length of Text in a Column in MySQL

Wed, 26 Dec 2018 09:40:00 +0000 · Language: SQL, Expertise: Intermediate - See an easy way to find out the length of the text in a column.

Using ENUM in MySQL Columns

Fri, 21 Dec 2018 09:46:00 +0000 · Language: SQL, Expertise: Intermediate - See how ENUMs are very powerful definitions and how they help attain data validation when the values are pre-defined.

Reverse Strings in SQL

Wed, 19 Dec 2018 09:51:00 +0000 · Language: SQL, Expertise: Intermediate - Learn learn more about a SQL query with which you can reverse strings.

Employ This SQL Stored Procedure to Rename a Column

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to use sp_rename to rename a column in a table.

Selecting the Max, Min and Sum of Values from a Table in MySQL

Fri, 07 Dec 2018 09:42:00 +0000 · Language: SQL, Level: Intermediate: - Learn how to find the Max, Min and Sum of values from a column in a table in MySQL.

Generating Random Numbers in SQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to easily generate a random number.

Getting the Current Date and Time in MySQL

Mon, 03 Dec 2018 10:08:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to use the NOW() function in MySQL to get the current time and date.


· 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