Subscribe: DevX: Latest Database Content
Preview: DevX: Latest Database Content

DevX: Latest Database Content

Published: Mon, 25 Sep 2017 23:07:46 -0700

Last Build Date: Mon, 25 Sep 2017 23:07:46 -0700


Using FILEPROPERTY to Check for Free Space in a Database

Thu, 21 Sep 2017 03:38:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to use FILEPROPERTY to check for free space in a database.

Using the Replace Command in MySQL

Wed, 20 Sep 2017 03:03:00 -0700

Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.

Identify All the Foreign Keys in Your Database

Thu, 14 Sep 2017 03:35:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.

Import Large SQL Files into MySQL

Wed, 13 Sep 2017 03:06:00 -0700

Language: SQL, Expertise: Intermediate - Follow these steps to import large SQL files into MySQL.

Get All Tables Referenced by at Least One View

Thu, 07 Sep 2017 03:30:00 -0700

Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.

Disabling AutoCommit in JDBC

Tue, 05 Sep 2017 01:16:00 -0700

Language: Java, Expertise: Intermediate - Learn why it is unwise to commit after every insert.

Get Stored Procedure Content and Details

Thu, 31 Aug 2017 03:50:00 -0700

Language: .NET, Expertise: Intermediate - This query can be used to get details regarding stored procedure content.


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.