Cheat Sheet for SQL Server

databases 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.


This entry was:

Use Char instead of Varchar to Store UUID's

databases 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.


This entry was:

Sphinx - Open Source SQL Full Text Search Engine

databases 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.


This entry was:

Google Video: MySQL Performance Tuning Best Practices

databases Jay Pipes is a co-author of the recently published Pro MySQL recently spoke at Google on MySQL Performance Tuning Best Practices

You can check out a video of the presentation on Google Video



There is also a good video from Google called The Paradox of Choice:


This entry was:

Updated SQL Reserved Words Checker

databases 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.


This entry was:

Oracle's Free Database Server

databases 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.


This entry was:

MySQL FULLTEXT Indexing and Searching

databases 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.


This entry was:

EnterpriseDB - PostgreSQL with Oracle Compatibility

databases 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.


This entry was:

SQL to Select a random row from a database table

databases 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.


This entry was:

Insert Delayed with MySQL

databases 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.


This entry was:

The MySQL Query Cache

databases 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...


This entry was:

Multiple Inserts with MySQL

databases Andy Jarrett posted this technique for insterting multiple rows (bulk insert) in one SQL statement a few months ago.


This entry was:

Related Posts

coldfusion databases 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.


This entry was:

SQL Reserved Key Words Checker Tool

databases 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.


This entry was:

Prepared Statements with JDBC

java 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 ?


This entry was:

Understanding MSDE 2000's Limitations in Web Applications

coldfusion databases 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.


This entry was:

Finding Duplicates with SQL

databases Here's a handy query for finding duplicates in a table.


This entry was:

foundeo


did you hack my cf?