Databases Tutorials & Guides

Transact-SQL 24 May 2013

T-SQL concatenate an incremental row number

This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist:

Read note → 30,379 hits

Transact-SQL 14 May 2013

T-SQL Conversion failed when converting the varchar to data type int

A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How?

Read note → 63,112 hits

MySQL 17 Mar 2013

Country Lookup by IP address CSV

So this is an article to serve as documentation for one of the data sources available to download for FREE from this site.

Read note → 35,067 hits

Databases 08 Mar 2013

Restore MSSQL Error: Database is in use

This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL connected processes as well.

Read note → 31,723 hits

Oracle PL/SQL 04 Mar 2013

Fix Oracle Tnsping 3511 without Windows Registry

So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file f...

Read note → 55,186 hits

MySQL 05 Feb 2013

Export/Import Database using MySQL Workbench

This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.

Read note → 38,447 hits

MySQL 03 Feb 2013

Quickly update all content in mySQL database replacing a string

This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author.

Read note → 25,177 hits

MySQL 01 Feb 2013

Access MySQL databases using Oracle SQL Developer

So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.

Read note → 41,663 hits

Databases 31 Jan 2013

Cheat Sheet for mySQL vs t-SQL

Some memory aids for me so that I don't have to keep looking them up:

Read note → 32,421 hits