C# Corner

Resources  
  • Download User License Information For PowerApps And Microsoft FlowFeb 16, 2018. PowerApps is one of the services available in the Office 365 environment that enables us to create apps or forms for business and other uses without coding experience. We can connect against external data sources like SQL, SharePoint, Salesforce, etc... to develop an application. PowerApps has its own data source called Common Data Service.
  • A Beginners Guide To Microsoft BizTalk Server - Part TwoFeb 16, 2018. This is the next part of the BizTalk Server article series. Here, we are going to explain why BizTalk is still the number one choice for ian ntegration tool. BizTalk is considered the best tool for integration. We will be seeing the list of some companies which are using BizTalk as an integration tool and the future of BizTalk developers.
  • How To Get Started With Always Encrypted For Beginners - Part ThreeFeb 15, 2018. A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the project was to prevent the DBA from being able to view salary information, while still allowing the application to function without issue.
  • Publish ASP.NET Core 2.0 Application On Azure With SQL ServicesFeb 15, 2018. In this article, we will learn how to deploy or publish an Asp.Net Core 2.0 application on Azure.
  • Deploying VM Using ARM TemplateFeb 14, 2018. Azure Resource Manager (ARM) Templates are JSON files which define the resources which you need to deploy for your solution. ARM templates are community contributed and can be used by anyone from GitHub. This repository holds various predefined ARM templets to choose from has per your needs. But to get started with ARM templates we will be configuring a simple virtual machine deployment from scratch so we can understand easily.
  • SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.
  • Design Patterns Simplified - StrategyFeb 13, 2018. This article explains what Strategy Design Pattern is and how to use it in software design and development.
  • Simple Visual Analytics Using Logic AppsFeb 13, 2018. Logic apps are one such way to get started if you’re not familiar with coding and looking to work your way around to automate your application processing. Logic apps have various usabilities with simple action flow creation. Today we will be looking at Visual Analytics using Twitter and Power BI on Logic App.
  • Microsoft Operations Management Suite (OMS) - A Beginner's GuideFeb 13, 2018. Operations Management Suite (also known as OMS) is a collection of cloud-based services for managing your on-premises and cloud environments from one single place. Rather than deploying and managing on-premises resources, OMS components are entirely hosted in Azure. In simple words, what basically happens is that OMS goes and talks to different servers, applications in your environment, collects information about how they're doing, consolidates this information in the form of nice colorful graphics and searchable records, after that presents it to you in one single, convenient place, and it doesn't matter where your servers or applications are running, Azure, AWS, on-premises or which operating system they're running on, Windows or Linux, it just works. Configuration is minimal, and you can be up and running literally in a matter of minutes.
  • How To Get Started With Always Encrypted For Beginners - Part TwoFeb 12, 2018. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or through our applications. You’ll be surprised to see how easy it is.
  • Increase Data Disk Size In AzureFeb 11, 2018. Retaining data in the same VM requires us to increase the disk space when the utilization of allocated space is full. Increasing the disk space in Azure is quite easy with a few clicks.
  • Creating An Azure Database For PostgreSQL ServerFeb 11, 2018. In this article, I am going to demonstrate how to create a database in Azure for the PostgreSQL server in the Azure Portal.
  • Work With CDN On Azure Storage - Part FiveFeb 10, 2018. This article will help you to work on Azure Storage by adding CDN (Content Delivery Network) to access data with high availability.
  • Creating And Configuring A MySQL Server On The Azure PortalFeb 10, 2018. This article demonstrates how to create a MySQL database on the Azure Portal.
  • Top 10 Most Popular Charts In Angular With .NET Core APIFeb 09, 2018. This article explains how to create charts in an Angular application.
  • How To Sell Your CLOUD ServicesFeb 09, 2018. While responding to this question, keep in mind that you are requested to talk about additional benefits over and above the cloud services from your competition. For example at that time, the key difference which MS Azure services had was per minute billing as compared to other cloud providers. Then probably there were more functions and features available in the overall cloud dashboard as compared to others.
  • How To Get Started With Always Encrypted For Beginners - Part OneFeb 08, 2018. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.
  • Blob Operations On Azure Storage - Part FourFeb 08, 2018. This article will help you to work with copy operations on Azure Blob Storage and an overview of CDN (Content Delivery Network) on Azure storage.
  • Channel Configuration - Azure Bot Service To Slack ApplicationFeb 08, 2018. This article explains how to configure Azure Bot Service to Slack Applications. We will get a clear idea about how to create a Bot Service in Azure.
  • Unit Test In .NET Core Application Using NUnitFeb 08, 2018. There are three different test frameworks that are supported by ASP.NET Core for unit testing - MSTest, xUnit, and NUnit. These allow us to test our code in a consistent way. In this article, I will explain about the unit test using NUnit.
  • Introduction To LINQ With Entity Framework In Visual StudioFeb 08, 2018. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
  • Synchronous VS Asynchronous Statistics UpdatesFeb 07, 2018. Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
  • Unit Test In .NET Core Application Using MSTestFeb 07, 2018. In this article, I will explain about the unit test in asp.net core using MSTest.
  • Unit Test In .NET Core Application Using XUnitFeb 07, 2018. There are three different test frameworks for Unit Testing supported by ASP.NET Core: MSTest, xUnit, and NUnit; that allow us to test our code in a consistent way. In this article, I will explain about the xUnit framework. the XUnit is an open souce test framework and main focus of this framework are extensibility and flexibility. It follows more community focus to being expand.
  • How To Create A Basic Bot Using Bot Service In Azure PortalFeb 07, 2018. Bot Service allows you to create, connect, test, deploy and manage bots from your browser. It also provides the Bot Builder SDK for developing bots and the Bot Framework for connecting bots to channels. You can use five default available bot templates to get started with building bots.
  • How To Always Use Angular's Latest Version With Visual Studio 2017Feb 07, 2018. This article explains how to use the latest version of Angular with Visual Studio 2017.
  • Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
  • SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).
  • Deploy BitBucket Source To Azure Using Azure Web App ServicesFeb 05, 2018. From this article, you will learn to deploy Bitbucket source to Azure using Azure web app service
  • Working With Async Main In C# 7.1Feb 05, 2018. This article explains the async main feature introduced as part of C# 7.1 and demonstrates how to use it in application development.
  • Email Directly From C# .NET On Azure With No Mail ServerFeb 05, 2018. One of the background parts of most systems I write involves messaging of some kind ... more often than not, the default is email notification of one thing or another. When I need to carryout large scale mail-outs I always use one for the major Azure services, but when I only need adhoc mail operations or low volume, I use a combination of an SMTP Client and a DNS MX Lookup.
  • CRUD In Excel File In C#Feb 02, 2018. In this article, I am going to explain how we can CREATE, UPDATE, DELETE and READ the records in Excel files.
  • Blob Security On Azure Storage - Part ThreeFeb 01, 2018. Shared Access Signature is shortly called as SAS, SAS is a URI that grants restricted access rights to Azure Storage resources, you can provide a SAS to clients who should not be trusted with your azure storage account key but whom you wish to delegate access to certain storage account resources. By distributing a shared access signature URI to these clients, you can grant them access to resource for a specific period time. The Service – Level SAS delegates access to a multiple storage services like blob, files, tables and queues.
  • Introduction To Serverless Computing Using Azure FunctionFeb 01, 2018. Serverless Computing is driven by performing some action as a response to the specific event or trigger. While building serverless apps you don’t need to provision a server or infrastructure. Billing is based on resources consumed or actual time code is running. There's no need to build app to run the code, no need to set up infrastructure, no need to setup deployment infrastructure. Just focus on code.
  • Azure Blob Storage Service - Uploading A Blob And Set Container Propertied With Metadata - Part TwoJan 31, 2018. This article assumes that you already have an Azure Storage Account created and the solution file for Visual Studio which was created in the previous demo.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part TwoJan 30, 2018. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creation). But I decided to put it in a SharePoint list because my css selectors are grouped and I could not reference them using "styles.selector".
  • How Artificial Intelligence And Natural Intelligence WorksJan 30, 2018. This article explains how Artificial Intelligence and Natural Intelligence (the human brain) works.
  • Build Angular App With .Net Core 2.0 Template(VS 2017) + Deploy On Azure - Step By Step GuideJan 30, 2018. In this article, we will see how to create your Angular application using Visual Studio 2017(.NET Core 2.) and will deploy it to Azure.
  • CRUD Operations In SharePoint REST API Using jQuery AJAXJan 30, 2018. In this article I explain how to make create, read, update, and delete operations of sharepoint list items over HTTP requests.
  • Creating A WordPress Web App On AzureJan 29, 2018. Today, we will be looking into creating a WordPress Web app on Azure.
  • CRUD Operations In SharePoint Using REST API - Delete OperationsJan 29, 2018. The previous blogs demonstrated the “Create”, “Read” and “Update” operations of REST API in SharePoint. This is the last blog of this series and explains the “Delete” operation of a list item.
  • Adding/ Removing Users To Enterprise Applications In Azure Active DirectoryJan 29, 2018. In this article we will be looking into adding new users to Azure active directory and providing access to your enterprise applications without giving them access to your application's dedicated login information.
  • Azure WebApp - Rollback Your Deployment Using Deployment SlotJan 29, 2018. We generally find issues in our deployed application while it is in production. This is a really awkward situation in the development cycle. It is also painful for the customer. I am going to discuss the solution to this issue in this article.
  • Azure VM Migration Between SubscriptionsJan 29, 2018. Azure VM migration between the subscriptions is quite easy. Some of the organizations will have dedicated subscriptions for testing\POC of new applications. Once these applications are validated successfully, the IT administrators might need to move these VM & dependent Azure resources to the production subscription. Azure portal provides a very convenient option to migrate the resources between different subscriptions. The following steps help with the steps to migrate the resources from one subscription to another.
  • Azure CDN With Azure StorageJan 29, 2018. From this article, you will learn how to create an Azure CDN with Azure Storage.
  • Python With PostgresSql, SQLAlchemy And FlaskJan 28, 2018. This article explains the integration of Python with PostgresSqL using with SQLAlchemy and expose Rest Service by Flask
  • Azure Virtual Machine Disk Encryption With Azure Key-VaultJan 27, 2018. This article explains how to encrypt Azure VM Disks with the help of Azure Key-Vault. Azure Key-Vault is a key management as a service which provides Hardware-based key management via Hardware Security Model (HSM) along with Software-based key management.
  • Shared Storage With Azure Virtual MachineJan 25, 2018. This article briefs you about Shared Storage in Azure and how to use Shared Storage in multiple Azure VMs.
  • Azure Virtual Machine With PowerShell And Desired State ConfigurationJan 24, 2018. This article describe how to create Azure VM with PowerShell. The article is also extended a bit to explain why Azure Desired State Configuration is very useful while working with Azure VM and how to implement Desired State Configuration with Azure VM
  • ASP.NET Core Apps In Docker Swarm Deployed To AzureJan 24, 2018. In the previous post, I deployed a Docker Swarm on VMs setup on my local PC, which is fine for testing. In this post I’ll deploy the same services on a Docker Swarm hosted in Azure using “Docker EE for Azure”. Let’s start.
  • CRUD Operations In SharePoint Using REST API - Update OperationsJan 24, 2018. In the previous blogs, we had a look at the “Create” and “Read” operations in this series of CRUD Operations in SharePoint using REST API. In this blog, we will explain the “Update” operations.
  • Re-Enable A VSTO Add-In That Has Been DisabledJan 24, 2018. This article will explain to you how to re-enable a VSTO Add-in that has been disabled.
  • Move Azure Resources Between Resource GroupsJan 24, 2018. Azure Resource Group is a container which holds the VM and its dependent infrastructure. The resource group can include all the resources for the solution, or only those resources that you want to manage as a group.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.
  • Different Ways To Deploy A Website On AzureJan 23, 2018. I am here again with a new article. In this article, I am going to talk about the deployment of websites on Azure.
  • Setup Bot Framework Development Environment Using .Net (C#) - Part TwoJan 23, 2018. In previous article, I have explained how to build FAQ based bot application using QnA maker for questions and answers. In this article, we will discuss about how set up Bot Framework development environment and we are going to consume QnA maker service.
  • Migrate Bot Application From Bot Portal To Azure PortalJan 23, 2018. In this article, I will share thoughts about the migration of existing registered bots from https://dev.botframework.com to Microsoft Azure portal.
  • Xamarin.Forms - PagesJan 23, 2018. In the previous chapter, I explained how you can prepare your environment for Android or iOS application development, in this chapter I will start presenting the structure of our page in Xamarin.Forms.
  • 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.
  • SharePoint Online/2016/2013 - How To Upload Large Files Using PowerShell AutomationJan 22, 2018. Uploading large files to SharePoint On-Premise or Online is an obvious problem during data migration from any external system like Lotus Notes.In this article I will explain a data upload strategy where we can split a large file into multiple chunks of smaller size.
  • Design Patterns Simplified - Chain Of ResponsibilityJan 22, 2018. This article explains what Chain of Responsibility Design Pattern is and how to use it in software development.
  • 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).
  • Step By Step Installation Of .NET Core 2.0Jan 22, 2018. In my previous post, I have explained how to set up for .Net Core 2.0 which you can find here. But in that post, it mainly focuses on how to do the setup if you already have .Net Core. So in this post, I will explain how to install .Net core 2.0(Without having Core 1.0) on your machine.
  • 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.
  • Cab Booking And Scheduling By Using Command Design Pattern And SchedulerJan 20, 2018. This article explains the cab booking & scheduling system by using Command Design Pattern and Scheduler.
  • 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.
  • 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.
  • 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.
  • 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.
  • Database First In .Net Core 2.0 CRUD Operation - Part OneJan 17, 2018. In my previous post, I have explained how to create an Angular 5 application in Visual Studio 2017 using .NET Core templates which you can find here.
  • Learn Basics Of MVC ArchitectureJan 16, 2018. Recently, I learned the basics of MVC by going through various articles. And I thought to write an article based on my learning which, I think, may help at least few who are looking forward to learn MVC.
  • Basics Of Angular And Its Versions - Part ThreeJan 16, 2018. In this article, I am going to explain more on one of the 8 main building blocks, that is, Services.
  • 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.
  • An Introduction To Q#Jan 15, 2018. In this article, I will be explaining about Q# - the new programming language introduced by Microsoft for quantum computing. We will understand the data type, expressions, and statements of Q# with the help of code snippets.
  • Model Driven Forms In AngularJan 15, 2018. I have opened the same solution I have explained in my previous article, and i have app.component.ts with onsubmit function and I have html elements in app.component.html.
  • 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.
  • Railway Ticket Fare Calculation With Strategy PatternJan 15, 2018. This article explains how to calculate Railway ticket fare by using Strategy Design Pattern.
  • C# 7.2 - "In" Parameter Method Overloading TiebreakerJan 14, 2018. This article explains the “in” parameter method overloading with Visual Studio 2017 Version 15.6. Preview 2.
  • 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 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.
  • Drawing Pad or Signature Pad For Android Using Xamarin.FormsJan 12, 2018. This article will explain how to create a drawing pad or signature pad for Android OS using Xamarin Forms.
  • AI Series - Part One - Registering For Emotion APIJan 11, 2018. I will be showing how to start AI Development with Cognitive Services.
  • Creating REST Service Using Flask And PythonJan 11, 2018. This article will explain to create REST service by using Flask framework and Python.
  • Singleton Design Pattern In C# - Part Three (Static vs Singleton)Jan 11, 2018. In this series of learning singleton patterns, we learned lazy initialization and eager initializations with practical examples. We also learned why it is necessary to make the singleton class sealed with sealed keyword. In this article, I’ll try to explain the differences between static and singleton class and where to use static and where to use singleton classes.
  • 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".
  • Architecture Smells - Detection And RefactoringJan 05, 2018. The concept of “smells” is familiar within the software engineering community. The term “code smell” first appeared in the popular Refactoring book by Martin Fowler; it was informally defined as “certain structures in the code that suggest (sometimes they scream for) the possibility of refactoring”. An excessive number of smells in a software system impair the quality of the software and makes the software hard to maintain and evolve.
  • 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.
  • Share Code Between ASP.NET Core MicroServicesJan 04, 2018. Microservice architecture or microservices is a method of developing software applications as a suite of independently deployable, small, modular services in which each service runs a unique process and communicates through a well-defined, lightweight mechanism to serve a business goal.

About explain-SQL-Azure-Architecture

NA
Web Development Outsourcing
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.