Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-01 : 08:14:12
|
| Sukh writes "Hi I'm an Oracle DBA but new to SQL Server. Would anyone of you guys advise me what book should I refer to learn SQL Server?? I want to learn the ins and outs of it.RegardsSukh" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-01 : 08:24:00
|
| I found this:http://www.chriskempster.com/From a very favorable review here:http://www.sql-server-performance.com/sql_2000_for_oracle_dbas_review.aspGoogling "sql server for the oracle dba" will bring up other resources as well.My own limited experience with Oracle is enough to tell you: the SQL syntax is significantly different between the two. PL/SQL does things ENTIRELY differently from Transact-SQL. Triggers especially. You do yourself a disservice to use an Oracle methodology in SQL Server. I'd also say that before you lament or criticize the lack of an Oracle feature in SQL Server, consider the notion that the particular feature may not be necessary. SQL Server can do some pretty amazing things, and sometimes it's just different from Oracle. Don't fall for the arguments in crap like this:http://www.wisdomforce.com/dweb/resources/docs/MSSQL2005_ORACLE10g_compare.pdf |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-01 : 19:39:53
|
| I would also pick up Inside SQL Server 2000 by Kalen Delaney. You might as well start learning it right.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-01 : 19:43:57
|
| <smacks head as harshly as possible> Yes, Derrick is right, that's a must-read </smacks head as harshly as possible> |
|
|
|
|
|
|
SQL Server Administration Books