Project Siena – Create apps with Excel and PowerPoint skills

Siena apps are as easy as editing a document. You place some visuals on a canvas. You hook them up to your data. You customize how your app looks and works. Then, if you need special logic and intelligence, you write some Excel-like expressions. You can use your app immediately, or share it with colleagues…


SQL Server 2014 – CTP2 is now available

CTP2 can be downloaded at Highlights in this release are 1. Report Builder and Power Pivot  is now available in different languages 2. .Differential backup on a database with in-memory tables backs up all data/delta files is not just differential. This means if in-memory tables are comprised of a significant portion of database…



Most database users are proud to say that they have worked on databases of large size.  For business processes, laying out the table structure with the data-types is an important skill called modeling.   In this new generation of applications (apps), developer community is looking at easy to use, no overhead to deal with small…


PowerBI – complete Self Service BI solution in Excel

Power BI is a self service and intuitive solution for all of your data needs delivered in Excel. New data discovery, Analysis and Visualization are provided in Excel Powerful Online Search returns results from within your organization and valuable external data sources which you can combine for easier analysis Continue to add to your data…


Oracle partners with Microsoft

Microsoft and Oracle today announced that they are putting their differences aside to strike a strategic partnership in the cloud enterprise space. The deal covers both the private cloud and the public cloud, encompassing multiple new options. Firstly, Oracle will certify and support customers who already run its software on Windows Server to run that…


Microsoft SQL 14 CTP1 Product Guide

Look at some teasers below to check out what is new in SQL 2014 Create statement DDL now as the following options   Database Administrators cannot see users data, but can do DBA tasks such as Database backup   For more details check out Product Guides for SQL 2014 which are available at  …


Forecasting Sales data with Excel mining – Step by Step Guide

Mining is a service and can be coded.  This means that it is enterprise ready. Mining can be done using Excel SSDT PowerShell and SSMS Analysis Services service should be “ON” for mining to run Using a combination of basic PowerPivot and Mining Plugins for Excel 2013, let us create a forecasting model. Open Excel…


Getting started with Self Service BI using Power View

Self Service BI capability is “THE” thing that senior executives want. IT on the other hand want it too. No matter how often the report format has been scrutinized there is always a tweak required which wouldmake the IT team very transactional and operational. Reporting tools no doubt have evolved over a period of time….