C# Corner

Resources  
  • 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.
  • 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.
  • Demystifying - Azure StackDec 09, 2017. In this article, I will simplify Azure stack and in which scenarios any organization should go with Azure Stack.
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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 Data Science Virtual Machine(DSVM) For Linux In The Azure PortalNov 21, 2017. In this article, I am going to demonstrate how to create the Data Science Virtual Machine for Linux on the Azure Portal and connect the DSVM to visualize the VM using X2Go Client Software.
  • 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.
  • Introduction To SQL Operations Studio And Connecting It With SQL ServerNov 20, 2017. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • Cloud Identities And Azure Active DirectoryNov 20, 2017. In this article, we will discuss cloud identities and Azure Active Directory.
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Creating An Azure Data Lake Store And Data Analytics Account In Azure PortalNov 20, 2017. This article shows how to create an account on Azure Data Lake and Data Analytics in the Azure portal.
  • Deploy ASP.NET MVC Web Application In Cloud Service Using Azure PortalNov 20, 2017. From this article, you will learn how to deploy ASP.NET MVC web application in cloud service using the Azure portal.
  • Azure DevOps SimplifiedNov 19, 2017. Watch how VSTS, Azure, and Visual Studio are being used in DevOps.
  • Chat Bot With Azure Authentication - Part OneNov 19, 2017. This article will teach you some tips and techniques about Azure
  • Introduction To Face API In AzureNov 18, 2017. Face API helps you to add facial recognition capabilities to your application with the Face API. State-of-right algorithms detect your human faces in images, including face landmarks like nose, gender, hair color etc.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Deploy ASP.NET MVC Web Application Using Azure Cloud ServiceNov 16, 2017. Cloud service comes under the PaaS service model, as with a web app service we can deploy our web application in this service and moreover it provides more control on the VMs for the users and we can install our own software by remoting it.
  • Build Intelligent Apps with Microsoft Data PlatformNov 16, 2017. Learn how to build intelligent apps using Microsoft data platform and tools.
  • Creating A Data Science Virtual Machine(DSVM) On The Azure PortalNov 16, 2017. This article describes what a Data Science Virtual machine is and demonstrates how to create it in the azure portal.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part ThreeNov 15, 2017. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificate to a different environment.
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • Azure Table Storage In ASP.NET Core 2.0Nov 14, 2017. Add a class to encapsulate storage access. Add a private helper method to access storage
  • Creating Azure WebJob To Access SharePoint Using Typescript And Node.jsNov 14, 2017. Create a new folder in the solution by the name 'src' and create index.ts file inside the folder. In this folder we will keep all the source files which will get executed when the Job runs. Remember to keep the index.ts at the root of the src and all other files (if any) keep them in the folder otherwise the job will fail.
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • DROP IF EXISTS In SQL Server 2016Nov 13, 2017. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
  • Xamarin.Android - Create A Chat App Using ASP.NET And SignalRNov 13, 2017. Today, I demonstrate you how to build a signalr chat client application using asp.net and xamarin.android with azure.
  • Automating Code Deployment With Azure And GitHubNov 13, 2017. In this article you will learn about how to use ‘App Services’ and exploit Github’s source code management functionalities and version control in order to automate the deployment of your software and maintain a record of prior changes in order to mitigate extra effort in pushing to production.
  • Building Chat Bots With Bing Search Results Using Bot FrameworkNov 11, 2017. The Bot Framework supports different types of rich cards, Azure AD authentication and provides a richer interaction experience to the users.
  • Introduction To Serverless Architecture In AzureNov 11, 2017. In this article, we will see how to create logic apps in Azure.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • Introduction To Bot Service In AzureNov 10, 2017. Bot used as an app that helps users interact in a conventional way. It may be as simple as basic pattern matching with a response or it may be sophisticated handling the artificial techniques with complex conversational state and integration to existing business services.
  • Introduction Of New Useful Features In SSMS 2016Nov 10, 2017. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and are more convenient to use the SSMS.
  • How To Create Logic App From Template In AzureNov 09, 2017. Azure Logic Apps is a fully managed integration Platform as a service which provide a way to automate the workflows and business processes. You could easily integrate across different services in cloud and on-premise through connectors. In this article you will see how to create logic app from template which will create a new item in SharePoint Online list when a new tweet appears with text as “SharePoint”, #SharePoint, O365 or Azure.
  • Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data WarehouseNov 09, 2017. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
  • Azure Machine Learning - Iris Model Client ApplicationNov 08, 2017. In this post, I shall be demonstrating the utilization of Azure Machine Learning model into a client application.
  • Configuring SQL Server 2016 Express On LAN For C# Connection StringNov 08, 2017. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
  • How To Create A Blank Logic App In AzureNov 07, 2017. Azure Logic Apps is a fully managed integration platform as a service which provides a way to automate the workflows and business processes. You could easily integrate across different services in the cloud and on-premise through connectors. In this article you will see how to create a blank logic app which will send an email to a Gmail account when a new tweet is posted with the text “SharePoint” or #SharePoint.
  • Step By Step Guide To Setup Sample SSAS Multi Dimension CubeNov 06, 2017. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
  • Power BI On-Premises Server Installation And ConfigurationNov 06, 2017. On October 31, 2017 Microsoft released the latest version of Power BI report server, in this version on-premises reports can connect to different data sources (SQL Server, Oracle, SAP HANA ...Etc.). Users can also use direct Query option or import data option and create schedule to refresh the imported data. This article will give the step by step process to install and configure a Power BI on premises server.
  • Introduction To Bing Search API In AzureNov 05, 2017. Bing Search API adds intelligent search to your app and also it contains billions of web pages, videos, images. The best feature is that the results can be automatically customized to your user’s locations or markets.
  • Hosting Website Using FileZilla To AzureNov 05, 2017. In this article, we will see how to publish your normal HTML website without using Visual Studio or any other tool by using FileZilla in Microsoft Azure.
  • SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was InstalledNov 05, 2017. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
  • Create An Azure SQL Database Using PowerShellNov 03, 2017. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Building Bot Application With Azure AD Login Authentication Using AuthBotOct 30, 2017. The Azure AD is the identity provider, responsible for verifying the identity of users and applications and providing security tokens upon successful authentication of those users and applications.in this article I have explained about create Azure AD authentication and integrate into bot application using AuthBot library.
  • Part 1 Azure Red Shirt Dev Tour NYC 2017Oct 29, 2017. Introduction to Azure, overview, and cool features
  • Part 2 Azure Red Shirt Dev Tour NYC 2017Oct 29, 2017. Learn Azure from Scott Guthrie
  • Getting Started With Azure Cosmos DBOct 29, 2017. Azure Cosmos DB is a globally distributed database service designed to enable you to elastically and independently scale throughput and storage across any number of geographical regions with a comprehensive SLA. You can develop document, key/value, or graph databases with Cosmos DB using a series of popular APIs and programming models.
  • Azure Tips and TricksOct 29, 2017. Watch Part 3 of Azure Red Shirt Dev Tour to learn Azure tips and tricks.
  • Develop Multi-Platform And Connected Apps And Deploy Them On AzureOct 26, 2017. PaaS allows companies and developers to focus only on applications and services and not infrastructure. PaaS provides all the services needed to create, code, deploy and run websites, mobile services, and more.
  • Azure Service Bus - Peek-Lock A Message From Queue Using Azure Logic AppsOct 26, 2017. In this article, we will take a look at how you can peek-lock on a message from a Service Bus Queue without actually reading the message from the queue.
  • Emailing Via Azure In .NET Core 2.0Oct 26, 2017. In this article, you will learn about emailing Via Azure in .NET Core 2.0.
  • Azure Cache In ASP.NET Core 2.0Oct 25, 2017. In this article, you will learn about Azure Cache in ASP.NET Core 2.0.
  • Cloud Databases In Azure - Part ThreeOct 24, 2017. This is the third article in the “Azure Cloud Databases” articles series, which is in continuation of the previous two articles.
  • Azure Service Bus In .NET Core 2.0Oct 24, 2017. In this article, you will learn about Azure Service Bus In .NET Core 2.0.
  • Making An E-Learning Platform For Microsoft Azure - Part OneOct 23, 2017. As web developers with a 'traditional' VB or C# asp / .net background, we are quite blessed with the sheer breadth of infrastructure, components, libraries and tooling given to us not only by Microsoft by default, but also by the wider projects in open source made available by the many generous members of the wider .net community.
  • Hosting Website With Filezilla To AzureOct 19, 2017. We can use the FTP client Filezilla for website hosting to Azure. And it is an FTP method. And sometimes we may face some errors in it. And the solution is also mentioned in this article.
  • How To Return A Pair Of Closest Birthdates Using API, Multi Threading And MVC 5 Using C#.NETOct 18, 2017. This article demonstrates how to use multi-threading to return the name of 2 customers who have the closest birthdate. I also include how create API to add\ retrieve customer details from SQL database using tasks and how to use MVC to call and API to add a new customer.
  • T-SQL - Display Decimal Numbers As MoneyOct 17, 2017. In this article, we will show how to display decimal numbers as money with and without cents
  • Cloud Databases In Azure - Part TwoOct 16, 2017. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.

About SQL-Azure

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!