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

  Azure Synapse Analytics - Services provided by Microsoft Cloud Platform to do data warehousing stuff i.e. brings or extract data, work or compute on those data, execute analytical part like predictive analysis, or prepare the C-Level analytical report. Following the standard execution/implementation approach about Synapse. Below are some key points about Synapse Analytic Services and Platform. # Why and when we need to use Azure Synapse Analytics Large-scale data warehousing Advanced analytics Data exploration and discovery Real time analytics Data integration Integrated analytics # Azure Synapse Data Explorer is a data processing engine in Azure Synapse Analytics that is based on the Azure Data Explorer service. Data Explorer uses Kusto Query Language (KQL) to enable high performance, low-latency analysis of batch and streaming data. # You can create a Synapse Analytics workspace in an Azure subscription interactively by using the Azure portal, or you can autom...

SharePoint migration is a continuous process in this business platform. Organization who are using SharePoint for a while need to start thinking at some day for migrating their data from lower version to upper version of SharePoint. Migration is one of the evitable project of most of the Organization. Migrating from On-Premises to On-Premises like MOSS 2007 to SP2020, or SP2010 to SP2013/2016/2019 is one path, and there is another path which is from SP2010/2013/2016/2019 to SPO (SharePoint Online). Content migration is the simple one rather than migrating content with custom application. Migration approach and the plan needs to be perfect for a successful migration. Considering SP2010 or SP2013 or SP2016 environment, there must be workflow presence and it could be integrated with document library, or list or might be site itself. These workflows might be SharePoint Designer Workflow, or Out-Of the-Box workflow or workflow created by any tool like Nintex.  Converting existing workfl...

This post highlight some important notes in Power Automate. While developing workflow using Power Automate, following notes will help to make you a smarter decision. Below are some point under their respective areas: Connecting Dynamics 365 using Cloud Flow Connector Dynamics 365 connector is deprecated, need to use Microsoft Dataverse connector, and if the Microsoft Dataverse connector does not fit your needs, then use the Microsoft Dataverse (legacy) connector. Microsoft Dataverse connector do have some limitation as well, such as the ability to connect to multiple environments. In this kind of you scenario, your choice would be Microsoft Dataverse (legacy) connector which provides the same capabilities as the Dynamics 365 connector with improved reliability. Delete an action If you give the file a name that matches an existing file's name (in the selected folder), the existing file will be overwritten. You can't delete an action if you're using any outputs from it anywhe...

When analytics and intelligence adapt with security, we got a boom! Latest Microsoft threat data and research bringing content which will tell us an expert perspective into the current threat landscape, discussing trending tactics, techniques, and strategies. Security threat in Cloud is keep increasing in exponential way. Now world demands more secure intelligent smart way to exchange data. Something new we are looking for - new approaches, new techniques, new strategies etc. New battel ground is getting created and we called this as Identity! Below few data points which appears by aggregating insights - analysis from 24 trillion security signals combined with intelligence, monitoring more than 40 nation-state groups and over 140 threat groups, able to block more than 25.6 billion Azure AD authentication attacks. Hats off performances!!! Microsoft Defender and Azure Active Directory provided anonymized data on threat activity like Endpoint threats, E-mail threats, Identity threats. Let...

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. ·  ...