I was a SQL Server DBA on the 96th Floor of World Trade Center North Tower in 1992
By Kalman Toth, M.Phil., M.Phil., MCDBA, MCITP

July 10, 2005

The company was Deloitte-Touche. Going to work was like going to haven. Frequently work in the clouds. On bright days look out the huge windows and see people like ants! Yes they were like ants from the 96th floor. The Brooklyn Bridge (currently visible on the SQLUSA logo) was like a tiny toy bridge on a toy train set. My office had long, elongated windows from floor to ceiling, supporting steel beams in between. Standing close to the windows gave you a feeling of fear of falling: what if the thin glass breaks if I lean against it? Perhaps I should store a parachute in case I have to escape from a fire. I never did though. We dutifully drilled escaping fire through the stairs, usually 20 flights down. We never drilled all the way down 96 floors.

The version was around 4.2 or so. Interestingly enough a robust Transact-SQL was already there (it originated with Sybase on UNIX platform). It has more features now, but the basics were just like now: selects, inserts, updates, deletes, transaction control and sp_ system stored procedures like sp_who, sp_spaceused, sp_monitor and more.

The operating systems was IBM OS/2.

The predecessor of Enterprise Manager (or Management Studio in SQL 2005) was rather simple, mainly used for maintenance functions. Backup was called "dump" and restore was called "load".

The predecessor of Query Editor was called isql. Less fancy, but it had the basics: connection to the server, query window and results window. In fact you could connect to a Sybase database as well, and hardly tell the difference.

The OS/2 based SQL server was not nearly as powerful as SQL Server 2000. Processing tables with a million rows took great-great care. With a few careless stored procedures, you could kill the system.

At that time SQL server was in the category of "toy" database, next the UNIX-based heavy weights like ORACLE and SYBASE or the mainframe based DB2.

SQL server came along a very long way riding with the spectacular progress of Windows-based PC-s and servers.