Fog Creek Software
Discussion Board




sql server docs for oracle user

i have a long sordid history as an oracle and postgresql dba/programmer. i'm trying to wrap my brain around SQL server. what is a good book or online reference for sql server that assumes one already knows relational theory, and has a good handle on complex SQL?

i want to learn about sql server's stored procedures, sql language quirks, and most importantly, how to maximize efficiency using all the GUI tools.

thanks

rz
Friday, September 19, 2003

The first thing I'd look at is the Books Online documentation that comes with product.

Rick Childress
Friday, September 19, 2003

Managing SQL Server: Enterprise manager (right-click on a table, select "Query" and have some real fun that you can't have in Oracle!)
Writing SP's: Query Analyzer (most 'cause Enterprise Manager opens SP windows modally, which sucks)

F1: Books online, which are *awesome* (when you patch SQL Server, make sure you patch the BOL too)

Philo

Philo
Friday, September 19, 2003

Book online is great. I liked "Inside Microsoft® SQL Server™ 2000"  http://www.microsoft.com/mspress/books/4297.asp and also have the "Microsoft® SQL Server™ 2000 Administrator's Pocket Consultant " http://www.microsoft.com/mspress/books/4660.asp , but only because I got it nearly free.

Just me (Sir to you)
Saturday, September 20, 2003

*  Recent Topics

*  Fog Creek Home