Re: Oracle Closed World

From: <>
Date: Fri, 22 Jun 2012 22:07:52 -0700 (PDT)
Message-ID: <>

On Thursday, June 21, 2012 2:39:06 PM UTC-4, joel garry wrote:
> Everyone should know by now Larry bought a Lanai:
> Best comment I've seen: "let's be honest, if he rocks a jetpack to
> work, he's probably better than most of us ;-) "
> 2nd: "Do you really want to start an Oracle vs SQL Server debate on a
> CNN forum"
> jg
> --
> is bogus.

I forced myself to learn SQL Server last year by getting a SQL Server 2008 DBA Certification (Microsoft Certified Technology Professional). I found book by Tim Carpenter to be pretty good plus lots of blogs on SQL Server 2008 on internet. While SQL Server 2008 and now 2012 are very close to Oracle in terms of DBA features (except it does not have RAC ); I found SQL Server t-sql to be far behind Oracle's PL-SQL.  T-SQL even does not have a for loop, it only has while loop. There is no if then elseif only if then else. It does not have any record type.. t-sql is very primitive. While t-sql has a debugger within SSMS, one needs sysadmin (DBA) privileges, god knows why?, which makes it very difficult to debug t-sql program in my company’s environment where data center does not give sysadmin proivileges . I guess Microsoft SQL Server team does not want people to use t-sql all that much, instead use .NET programming languages, It does provide CLR based stored procedures, I am trying to figure out how to use them in my work... Received on Sat Jun 23 2012 - 00:07:52 CDT

Original text of this message