Database Administration - Page 2

21-35 of 35 Previous Next
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
Understanding OFFSET in MySQL by M S Sridhar Language: SQL, Level: Intermediate: - Learn an easy way to fetch the next 10 records from a given point.
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.
21-35 of 35 Previous Next