Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development > Database Administration

Database Administration

1-20 of 65     Previous     Next
Purging Binary Logs in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.
Making a Column Autoincrement the Value Itself in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.
Check if a Primary Key Exists on a Table
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.
Updating a Column with the Current Time Stamp in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.
Identifying Unused Tables with T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.
Identify Tables with Large Column Counts
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.
Find Out the Column Name Using the COL_NAME() Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.
Using the Replace Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.
The sp_spaceused Procedure in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.
Merge Two DataTables, Preserving the Old Values
by Srinath M S
Language: .NET, Expertise: Beginner - Learn how to maintain all the old values when merging two databases.
Turn Off the Index Maintenance of DataTable when you Load Data
by Srinath M S
Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.
Encrypting and Decrypting a Database Connection String
by Hannes du Preez
Language: .NET, Expertise: Intermediate — Learn to encrypt your connection string to a database
Using the SET NOCOUNT SQL Method
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how to use the NOCOUNT method to switch off the DONE_IN_PROC messages and boost the performance of queries and network traffic.
Built-in JSON Functions in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Did you know that SQL has some very handy built-in JSON functions?
Using the SQL LCASE Function
by Hannes du Preez
Language: SQL||Expertise: Beginner
Get a List of all Tables In Oracle SQL
by Ben Brumm
Using DATEFROMPARTS SQL Function
by Hannes du Preez
Language: SQL||Expertise: Beginner
Convert Oracle Queries into Microsoft SQL Format
by Andrew Kuprianov
Language: SQL||Expertise: Intermediate
Doing Upserts with the Help of MERGE
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Get All Tables and Views Inside a Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
1-20 of 65     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date