The Forrester Wave™: Agile Business Intelligence Platforms, Q3 2015

Forrester made Microsoft LEADER in terms of being able to provide Agile Business Intelligence (Q3 2015)! Whoooyaaahh!
Meer info, click here.

Forrester Wave Agile Business Intelligence Platforms Q3 2015

 


 


 


 


 


 


 


 

And don’t forget, we’re also leader in terms of: Gartner’s Magic Quadrant for Operational Database Management Systems (2015)

 


 


 

Advertisements

Gartner’s Magic Quadrant for Operational Database Management Systems (2015)

Whoooyah…Microsoft is number 1, numero uno 🙂

Gartner Magic Quadrant for Operational Database Management Systems 2015

 

 
Read the full article here:
http://www.gartner.com/technology/reprints.do?id=1-2PMFPEN&ct=151013&st=sb

Microsoft
Headquartered in Redmond, Washington, U.S., Microsoftmarkets its SQL Server DBMS for the operational DBMS market, as well as the Microsoft Azure SQL Database (a DBMS platform as a service), and the NoSQL DBMSs Microsoft Azure DocumentDB and Azure Tables.

 

Strengths

  • Market vision:

Microsoft’s market-leading vision consists of NoSQL (Azure DocumentDB and Azure Tables), cloud offerings (including hybrid cloud), the use of analytics in transactions (HTAP) and support for mobility. Its vision for in-memory computing across products, hybrid cloud implementations and a “cloud first” strategy is ahead of its competitors.

  • Strong execution:

Microsoft SQL Server is an enterprisewide, mission-critical DBMS capable of competing with products from the other large DBMS vendors. Gartner’s 2014 market share data shows Microsoft as the No. 2 vendor in terms of total DBMS revenue.

  • Performance and support:

Reference customers were very positive, with the performance of SQL Server, documentation, support, ease of installation, integration and operation all rated highly.

Cautions

  • Market image:

Although SQL Server is an enterprise-class DBMS, Microsoft continues to struggle to dispel a perception of weakness in this area. Inquiries from Gartner clients demonstrate a continuing perception that SQL Server is not used for mission-critical enterprisewide applications — a view that inhibits wider use of SQL Server as a primary, enterprise-class DBMS.

  • Lack of an appliance:

Microsoft still lacks an appliance for transactions (one comparable to its Microsoft Analytics Platform System, formerly Parallel Data Warehouse). By contrast, its major competitors (IBM, Oracle and SAP) all offer one, as does one new entrant to the Magic Quadrant (Fujitsu).

  • Pricing:

Microsoft received below-average ratings for pricing suitability, a problem that stems from the pricing model changes implemented in SQL Server 2012. Microsoft’s cloud offerings appear to be partially mitigating this concern.

 
 

SOLVED: Unable to retrieve column information / metadata (SSIS)

Here’s another annoying thing that might happen when a stored procedure is too ‘complex’ for SSIS:
"The metadata could not be determined because every code path results in an error..."
"Unable to retrieve column information from the data source. Make sure your target table in the database is available"

SSIS unable to retrieve column information metadata

 

Simply said, it needs help regarding the metadata.
One way to do this is to provide SSIS the necessary metadata information. As shown below:

Introduction

Microsoft SQL Server 2012 extends the EXECUTE statement to introduce WITH RESULT SETS option which can be used to change the Column Name and Data Types of the result set returned by the execution of stored procedure.

Example Using WITH RESULT SETS Feature of SQL Server 2012

/*
Example - Using WITH RESULT SETS Feature of SQL Server 2012
*/
EXEC WithResultSets_SQLServer2012
WITH RESULT SETS
(
(
[Employe Name] NVARCHAR(100),
[Employee City] NVARCHAR(20),
[Employee Postal Code] NVARCHAR(30)
)
)
GO

Conclusion

The WITH RESULT SET Feature of SQL Server 2012 is a great enhancement to the EXECUTE Statement. This feature will be widely used by Business Intelligence Developers to execute a stored procedure with in an SQL Server Integration Services (SSIS) Package to return the result set with required Columns and modified data types.

Read more: http://www.mytechmantra.com/LearnSQLServer/With-Result-Set-Feature-SQL-Server-2012.html#ixzz3nybyEcJU