User Group Meeting–Microsoft Power BI

by inzeek on May 26, 2016

Just a short post to share that I will be speaking at the Brunei Cloud User Group meeting this Saturday (28th of May). The meeting will happen at Brunei e-Government National Centre, from 2PM to 4PM. You can read more about other sessions at the official site: .

User Group Meeting - May

Microsoft Power BI – On Premises

by inzeek on February 20, 2016

By experience, on premise reporting is a strong and valid requirement from most of our existing and potential customers. Specially, in Governments, they do really want to keep the data within borders due to the data sovereignty compliances.

Microsoft Power BI (one of the leaders in Gartner Magic Quadrant for Business Intelligence and Analytics Platforms – 2016) currently doesn’t provide any native capability to deploy/publish Power BI reports into on premises reporting platform.

Power BI does not provide deployment option to publish Power BI dashboard/reports into the on premises/ private cloud reporting platform.

Work around:
Power BI allows you to publish the Power BI Desktop files into the locally hosted Pyramid Analytics server (3rd party solution). It allows you to keep your reports within the enterprise (based on rules and regulations) rather than Microsoft hosted cloud environment. Surely this workaround doesn’t provide the most cost effective solution as you have to purchase the Pyramid Analytics as well.

Pyramid Server

(Power BI evolved from Power View. In fact you can create Power View reports in Microsoft SharePoint. But I don’t consider it is a reliable solution as Power BI heavily rely on Microsoft Silverlight)

The good news is on premises Power BI deploy option is currently in product roadmap. In future, you will be able to deploy your Power BI desktop files into the on premises Microsoft SQL Server Reporting Services (SSRS).

“This modernized SSRS web experience delivers the foundation for centralized report consumption, embedding and sharing of BI reports for those organizations that desire an on-premises option (versus using Power BI in the cloud).” (Read More)

I really encourage you to try SQL Server 2016 (CTP) SSRS. You will be amazed with awesome features like solid reporting services web portal, mobile report publisher and access through Power BI mobile app, PowerPoint rendering and export, HTML 5 rendering engine and many more.

Note: Microsoft Power BI lets you connect to on premises data sources and refresh datasets connecting to on-premises sources such as SQL Server, Oracle, Files (CSV, XML, etc.)Microsoft Power BI lets you connect to on premises data sources and refresh datasets connecting to on-premises sources such as SQL Server, Oracle, Files (CSV, XML, etc.). And also, with Power BI provided Analysis Services Connector, we can create live connection to an Analysis Services (SSAS) tabular model database located on-premises.

Microsoft SQL Azure Overview

by inzeek on April 9, 2012

I have prepared this slide show for next Brunei User Group (BUG) meeting. This is the first presentation of Microsoft SQL Azure series. In this presentation, I focused on giving very basic introduction about Microsoft SQL Azure plus related services, but gradually moving to the advanced topics with upcoming sessions.

SQL Azure Overview from inzeek

My 3rd book review: "Entity Framework (EF 4.1) Expert Cookbook"

by inzeek on March 30, 2012

“This book is for intermediate to advanced .NET developers who have used LINQ to SQL or Entity Framework in some form but want to have more control over the implementation”.


And also this “Entity Framework (EF 4.1) Expert Cookbook” book gives an excellent step-by-step problem solving approach and explains each step in detail with expert view plus sample code.

Devlin and Tim introduce some popular and common problem and then design to solution approach that gives you a truly depth knowledge. Their writing style is very entertaining and it will let you to follow the whole chapter very easily.

What you will learn from this book:

  • Manage database queries
  • Leverage the full power of LINQ
  • Test the data access layer
  • Design an extensible data access layer
  • Map any object model to a relational database
  • Create clean integration tests
  • Test queries in memory
  • Compose even the most complex query scenarios
  • Create and seed test databases from code
  • Use stored procedures without losing the power of object oriented development

I recommend this book to anyone who wants to get an in-depth understanding of Microsoft .NET Entity Framework (EF).

You can purchase the book via Amazon.

Working with Team Foundation Server Azure and Visual Studio 11 Developer Preview

by inzeek on October 14, 2011

Team Foundation Server on Azure or TFS Service, the most exciting product previewed at the “Build Windows 2011” conference. In simple terms, running Microsoft Team Foundation Server hosted on Windows Azure platform.

In this article, I am not going to write any comprehensive overview about TFS Azure, but step by step guide on how to connect to TFS Azure using Visual Studio 11 developer preview.

In order to get start with TFS Azure, you need to register with

Step 01:

In TFS Azure home page, you can see your TFS Account URL. You will have to use this link as a name or ULR of your Team Foundation Server.

* Currently, you can have only one TFS Azure account under single Windows Live ID.


Step 02:

Now you need open the Microsoft Visual Studio 11 Developer Preview IDE.


Step 03:

Click on the “Connect to Team Foundation Server” link in Start Page. You can use this link to connect either local TFS Server or TFS Service hosted on Windows Azure.

* If you are using Visual Studio 2010 SP1 to to connect TFS on Azure, then you need to install hotfix KB2581206.


Step 04:

After clicking on Add button, now you need to enter or paste your TFS Account URL (see Step 01). Ex:">https://<myaccount>

*In this window, There is no requirement to specify the Team Collection name or Team Project name.


Step  05:

Once you click on the “OK” button, you will see the “Sign-In to Team Foundation Server” window. This is where you enter the TFS Azure login credential details.

* Currently TFS Azure only supports Windows Live ID authentication service. Later Microsoft will support many more authentication services (Ex: corporate Active Directory service) under identity federation.


Step 06:


Step 07:

If you have any previously configured Team Projects in Default Collection, in this window you can select it.


Step 08:

Now you can see your favorite “Team Explorer”


Step 09:


Step 10:

Under Team Explore Settings section, you can perform many more operations like setting up group membership, changing work item alters, editing TFS process templates, etc.



Personally, I am really impressed about TFS Azure 11 developer preview. Specially about Microsoft approach of moving on-premises developer tools into the cloud (Azure). In this preview, you will see limited features, but Microsoft is working very hard on next release.  This is the right time to share your opinions and comments about this preview:

How to work properly with Microsoft Team Foundation Server 2010 – Offline mode?

by inzeek on May 10, 2011

AS Microsoft Team Foundation Server 2010 does support offline mode, lot of developers are willing go offline mode and continue their work (Ex: Working from home, etc.) Simply offline mode means TFS 2010 goes offline (disconnect the connectivity properly between your local machine and TFS 2010 server) while your solution is already open though VS 2010 IDE.

Recently, few developers complained about TFS 2010 server does not determine the changes they have done in offline mode. Yes, I agree with that point, but the issue is if you checkout files while you are in offline mode, then TFS 2010 source controls system doesn’t record or track any changes you made. To overcome this issue, you can follow below mentioned steps:

  • First, Check Out all the necessary files you want to edit.
  • Unbind your project properly – Offline (File – Source Control – Change Source Control – Select Solution – Unbind).
  • Edit your source files in offline mode.
  • Bind your project – Online (File – Source Control – Change Source Control – Select Solution – Bind)
  • Check In all the pending changes files (Right click on the Solution node in TFS Source Control Explorer – Check In).

Windows Azure AppFabric April release now available [New version of the Access Control service]

by inzeek on April 9, 2011

Windows Azure AppFabric team just released the Windows Azure AppFabric April release that includes a new version of the Access Control service. Now you can use the CTP features in production services. Note that new version of AppFabric ACS will run parallel with previous ACS [Existing customers will not be automatically migrated to the new version, and the previous version remains fully supported].

For more information visit the Windows Azure AppFabric team blog. And also you can you can get started with FREE trial offer.

WHO LEADS TOMORROW – Windows Azure Camps

by inzeek on April 8, 2011

Who Leads Tomorrow?If you are in India or in the region, this will be a good chance for you to learn Windows Azure including series of workshops, events and webinars on Cloud application development on the Windows Azure Platform.

More Information and Register NOW :

Microsoft MVP – Windows Azure

by inzeek on April 2, 2011

I just received a letter notifying me that I was awarded the Microsoft MVP (Windows Azure: Architecture) award for 2011. I’m much honored to receive the award again and this would be my third consecutive year as an MVP. Thanks to everyone who has helped and supported me in the last 12 months to get this award again….. MVPness – MVPship…. Thank you Microsoft.

SQL Azure DataSync

by inzeek on January 30, 2011

Microsoft SQL Azure Data Sync helps you to sync (bi-directional) data between SQL Azure and SQL Server. It enables the great power of sharing data with on-premises SQL Server databases and SQL Azure.


  • Link existing on-premises data stores to SQL Azure.
  • Schedule Sync: (you can set the time intervals)
  • Create new applications in Windows Azure without abandoning existing on-premises applications.
  • Extend on-premises data to remote offices, retail stores and mobile workers via the cloud.
  • Take Windows Azure and SQL Azure based web application offline to provide an “Outlook like” cached-mode experience.

Read More: SQL Azure Data Sync Wiki

Page 1 of 212