Power Pivot and other self-service BI tools are not a replacement for a data mart or data warehouse. When used correctly for Personal BI, Team BI, prototypes or proofs-of-concept, you can achieve truly agile, rapid reporting success with Excel Power Pivot.
Microsoft's newly-announced Analytics Platform System lets users query across both traditional relational data warehouses and data that's stored in a Hadoop region for better manageability and flexibility of your data....More
A recap of this week's news on SQL Server Pro, including insights on Microsoft's strategic direction for SQL Server, the impact of the Heartbleed vulnerability, and happenings at this week's Red Hat Summit conference....More
At the Red Hat Summit in San Francisco, the company announced how its integrating its OpenShift solution into the Hortonworks Data Platform to increase the speed of Big Data application development....More
American Megatrends recently announced the availability of its StorTrends iDATA tool, where organizations can get a handle on their entire IT infrastructure's performance, capacity, and throughput requirements....More
In the news today is a survey of databases in use, the release of Forerunner Mobilizer to manage SQL Server Reporting Services across mobile devices, and OpenShift by Red Hat's plans to add SQL Server support to its cloud platform.
Power Pivot and other self-service BI tools are not a replacement for a data mart or data warehouse. When used correctly for Personal BI, Team BI, prototypes or proofs-of-concept, you can achieve truly agile, rapid reporting success with Excel Power Pivot....More
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More