April 20, 2009
Cheat Sheet for SQL Server
I have been writing a lot of T-SQL Scripts for SQL Server for a client to migrate to a new database schema. Whenever I get deeply involved in something like that I find that it is handy to create a cheatsheet for all of the things you have to lookup in the docs.
February 16, 2007
Use Char instead of Varchar to Store UUID's
I know a lot of developers like using UUID's for primary keys instead of integers. But one thing I see alot is the use of the varchar datatype to store these strings.
November 01, 2006
Sphinx - Open Source SQL Full Text Search Engine
I came across Sphinx today via the MySQL Performance Blog (which has some good entries you might want to check out). It is an Open Source Full Text SQL Search Engine.
May 11, 2006
Google Video: MySQL Performance Tuning Best Practices
Jay Pipes is a co-author of the recently published Pro MySQL recently spoke at Google on MySQL Performance Tuning Best PracticesYou can check out a video of the presentation on Google Video
There is also a good video from Google called The Paradox of Choice:
March 28, 2006
Updated SQL Reserved Words Checker
I just updated my SQL reserved words checker to include a few new words from MySQL 5 that it wasn't picking up.I use the tool when I'm designing a database table, or column. It can tell you if a value is a reserved word in MySQL, PostgreSQL, Oracle, or SQL Server.
October 31, 2005
Oracle's Free Database Server
I just noticed today that Oracle has released a beta edition of Oracle Database 10g Express Edition. Oracle must be feeling the pressure from open source databases such as MySQL, and PostgreSQL, just like Microsoft has.
September 29, 2005
MySQL FULLTEXT Indexing and Searching
MySQL has supported FULLTEXT indexes since version 3.23.23. VARCHAR and TEXT Columns that have been indexed with FULLTEXT can be used with special SQL statements that perform the full text search in MySQL.To get started you need to define the FULLTEXT index on some columns.
September 14, 2005
EnterpriseDB - PostgreSQL with Oracle Compatibility
I have been hearing a bit of buzz about EnterpriseDB latley. I think the main reason is that they just secured $7 million in venture capital funding.What is EnterpriseDB?
EnterpriseDB is based on the source code for the open source PostgreSQL database server.
September 14, 2005
SQL to Select a random row from a database table
There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.
August 02, 2005
Insert Delayed with MySQL
I just discovered that MySQL has some handy optimization hints, and commands that you can pass in your SQL statements. Since there is a lot to cover with each tip, I will be posting them in separate blog entries. I have already written about the MySQL Query Cache optimization hints.
June 21, 2005
The MySQL Query Cache
I have been reading about MySQL's Query Caching features in the High Performance MySQL book, and on the web. I have also been playing around with it on my own. I have concluded that it is a pretty cool feature! You will need MySQL 4.0.1 or higher to play...
June 10, 2005
Multiple Inserts with MySQL
Andy Jarrett posted this technique for insterting multiple rows (bulk insert) in one SQL statement a few months ago.
April 08, 2005
Related Posts
As you may have noticed I recently added tags to my blog. The main reason I implemented tags was so that I could find related posts based on mutual tags. So if two posts have similar tags, they will show up in as related.
March 28, 2005
SQL Reserved Key Words Checker Tool
I just whipped together a tool for checking for reserved sql words. The tool checks against SQL Server 2000, MySQL 5.0, PostgreSQL 8.0, Oracle 10g, ODBC, and SQL Server Future Keywords list.
March 18, 2005
Prepared Statements with JDBC
To prevent SQL Injection Hacking with JDBC, you simply just need to use Prepared Statements, this is pretty easy to, just use a PreparedStatement object instead of a Statement Object, in your SQL replace your variables with ?
January 12, 2005
Understanding MSDE 2000's Limitations in Web Applications
If your using Microsoft's light weight version of SQL Server MSDE for a web application you should understand the limitations, so you can properly configure your database connection.
October 06, 2004
Finding Duplicates with SQL
Here's a handy query for finding duplicates in a table.
