dcsimg
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 Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 379     Previous     Next
T-SQL Performance Tip: Stored Procedure Names
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.
Understanding Least and Greatest in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: Explore the least and greatest functions in MySQL.
Recompile a Stored Procedure
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.
Quickly Monitor Log Space in SQL Server
by Hannes du Preez
Language: Java, Expertise: Beginner: Learn how to easily monitor free space in your database log files.
Using DBCC SHRINKDATABASE
by Hannes du Preez
Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.
Find Error Log Location
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.
SQL Injection Tips, Part 3
by Hannes du Preez
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
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to view what permissions a given user has been granted.
Get the First Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.
Adjusting Views to Reduce Visibility of Data in MySQL
by Sridhar M S
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
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.
Using AUTO_INCREMENT in MySQL
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn more about how to avoid issues with SQL injection.
Using the Locate Command in MySQL
by Sridhar M S
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
by Hannes du Preez
Language: SQL, Expertise: Intermediate: Learn more about how to avoid SQL injection issues.
Finding the Current User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.
Read All SQL Server Log Files
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.
Employing DROP USER in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn to how to properly use the drop user command in MySQL.
Using COMPRESS in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate: See how to easily encrypt text in MySQL with the compress method.
1-20 of 379     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date