SQL Server 2008 vs. Oracle .. and so it begins….

 

Microsoft has the gloves off and is ready to rumble.

It proudly shows 6 compelling reasons to switch to SQL Server from Oracle on their Microsoft in Government site.

http://www.microsoft.com/industry/government/products/server/sql2008.mspx#WhySwitch

 

Has Microsoft really surpassed Oracle?

 

Well their site claims so..:

  SQL Server 2008 Oracle

Performance and Scalability

1

1

Business Intelligence

1

Total Cost of Ownership

1

Stronger Partner Ecosystem

1

Better Together with Microsoft Office

1

Security

1

 

Total

6

1

 

Round 2 of the Database wars appears to be on. Microsoft appears to have taken the first shot!

StreamInsight in SQL Server 2008 R2

 

REAL TIME REPORTING, not NEAR, NOT Yesterday.. NOW!

SQL SERVER 2008 R2, a bold new era of some great new features. I wanted to share one that I have been looking at recently.

STREAMINSIGHT

The short of it is that you can now monitor a real time data stream for reports and or alerts. This has been a long time coming and finally closes an open hole in the Microsoft reporting strategy.

Recently one of Microsoft’s ISV’s talked about how much it saved them being able to monitor the real time stream, rather than storing all of the data, they were able to store exceptions, and averages saving 100’s of gigabytes of data per day.

 

http://www.microsoft.com/sqlserver/2008/en/us/R2-complex-event.aspx

CEP-Runtime[1]