Category Archives: SQL Server features

POWER BI For Excel & Office 365

It’s easier than ever to transform complex data into meaningful insights and share them with your team. Power BI is a powerful new way to visualize and interact with data in Excel and Office 365. Search, discover, and with just … Continue reading

Image | Posted on by | Leave a comment

Self-Service BI using PowerPivot and Power View

A powerful solution that provides users of all levels with new insights through familiar Microsoft Office tools. Organizations can create compelling reports and analytical applications, easily share insights, and collaborate with colleagues. See following presentation for detail about products overview: … Continue reading

Posted in SQL Server features | Leave a comment

Microsoft Business Intelligence at a Glance Poster

The poster summarizes the benefits of Microsoft’s BI technologies and depicts them by layer: client (such as BI in Excel), the presentation subsystem (such as SharePoint 2013), information sources (such as Reporting Services), and data sources (such as relational databases). … Continue reading

Posted in SQL Server features | Leave a comment

SSIS for Azure and Hybrid Data Movement

SQL Server Integration Services (SSIS) can be used effectively as a tool for moving data to and from Windows Azure SQL Database, as part of the total extract, transform, and load (ETL) solution and as part of the data movement … Continue reading

Posted in SQL Server features | Leave a comment

SQL Server 2012 Edition Highlights

Image | Posted on by | Leave a comment

Microsoft In-Memory Move Challenges SAP, Oracle

Microsoft SQL Server “Project Hekaton” promises in-memory transactional processing that will stack up against SAP Hana and Oracle Exadata. http://www.informationweek.com/software/information-management/microsoft-in-memory-move-challenges-sap/240062566

Posted in SQL Server features | Leave a comment

xVelocity in-memory technologies in SQL Server 2012 for 10-100X performance

xVelocity is a family of memory-optimized technologies spanning Analytical, Transactional, Streaming and Caching data. Designed for industry standard hardware, xVelocity is a built-in capability in SQL Server 2012, SQL Server Parallel Data Warehouse, Office Excel 2013 and Windows Azure. The … Continue reading

Posted in SQL Server features | Tagged | Leave a comment