Share

Find all tables with specific column name

• On: May 25, 2014
• 0 Comments

Ever need to find out if or where a column exists ...

Share

PHP POST method not posting “type=file” variable

• On: May 8, 2014
• 0 Comments

I am updating some old PHP to move away from global variables ...

Share

MySQL Fulltext Index not working

• On: May 5, 2014
• 0 Comments

I recently moved from a standard wildcard search of my news ...

Share

Update value from SUM(values) in another table

• On: March 6, 2014
• 2 Comments

I recently found myself forgetting the exact syntax to update a ...

Share

Find text in Stored Procedures

• On: January 14, 2014
• 0 Comments

I can't express how useful this has been to me when ...

Share

Most Active Databases in SQL Server

• On: November 17, 2013
• 0 Comments

I recently had someone ask what the most active databases were ...

Share

Add a column with a default and foreign key constraint

• On: October 15, 2013
• 0 Comments

Every so often you may be presented with the requirement to ...

Share

Delete rows in Excel from a list

• On: June 30, 2013
• 0 Comments

I had the need recently where I was provided an Excel ...