Re: Oracle Closed World
From: TheBoss <TheBoss_at_invalid.nl>
Date: 27 Jun 2012 23:17:03 GMT
Message-ID: <XnsA080D12810ECTheBossUsenet_at_194.109.133.133>
zigzagdna_at_yahoo.com wrote in
news:296c7b95-ac6a-4876-a94a-686b7e26fc03_at_googlegroups.com:
> 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.
> 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 .
> 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...
> 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?
>
>
> 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, <...>
Date: 27 Jun 2012 23:17:03 GMT
Message-ID: <XnsA080D12810ECTheBossUsenet_at_194.109.133.133>
zigzagdna_at_yahoo.com wrote in
news:296c7b95-ac6a-4876-a94a-686b7e26fc03_at_googlegroups.com:
> 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:
http://www.rac4sql.net/
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.
-- JeroenReceived on Wed Jun 27 2012 - 18:17:03 CDT