Announcing the SQL Server Code Name “Denali”
Bill Inmonn started the BI revolution if you want to call it a
revolution and started the creation of a new IT solution in Data warehousing
and BI.
Microsoft is developing a new great
improvement on SQL Server 2008 R2, called SQL Server Code Name Denali (which
might be SQL Server 2011). What is it and how can it help you improve your
Business results. Watch the demo video below for more information.
Now that you have watch the video, you
might wonder why should I choose Microsoft and not Oracle OBIEE 11gR1 or IBM BI
on System z with Linux z and Cognos? Here are some reasons Microsoft can give
you!
Top 10 Reasons to Choose SQL Server
#1
Microsoft DBAs run more mission critical databases, when
compared to Oracle DBAs.
Source:
Microsoft SQL Server and Oracle Database: A Comparative Study on Total Cost of
Administration (TCA)
#2
SQL Server delivers six nines (99.9999%) uptime
availability.
Source: Microsoft
Case Study: Stratus Technologies
#3
SQL Server is the most secure of any of the major database
platforms.
Source: ITIC:
SQL Server Delivers Industry-Leading Security, Sept 2010
#4
SQL Server is the uncontested leader in TPC-E Performance
Benchmarks.
Source: TPC-E
Top Ten Performance Results
#5
SQL Server delivers a 460% savings in annual cost of
administration per database over Oracle.
Source:
Microsoft SQL Server and Oracle Database: A Comparative Study on Total Cost of
Administration (TCA)
#6
Microsoft is positioned as a leader in Magic Quadrant for
Business Intelligence Platforms.
Source: Gartner,
Magic Quadrant for Business Intelligence Platforms, January 27, 2011
#7
Microsoft outpaced the Business Intelligence software market
with 23.6% growth based on revenue in 2010.
Source: Gartner,
Market Share: All Software Markets, Worldwide, 2010, March 30, 2011
#8
SQL Server overtakes IBM DB2 to claim no. 2 spot in 2009 RDBMS
license revenue.
Source: IDC WW
RDBMS 2009 Vendor Analysis: Top 10 Vendor License Revenue by Operating
environment, August 2010
But offcourse IBM is still not bad either, they have a great
offering on Linux z on their System z Servers. Linux is very stable and fast
and with the development of BtrFs file system for Linux which has approximately
the same advantages as ZFS file system on Unix, you have a cheap and stable and
state of art file system with encryption as well:
Business
Intelligence
Make faster, better
decisions using Linux on System z
IBM Cognos BI for Linux on
System z, combined with the IBM Information Server and other IBM information
management products, such as IBM DB2, IBM DataQuant, IBM DB2 Alphablox or IBM
DB2 Connect allow you to build a comprehensive Information On Demand /
Information as a Service solution on System z
Beside IBM DB2 for
z/OS, additional data bases are available on Linux on System z, such as IBM DB2
for Linux2, IBM Informix Dynamic Server, Oracle DB or open
source data bases, can seamlessly integrated in the data processes. Data from
Lotus Domino applications can be integrated as well.
Here is a short video about their Cognos 10 version.
#9
PowerPivot was voted one of eWeek's Top 10 Technologies of
2010.
Source: eWeek
2010 Products of the Year: Messaging and Collaboration
#10
SQL
Server reduces downtime by over 20% by migrating an SAP ERP environment to SQL
Server.
Source:
Microsoft SQL Server TCO Study for SAP ERP Customers
But
is SQL Server Denali the best choice for you. A can be seen in my previous
blog, Oracle OBIEE 11gR1 saves you 7
cents per transaction on an HP Server. With the new generation EXADATA server racks you are even cheaper by the cost
per transaction and have the best performance, stability and lowest TCO
possible with software written for the hardware deliverd.
Quote:
Monday, January 31, 2011
Gartner Magic Quadrant for BI Platforms 2011
Gartner, a well-recognized information
technology research and advisory company, published its Magic Quadrant
for Business Intelligence Platforms (link to Oracle reprint, this is
the permanent link)
for 2011, Gartner RAS Core Research Note G00210036, authored by Rita L. Sallam,
James Richardson,
John Hagerty,
and Bill Hostmann.
Oracle, unsurprisingly,
continues to be positioned in the "Leaders Quadrant", for the fifth
year running.
Here are some excerpts
from the Gartner Research Note (emphasis mine):
Oracle
customers indicate they deploy the Oracle Business Intelligence Suite
Enterprise Edition (OBIEE) platform to support among the most complex
deployments in our survey. Their scope of deployments tends to be the widest
across an enterprise — regionally/nationally and globally deployed versus in a
single or multiple departments — while OBIEE supports, on average, among the
largest numbers of users, the highest data volume, broadest product
functionality use, and highest complexity of analytic workload.
Oracle's
OBIEE platform is considered the BI standard in more of its customers'
organizations (survey respondents) than any other vendor's platform (considered
a standard in 85% of their organizations compared to the survey average of
56%).
Some links on Oracle BI:
Here is a small demo video for you:
As
you can see there is more to BI then meets the eye, multiple vendors with good
products with Dashboards that are great looking and with all the information
you need at hand. Should you choose Microsoft, Oracle or IBM solution, or even
an other solution like SAS, it all depends on your needs and what your current
license costs are and what knowledge is available at you company site for
maintenance and extension. For an objective and custom advice about BI renewal
or implementation please contact DBA Consulting at info@dbaconsulting.nl
This comment has been removed by the author.
ReplyDeleteNice work, keep on posting.Videos gives essential knowledge about server racks.
ReplyDeleteServer Racks