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 54     Previous     Next
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
Find out When the Last Full Backup was Taken
by Hannes du Preez
SQL query that displays the last time a full backup was taken, as well as the user who took the last backup.
Rebuild All Table Indexes in a SQL Server Database with One Command
by Srinath MS
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server database with a single command.
Quick Script Monitors Application-generated SQL
by Jason Bramsden
This script was written to monitor a program whose process life was only a few seconds. It runs forever and only outputs that SQL which is generated by the program as it's running.
Graphical Tools for MSDE
by John Joseph
MSDE's small-footprint SQL Server compatible database has now been retooled as SQL Server— and it does not include graphical tools.
Turning Recursive and Nested Triggers On and Off
by Sachin Kainth
This tip gives you the commands to switch recursive and nested triggers on and off.
Getting New Values Entered into a Table
by Sachin Kainth
Find out how you can use :new.<fieldname> to retrieve new values entered into a table.
Resolve DB2 Instance Creation Failure on UNIX
by R. Vijaya
Finds out why AIX DB2 instance creation fails and jpw to resolve it.
Making Tables Read-only in Oracle
by MS Sridhar
In Oracle, you can only control read/write capability for an entire tablespace, not for a single table within a tablespace.
Identify the Owner of a User Table
by Jaya Nehru Kumar
If your database is maintained by more than one user and some of those users have rights to create tables, it can be difficult to identify the owner of a given table.
Hide System Tables and Objects in MS SQL Enterprise Manager
by Jaya Nehru Kumar
Follow these three, simple steps to hide system tables and objects in MS SQL Enterprise Manager.
Granting Permissions on Database Objects
by Devington B.
1-20 of 54     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date