Subscribe: DevX: Latest Database Content
http://services.devx.com/outgoing/databasefeed.xml
Preview: DevX: Latest Database Content

DevX: Latest Database Content



www.DevX.com



Published: Fri, 18 Aug 2017 13:42:54 -0700

Last Build Date: Fri, 18 Aug 2017 13:42:54 -0700

 



SQL JOINs

Wed, 16 Aug 2017 04:32:00 -0700

Language: Web, Expertise: Intermediate - A JOIN clause is used to combine rows from two or more tables.



Search for Text Inside All the SQL Procedures in Your Database

Thu, 10 Aug 2017 04:36:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to find all Stored Procedures containing the specific text when you can't remember the name.



Detach from a Docker Container and Leave it Running

Wed, 09 Aug 2017 09:19:00 -0700

Language: Web, Expertise: Intermediate - Learn a quick way to detach from a Docker container and leave it running.



Identifying Tables Without Primary Keys in SQL

Thu, 03 Aug 2017 04:54:00 -0700

Language: SQL, Expertise: Intermediate - Use this script to find out which tables in your database(s) do not have Primary Keys.



Get a User that has Deleted Rows with SQL

Thu, 27 Jul 2017 04:52:00 -0700

Language: SQL, Expertise: Intermediate - Finding a user who has deleted rows is a multi-part process. Get some tips on how to get it done.



Restrict the Connection to a Database in SQL

Thu, 29 Jun 2017 05:05:00 -0700

Language: SQL, Expertise: Beginner - Learn how to restrict the connection to a database.



The sp_spaceused Procedure in SQL

Thu, 22 Jun 2017 05:02:00 -0700

Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.



Using xp_create_subdir to Create Windows Folders with SQL

Thu, 15 Jun 2017 05:02:00 -0700

Language: SQL, Expertise: Intermediate - Create folders in T-SQL with the help of the built-in Extended Stored Procedure named xp_create_subdir.



Merge Two DataTables, Preserving the Old Values

Tue, 13 Jun 2017 05:12:00 -0700

Language: .NET, Expertise: Beginner - Learn how to maintain all the old values when merging two databases.



Using xp_ dirtree to List Folders, Subfolders and Files with SQL

Thu, 01 Jun 2017 05:00:00 -0700

Language: SQL, Expertise: Intermediate — Learn how use an undocumented Extended Stored Procedure named xp_dirtree to list folders, subfolders, and files for a given path.



Flyway with Multiple Databases

Wed, 31 May 2017 05:00:00 -0700

Language: Web, Expertise: Intermediate - Learn how to use Flyway with multiple databases.



Turn Off the Index Maintenance of DataTable when you Load Data

Tue, 30 May 2017 05:06:00 -0700

Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.



Working with an SQL Output Parameter in C#

Thu, 25 May 2017 05:28:00 -0700

Language: .NET, Expertise: Beginner - How to specify the SQL Output parameter's Direction property once you have created it.



Retrieving Specific Information Using the Inspect Docker Command

Tue, 02 May 2017 06:47:00 -0700

Language: Web, Expertise: Intermediate — Learn how to specify the information you want to return by requesting a specific element.



Using Boolean Logic Instead of CASE WHEN

Wed, 26 Apr 2017 06:58:00 -0700

Language: SQL, Expertise: Intermediate — Once you get the hang of the CASE WHEN SQL Statement it can be easy to overuse it. Sometimes you can simply replace it with Boolean logic.



Encrypting and Decrypting a Database Connection String

Thu, 20 Apr 2017 07:25:00 -0700

Language: .NET, Expertise: Intermediate — Learn to encrypt your connection string to a database



Entering a Docker Container

Wed, 19 Apr 2017 08:09:00 -0700

Language: Web, Expertise: Intermediate — Learn an easy way to create a new interactive bash shell in the running container.



Enumerating all SQL Servers

Fri, 14 Apr 2017 04:27:00 -0700

Language: SQL, Expertise: Beginner — Learn how easy it is to enumerate (list) all the possible SQL servers to which you want to connect.



Use SUBSTR to Remove the Last Character from any String in Oracle SQL

Tue, 11 Apr 2017 06:39:00 -0700

Language: SQL, Expertise: Beginner — This code snippet is great for removing trailing slashes or other characters from the end of a string.



Using the SET NOCOUNT SQL Method

Fri, 07 Apr 2017 11:19:00 -0700

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.



How to Convert to a Specific Data Type Using CAST in Oracle SQL

Tue, 04 Apr 2017 06:39:00 -0700

Language: SQL, Expertise: Intermediate — If you need to convert to a specific data type (and length or precision), you can use the CAST function.



Add Months to a Date in Oracle SQL

Wed, 29 Mar 2017 06:41:00 -0700

Language: SQL, Expertise: Beginner — Learn to easily add a number of months to a date in Oracle SQL with the ADD_MONTHS function.



Remove a Constraint from a Table in Oracle SQL

Wed, 22 Mar 2017 06:37:00 -0700

Language: SQL, Expertise: Beginner — Learn how to remove constraints that have been set up to enforce business rules on a database.



Built-in JSON Functions in SQL

Fri, 17 Mar 2017 06:22:00 -0700

Language: SQL, Expertise: Intermediate — Did you know that SQL has some very handy built-in JSON functions?



Find the Source Code of a Function or Procedure in Oracle SQL

Tue, 14 Mar 2017 06:36:00 -0700

Language: SQL, Expertise: Beginner — If you need to find the source code for a function or procedure in the database, it's easy to do in Oracle.