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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Synchronous VS Asynchronous Statistics UpdatesFeb 07, 2018. Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
  • 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).
  • 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.
  • 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
  • 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".
  • 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.
  • Creating A WordPress Web App On AzureJan 29, 2018. Today, we will be looking into creating a WordPress Web app on Azure.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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".
  • 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.
  • 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
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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
  • Cosmos DB ConsistencyDec 19, 2017. This article gives overview on consistency models available in Azure Cosmos DB
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

About SQL-Azure

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.