C# Corner

Resources  
  • Azure Storage Components - Blob - Part OneJan 22, 2018. This writing will cover the objective of Azure Storage Services particularly the Blob component on Azure Storage. You will get to know about Azure Blob Storage Services and implementing Azure Blob Storage.
  • Deploying Multiple ASP.NET Core Apps To Docker And AzureJan 22, 2018. API - has controller with CRUD operations for a movies database. It uses a class library Data, which contains repositories. Database is hosted in Azure and connection string stored in application settings (appsettings.json).
  • Azure Storage - Creating A Container Using Visual StudioJan 20, 2018. This writing is a continuation of my previous one in which I have written in detail about Azure Storage, please spend some time on the previous article of mine.
  • Deploying ASP.NET Core 2.0 App To Azure Using DockerJan 18, 2018. Azure provides a highly scalable, configurable and easy to use Platform-as-a-Service (PaaS) environment for our ASP.NET Core web applications. Azure Web App is one of the simplest ways to host web applications and the new Web App Container makes it really easy to host Docker containers.
  • Upgrading Your Application In Azure Managed KubernetesJan 18, 2018. In the previous article, we deployed an ASP.NET Core 2.0 API app in AKS (Azure Managed Kubernetes). Now, let's quickly look into how to upgrade the application when there is a change in code. Please make sure you read the previous article to follow through this one.
  • Deploy Your First ASP.NET Core 2.0 App In Azure Managed KubernetesJan 17, 2018. This guide will help you to get started with AKS. We are going to deploy our first ASP.NET Core 2.0 App in AKS and then do some cool stuff like scaling up and down.
  • Azure Logic Apps - Integrating Twitter API And Google Drive APIJan 17, 2018. This article will explain about working on Logic Apps, integrating Twitter API and Google Drive API. We will be using Logic Apps here to search for a keyword on Twitter and save the tweets for the Google Drive on the specified location.
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • Azure Media - Implement Media Content EncryptionJan 15, 2018. I am writing this article on the encryption of a video using Azure Media Service.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • AI Series - Part Two - Programming EmotionsJan 12, 2018. I will be showing how to start AI Development with Cognitive Services. Previously, we kickstarted our new article series “AI HowTo” and talked about how to register for Emotion API Preview(Project Oxford) through Azure Portal.
  • Azure CLI With Demo Creating VM Using Azure CLIJan 12, 2018. This articles shows a demo of creating virtual machine in Azure using Azure CLI with explanation of Azure CLI cmdlets.
  • Create An Intelligent Bot Application Using Microsoft Bot FrameworkJan 12, 2018. In our previous article, we learned how to create and connect a chatbot with Azure Bot Service. But in this article, we are going to create an intelligent Bot Application using Microsoft Bot Framework.
  • AI Series - Part One - Registering For Emotion APIJan 11, 2018. I will be showing how to start AI Development with Cognitive Services.
  • Explore Azure Cosmos DB Without Azure SubscriptionJan 10, 2018. Azure Cosmos DB emulator is an exciting tool for getting started with Cosmos Db. This allows us to play with Cosmos DB without even having an Azure Subscription. That means you can write Cosmos DB code in your .net application and view your data on emulator.
  • Simple CRUD Operations In Azure Cosmos DBJan 08, 2018. In this article, you will learn about Simple CRUD operations in Cosmos DB.
  • Deploy SharePoint Remote Event Receiver To Microsoft AzureJan 08, 2018. This article will help even a beginner to deploy a SharePoint Remote Event Receiver easily to Microsoft Azure.
  • Desired State Configuration In Microsoft AzureJan 07, 2018. This article describes how one can automate and align deployment of Azure resources effectively.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Availability Set, Fault Domains And Update Domains In Azure Virtual MachineJan 06, 2018. This article explains why one must plan Availability Set, Fault Domain and Update Domain while configuring Virtual Machines for Azure.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Azure Pack Vs Azure StackJan 04, 2018. The article describes key differences between Microsoft's two key hybrid cloud strategies, Azure Pack and Azure Stack
  • Create And Connect A Chat Bot With Azure Bot ServiceJan 04, 2018. This article explains how to Create and Connect a chat bot with Azure Bot Service.
  • Azure PowerShell Login IssueJan 04, 2018. At times we face issues while logging in to Azure PowerShell. There may be different types of error messages while logging in. This article explains about the resolution of the error message “The PowerShell session has not been properly initialized. Please import the module and try again."
  • Azure Stack Architecture In DepthJan 04, 2018. In this article I explain the architecture of Azure Stack in detail, in an easy-to-understand way
  • Working With Azure Storage Explorer In Visual Studio CodeJan 03, 2018. Visual Studio code is an open source source code editor developed by Microsoft which supports all major operating systems like Windows, Linux and Mac OS. It includes support all most all software development activities like debugging, Git control, syntax highlighting, intelligent code completion, snippets, and code refactoring.
  • Azure PowerShell Module InstallationJan 02, 2018. Azure Cloud Shell and Azure PowerShell are the two different types of shells available to manage the Azure resources through cmdlets. Azure Cloud Shell can be accessed through the browser.
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • Worker Role In Azure Cloud ServiceJan 02, 2018. From this article, you will learn how to play with worker role in Azure cloud service
  • Azure Service Bus Queues Dec 29, 2017. From this article, you will learn how to work with Azure Service Bus Queues.
  • Building CI/CD Pipeline From Scratch For Azure Deployment Using VSTSDec 28, 2017. Continuous Integration (CI)/Continuous Deployment (CD) are widely used terms in the DevOps world. If you are new or don’t fully understand the buzzword DevOps, do read this article.
  • Create Your First Virtual Machine (VM) Using Azure PortalDec 28, 2017. In this article, we will talk about different free Azure subscriptions available for developers and end users. With this, we will also learn how we can create a virtual machine using Azure Portal.
  • Migrate Your Applications To Azure Virtual MachinesDec 27, 2017. Learn how to migrate your applications to Azure virtual machines.
  • Getting Started With Azure Service BusDec 26, 2017. From this article you will learn an overview of Azure service bus and ow to create an Azure service bus namespace using the Azure portal
  • Build Scalable Web Applications With Azure Database For MySQLDec 26, 2017. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managing a database. See how the service helps you quickly respond to changing customer needs by scaling up and down. And see how capabilities like high availability and replication help you meet and exceed customer expectations.
  • Create And Deploy An ASP.NET Core Web App In AzureDec 23, 2017. This article will help you to create & deploy an ASP.NET Core web app in Azure.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • How To Create An Azure Function App Using Visual Studio 2017Dec 21, 2017. In this article, we will learn how to create an Azure Functions App using Visual Studio 2017.
  • Indexing In Azure Cosmos DBDec 21, 2017. By default, the Azure Cosmos DB data is indexed. Azure applies its default indexing policy while creating a collection. However, a user can set their customized indexing policy as per requirement.
  • How To Call Azure Function In Logic AppsDec 20, 2017. Azure Functions is used for executing a small piece of code or “function” in the cloud and you pay only for the time your code executes.
  • Cosmos DB ConsistencyDec 19, 2017. This article gives overview on consistency models available in Azure Cosmos DB
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • How To Create Azure Function App To Delete SharePoint Online List Using CSOMDec 19, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer Azure Functions for more details.
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Partitioning In Azure Cosmos DBDec 18, 2017. This article gives an overview of partitioning in Azure Cosmos DB. The partition key is the JSON property (or path) within your documents that can be used by Cosmos DB to distribute data among multiple partitions.
  • Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.
  • Export SQL Result To A Text FileDec 18, 2017. This article gives an overview of how to export SQL query results to a text file.
  • How To Create A Simple Azure Function App Using C#Dec 18, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of your choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer to Azure Functions for more details. In this article you will see how to create a simple Azure Function using C# that will run whenever an HTTP request is received.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • Exploring And Managing Azure Resources Using Microsoft Azure Mobile App Dec 13, 2017. Microsoft has introduced Azure mobile app for Android & iPhone azure subscribers to get connected with there own Azure resources 24 by 7. Mobile being human chore partner, app made life easier for developers, entrepreneurs or Admin to manage provisioned azure resources anytime from anywhere. Not only can access & manage, but also can monitor health & status of Azure resources. This helps in quick resolving the issues encountered if any.
  • Getting Started With Azure Machine Learning Studio And Azure StorageDec 13, 2017. This write-up is a continuation of my previous one by which we will be sketching across how to get started with Azure Machine Learning and an introduction to Azure Storage.
  • Deep Walk On Azure Machine Learning - Why On Cloud And That Too On AzureDec 12, 2017. This article goes up with a deep walk on Azure Machine Learning covering the topics with lot many modules which heads up with loading data in azure machine learning, data preparation, azure machine learning modelling, deploying the models and about r scripts in Azure.
  • Getting Started With CosmosDBDec 12, 2017. DocumentDB is a NoSQL database which is massively scalable and it works with schema free JSON documents.
  • Remove Duplicate Rows In SQL Server Using CTEDec 11, 2017. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Demystifying - Azure StackDec 09, 2017. In this article, I will simplify Azure stack and in which scenarios any organization should go with Azure Stack.
  • How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.
  • Graph API Using Android ApplicationDec 07, 2017. This article demonstrates how to add Microsoft Graph API using Android Application to get access token and call Microsoft Graph API or other APIs that require access tokens from Azure Active Directory v2.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • Azure Face API - Hands-On Using Python (Basic)Dec 06, 2017. In this article, I will be working on Azure 's Face recognition API. I will be showing you how to exploit this very powerful API in order to add recognition capabilities to your applications by detecting human faces in images.
  • Introduction To Azure Machine LearningDec 06, 2017. Watch this video to get started with Azure Machine Learning.
  • Step By Step Procedure To Create An Azure Logic AppDec 06, 2017. The article is on the detailed procedure of building an Azure Logic App. These steps are described with photos.
  • Role Of Text Analytics Service As A Connector In Azure Logic AppsDec 06, 2017. In this article, we will learn, via a demo application, about the role of Text Analytics Service, a Cognitive Services offering, as a connector in Azure Logic Apps.
  • Accessing Azure Key Vaults Using Certification Dec 05, 2017. In the old days, we used to access the Azure Key Vaults using Vault URL and its Secret Key, we were placing this in config file and going from there.
  • Getting Started With Bing AutoSugesstion API On The Azure PortalDec 05, 2017. This article demonstrates how to create the Bing autosuggestion API on the Azure Portal.
  • Learn About Bing Image Search APIDec 05, 2017. This article demonstrates how to create the Bing Search API on the Azure Portal.
  • How To Give An Approval When A New Cognito Forms Entry Is Submitted With Microsoft FlowDec 05, 2017. This article helps you to learn how to Give an Approval when a New Cognito Forms entry is submitted using Microsoft Flow.
  • How To Notify Me When A Cognito Forms Entry Is Submitted With Microsoft FlowDec 04, 2017. This article helps you to learn how to Notify me when a cognito forms entry is submitted using Microsoft Flow
  • Creating An Emotion API On The Azure PortalDec 02, 2017. This article shows how to create the Emotion API on the Azure Portal and access the keys to use the Emotion API in our applications.
  • Creating An HDInsight Hadoop Cluster On LinuxDec 01, 2017. This article shows how to create the HDInsight Hadoop cluster with Linux installed on the cluster nodes in the Azure Portal.
  • Mounting Azure File Share With WindowsNov 30, 2017. This article shows how to create an Azure Storage account
  • How To Connect Box To OneDrive with Microsoft FlowNov 30, 2017. This article helps you to learn how to Connect Box to OneDrive using Microsoft Flow.
  • A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.
  • Creating Blob Storage In Microsoft Azure Using C# ASP.NETNov 29, 2017. This article will discuss how can we create/Use MS Azure storage in ASP.NET Web application using MS Libraries. I am not an expert to discuss all the part of Azure Storage, but I am sharing the things about Blob Storage.
  • Virtual Entity - New Way Of Integration - Part TwoNov 28, 2017. This is our second article regarding virtual entity, if you have not checked our earlier article, we suggest you check that first here. In this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want to show into virtual entity, so let’s get started!!
  • Adding A DataDisk To Our Virtual MachineNov 28, 2017. This article shows how to add a disk to our Virtual Machine for additional data storage.
  • How To Notify Me About Positive Twitter Posts Using Microsoft FlowNov 28, 2017. This article helps you to learn how to notify me about Positive Twitter posts using Microsoft Flow
  • What Is Azure Databricks?Nov 28, 2017. Learn what Azure Databricks is.
  • Creating A Windows Virtual Machine On The Azure Portal And Expanding The OS DiskNov 28, 2017. This article demonstrates how to create a Virtual Machine on the Azure portal and also how to expand the OS Disk for high space availability.
  • Chat Bot With Azure Authentication - Part TwoNov 27, 2017. In the previous part of the article series, we have completed initial setup such as app registration, Azure Active Directory Authentication and saving AccessToken to Bot State Service. In this part of the article, we will implement chat bot which will get the AccessToken from Bot State Service and make Azure service call.
  • How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don't use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and 'server-less computing' are two technologies that most developers are going to have to embrace in the next short few years.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.
  • How To Create A Stored Procedure In SQL Server Management StudioNov 25, 2017. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedure.
  • Creating An IoT Hub On The Azure PortalNov 25, 2017. This article shows how to create an IoT Hub on the Azure Portal and also how to create the device Identity for simulating a device on PC.
  • How To Change Your Facebook Post In One Language To Repost In Another Language Using Microsoft FlowNov 25, 2017. This article helps you to learn how to change your Facebook post in one language to repost in another language using Microsoft Flow
  • Creating An Event Hub On The Azure PortalNov 24, 2017. In this article, I am going to describe and demonstrate the creation of Event Hubs on the Azure Portal.These Event Hubs are used to act as a port to collect the streaming data and processing of that data per second.
  • How To Save Wunderlist Tasks To OneNote Pages Using Microsoft FlowNov 24, 2017. This article helps you to learn how to save Wunderlist tasks to OneNote pages whenever a new task is added on Wunderlist using Microsoft Flow.
  • Building Intelligent C# Corner FAQ Bot Using QnA Maker And Azure Bot ServiceNov 24, 2017. In this article, we will be learning as how to create or build an intelligent Azure Bot using Microsoft QnA maker and Azure Bot service. Also, we will be deploying this Bot to application live. For novice Cloud developers, aspiring Cloud architects, Pre-sales consultants and all other IT professionals associated with the Cloud computing, especially with Microsoft Azure and Artificial Intelligence, this article will explain the capabilities of Microsoft Bot service and Microsoft cognitive QnA Maker.
  • Introduction To SSISNov 24, 2017. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data Transformation Services) that exists in SQL Server 2000.
  • Essentials Of Azure AD Application RolesNov 23, 2017. One could do some simple guesswork here and understand that the roles required in the application may be called application roles, and this is correct! When we speak of roles, roles are always associated with users and when we say users, then these are the people using the software or the application. Roles could be anything specific to the application; i.e. Administrator, User, Approver, Reviewer etc.
  • How To Generate Audio For My Facebook Post Using Microsoft FlowNov 23, 2017. This article helps you to learn how to Generate Audio for a Facebook post by creating flow between Facebook and OneDrive.
  • Creating An Azure Storage In Microsoft AzureNov 22, 2017. This article shows how to create an Azure storage in the Azure portal and also performing some basic operations like creating Storage accounts and containers and managing the access keys in it.
  • ASP.NET Core 2.0 Secret ManagerNov 22, 2017. I discussed in the previous post how configuration settings can be stored in configuration files. However, these files are checked in the source control and not suitable to store confidential settings. In a production environment these settings can be stored in environment variables or Azure Key Vault however, for development ASP.NET Core provides an alternate solution: Secret Manager.
  • Implementation Of Face API Using Microsoft Azure And Visual StudioNov 22, 2017. This article shows how to create the Face API using Microsft Azure and Visual Studio,
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Creating A Standalone Automation Account In Azure PortalNov 21, 2017. Microsoft Azure Automation supports a path for the users to automate the manual, long-processing, error tracking and is mostly needed for the continuous repeated process in the cloud and in many companies.Then automation saves the time and increases the reliability of the regular administrative works and it also schedules them to be automatically performed at regular intervals.The Automation can be taken with the help of Runbook.

About SQL-Azure-articles

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!