Re: Oracle Closed World

From: TheBoss <>
Date: 27 Jun 2012 23:17:03 GMT
Message-ID: <XnsA080D12810ECTheBossUsenet_at_194.109.133.133> wrote in

> On Wednesday, June 27, 2012 3:35:31 AM UTC-4, Matthias Hoys wrote:

>> On Saturday, June 23, 2012 7:07:52 AM UTC+2, (unknown) wrote:
>> > 
>> > I forced myself to learn SQL Server last year by getting a SQL
>> > Server 2 

> 008 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 al 

> l 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...
>> I used to work with SQL Server 2000. One of the biggest Belgian banks
>> at 

> that time used it as back end for their corporate website. One of the
> problems with SQL Server then was that it was not always easy to track
> down performance problems. You had the MS performance counters and the
> SQL Profiler and that was about it. No extended wait interface and
> dynamic views like Oracle has. I don't know if that has improved with
> the recent version of SQL Server?
>> Matthias Hoys

> SQL Server 2008 has something called Performance Studio which is
> similar to Oracle's AWR. SQL Server is trying to provide everything
> which Oracle has, only thing they do not have is RAC, <...>

Actually they do have RAC:

Just kiddng...
But serious: RAC isn't a 'feature' in itself, it's Oracle's attempt to implement a 'feature' (if scaleability can be called that way), and not everyone is convinced it is as useful as Oracle wants us to believe it is.

Received on Wed Jun 27 2012 - 18:17:03 CDT

Original text of this message