pf » Tag: sqlserver on Pete Freitag's Blog

I've known about the INFORMATION_SCHEMA views (or system tables) in SQL Server for a while, but I just leared recently that they are actually part of the SQL-92 standard and supported on other database platforms.

Sometimes you need to think backwards.

Here was the problem. I needed to match up some IP address ranges to the company that owns them.

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.

I posted about doing fast bulk inserts with PostgreSQL last week, and with MySQL a while back. Now its time for Microsoft SQL Server.

I'm using a technique similar to what I used for PostgreSQL for SQL server.

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.

I have given up hope for installing SQL Server 2005 Express on my computer. When I run the installer I get this message:

SQL Server 2005 Beta 3 Setup has detected incompatible beta components from Visual Studio or SQL Server.

Microsoft is Expanding their SQL Server 2005 Product Line, with the introduction of SQL Server Workgroup Edition. These new price points are no doubt in response to open source database competitors such as MySQL and PostgreSQL.

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.

If your looking for a JDBC driver for SQL Server that will work on multiple platforms, and is free - take a look at jTDS. The jTDS project also claims that it is the fastest JDBC driver for SQL Server, based on these benchmarks.

I recently switched a database server from Microsoft SQL Server over to PostgreSQL.