Azure, AI, SP, .NET, Microsoft - Knowledge Base

Smart decision always make your life easier. Migrating to cloud or having your IT space in cloud is a smart decision, however, knowing how much exact cost your need to bear will be a smarter call. Microsoft Azure Cloud provides pricing calculator to its user to understand exactly how much cost it could be based on user's choices along with timeline. You can add anything from Azure Pricing Calculator page link, however a few handy url below for your quick references. Azure Pricing Calculator https://azure.microsoft.com/en-in/pricing/calculator/ Azure Product Pricing Feature -  https://azure.microsoft.com/en-in/pricing/#product-pricing Virtual Machine -  https://azure.microsoft.com/en-in/pricing/details/virtual-machines/linux/ App Service -  https://azure.microsoft.com/en-in/pricing/details/app-service/windows/ Azure Functions -  https://azure.microsoft.com/en-in/pricing/details/functions/ Blob Storage -  https://azure.microsoft.com/en-in/pricing/details/sto...

A long, may be very long demand from Power Apps developers, UI builders, is now Microsoft is going to fill by introducing Co-authoring feature in experimental basis. Microsoft announced on 1st November about this ad here the link - Experimental Co-authoring for Power Apps Studio | Microsoft Power Apps This is going to speedup the development phase, reduce the merging code in main app, and let the team work smartly and effectively. No doubt about this! Few things to remember ere, this feature is exclusively working for Power Apps Studios, and the changes merges asynchronously whenever click on save or sync option.  As this is on experimental basis rollout, so default this is turn off state. You need to take a step forward and turn on this feature. And feel free to submit your feedback - how this feature is working, what you like, what improvement you would like to see etc. So, let's be ready, and keep an eye on your Power Apps dashboard/App settings to see this feature is ready for ...

Migration is one of the horizontal line of business in SharePoint scope of work. Most of us having idea about migrating content and application from lower SharePoint version to higher version, or from on-prem to cloud. Many of us also familiar with non-SharePoint platform like Documentum or Lotus Notes to SharePoint migration. At very initial days, like SharePoint V2.0 i.e. WSS 2.0, we have seen and experienced mostly from non-SharePoint version to SharePoint version. Latter on, we have seen mostly from lower version to SharePoint higher version or to SharePoint online. Migrating from Lotus Notes to SharePoint is little bit more complicated, however there is one 3rd party tool named Quest . They have line of tools/product which can help you to migrate your stuff from Lotus Notes to Exchange/SharePoint/Office 365. Here the url for have a look at it -  https://www.quest.com/migration-manager/

Why we will choose Power Apps and where we can fit this? key benefits of the Power Platform solution v   Simple and automated system used by floor technicians to record inventory used on projects v   Easy for technicians to enter parts used as they work with mobile devices on the floor v   Timely, accurate and relevant data – reducing the amount of manual entry and rework v   Seamless reconciling process – listing inventory, drafting PO, sending invoice v   Easy for Manufacturing company to track the inventory that is sent to the customer with the model-driven app v   Reporting – PO Report for Jobs and inventory used, On-hand Inventory so customer knows what is in the warehouse, and the replenishment report which shows which items need restocking. v   Rule-based BPM Engine for Process Modelling – This is all about ability to manage complex workflows (either serial or parallel), breakdown phases for each process step, execution through r...

Databricks project originally initiated by UC Berkeley and then latter known as Apache Spark. It provides all analytics and Big Data processing service. Currently it is part of Microsoft and named as Microsoft Azure Databricks .  We are using Databricks in Azure platform as  a single platform for Big Data processing and Machine Learning. It provides data science and data engineering teams with a fast, easy and collaborative Spark-based platform on Azure.  In this post, I'll walk through how you can connect with Azure storage, read your files and write them in your Azure SQL. Basic Data Engineering steps. Implementing machine learning inelegancy or drill down level data aggregation is out of scope. Let's start by creating Databricks first. To create Databricks, search Azure Databricks in your Azure portal and click on it to create. Once created, you can see this at your Azure portal. Click on it to go to this resource home page. At the home page, click on Launch Wo...

In this post, I'll walk through creation of Azure Synapse Analytics(workspace preview) through Azure UI. And here is my earlier post link where I walked through the Azure Synapse Analytics(formerly SQL DW) . Okay, lets start on the creation process. Search 'Azure Synapse' on creation search box and then click on Azure Synapse Analytics(workspace preview) . And then follow the steps and click on create. Once the Synapse Analytics gets created, go to the resource and land on the home overview page. This is looks like below. Overview page holds all major information. Note, SQL Server and default DB creation is part of the creation process. So, you will have the information about DB server and other details. Click on Open under 'Open Synapse Studio' box land you on the Synapse workspace.  This could be pretty familiar t you if you worked with Azure Data Factory. On the extreme left navigation, you have  Home ,  DB, Pipeline ,  Monitoring  etc icon which are same as...

Microsoft announced recently their new horse Azure Synapse . This is analytics service integrated with Data Warehousing and Big data analytics features. Formerly, it was known as SQL Data Warehouse , and now, Microsoft integrated with limitless services on it and renamed as  Azure Synapse . Azure Synapse having platform Gen2 which help it to perform much more faster and running on Azure Cloud actually allow this to integrate with unlimited Azure features. In this post, I'm going to walkthrough very simple way to create the in Cloud environment using Azure UI. However, there are many things need to integrate configure which are not scope of this post. I'll post in future for additional configuration of   Azure Synapse. Let's start and create  Azure Synapse. To create,  go to the Azure portal, login there and click  on 'Create a new resource' under Azure Services. Search there writing ' Azure Synapse '. While in the search box, it appears, click on it.

In SharePoint 2010 world, most of the custom SharePoint application used EventReceiver . This guy played a vital role during that timeframe. EventReceiver is very simple. You can consider this as based on your trigger event, what action you want to execute – this could be a validation, schema change, item entry, workflow initiation, or even communicate with other application. In respect to SharePoint Online, we call this as RemoteEventReceiver(RER) . Same utilization through different channel. SharePoint Online utilize different DLLs, interface, and the implementation through add-ins. In this post, I walk through some notes about RemoteEventReceiver(RER) . Provider-hosted Add-ins Custom code can handle three categories of events in provider-hosted add-ins: ·        List events, such as the adding or deleting of a list on a website. ·        List item events, such as the editing of an item in a list. ·  ...

A very simple and self declarative way to create environment development and production environment in Azure. You applications/apps should able to connect with other apps on the same Azure environment as well.  

Here are top five Office 365/SharePoint features in my opinion. A few already released and few are on the way and will be rolled out very soon. Enable the communication site experience on classic team sites - Communication site is being used for sharing information like corporate news, reports, announcements, townhall news and other information in a visually compelling format. Microsoft now allowing classic team site can have this feature. This is done by a very easy tweaking thing and just running a PowerShell cmdlet( Enable-SPOCommSite -SiteUrl <URL of target site> ), turn your modern communication site features to your classic team sites.

This post is all about how to create some basis services in Azure like starting from resource group, DB, storage etc. Entire post is self explanatory and step-by-step process in pictorial way. To start with, login your Azure account at http://portal.azure.com / and then follow the steps below. First thing is to create the  Resource Group . Whatever resource I'm going to create here should be under one  Resource Group .  Click on Resource group icon or  click on ' Create a resource ' and then search on ' Resource Group' landed you Resource Group creation page. next, select your subscription from dropdown list and enter the name of the  Resource Group ( here it is   POC-WS-TO-ADF ) which is going to be created. Once creation completes, Azure shows the information and allow to go the resource group home page. Now, I wanna like to create on SQL DB resource. Following step-1 process i.e. clicking on ' Create a resource ' and then search SQL DB or clicking on S...

Empower your team, build high productivity Business Apps without doing lots of hardcoding – Power Apps is the current trend -   Platform as Service on M 365  Platform. Microsoft Power Apps service url to know better about it https://powerapps.microsoft.com/en-us/ In today’s post, I’ll walkthrough couple of tips, how-to in Power Apps world. Let’s start. How to put text color in Power Apps form – Label control do have a property called Color . Placing the color value like ColorValue(“Color.Aqua”) make the text color aqua in the form. How can we allow TAB control works on the PowerApps form – Control do have a property called ‘TabIndex’ . This contains number and based on the sequence number, keyboard TAB control move forward one after another.  How to move all controls in the PowerApps form at the same time – Place all your controls inside a Form, and move the form or resize the form. Using Multiline property of the Mode property of the Textbox, you can allow ...