C# Corner

Resources  
  • 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.
  • Understanding Text Analytics API In AzureOct 14, 2017. This article will give an overview on Text Analytics API in Azure. Open azure portal and click on add and choose category “AI + Cognitive Services” and then select an option of “Text Analytics API”.
  • Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)Oct 13, 2017. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience that may be helpful.
  • User-Defined Types In SQL ServerOct 13, 2017. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Understanding Translator Speech API In AzureOct 12, 2017. Microsoft Translator Speech API is a cloud-based automatic translation service. The API enables developers to add end-to-end, real-time, speech translations to their applications or services.
  • T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
  • Understanding Bing Search API In AzureOct 12, 2017. The Bing Search API adds intelligent search to your app, combing hundreds of billions of webpages, images, videos, and news to provide relevant results with no ad requirements. The results can be automatically customized to your users' locations or markets, increasing relevancy by staying local.
  • How To Send Notification Via SMS When Dropbox Is Modified With Microsoft FlowOct 12, 2017. This article helps you to learn how to notify someone via SMS when a Dropbox file is modified through Microsoft Flow.
  • Understanding Face API In AzureOct 11, 2017. Add facial recognition capabilities to your app with the Face API. State-of-the-art algorithms detect human faces in images, opening a range of facial capabilities to your apps. Face detection can also identify attributes, including face landmarks (nose, eyes, etc.), gender, age, and other machine-predicted facial features.
  • Deploying A Virtual Machine Using Azure PowerShellOct 11, 2017. Azure PowerShell provides a set of cmdlets that use the Azure Resource Manager model for managing your Azure resources. You can use it in your browser with Azure Cloud Shell, or you can install it on your local machine and use it in any PowerShell session. It is optimized for managing and administering Azure resources from the command line, and for building automation scripts that work against the Azure Resource Manager.
  • Custom Script Extension For WindowsOct 11, 2017. In this article, we will see how to work with custom script extension in Azure Virtual Machines.
  • Deploying A Virtual Machine Using Azure CLI 2.0Oct 11, 2017. In this article, we will see how to deploy a Virtual Machine in Azure using Azure CLI 2.0 in the portal itself.
  • Understanding Computer Vision API In AzureOct 11, 2017. The Computer Vision API gives you the tools to understand the contents of any image. Create tags identifying objects, beings, or actions present in the image, and then craft coherent sentences to describe it.
  • Cloud Databases In Azure - Part OneOct 11, 2017. In my previous articles on Azure, I have explained about the IaaS features of Azure i.e. creating Virtual Machines, databases etc. In this article, we will see the Introduction of Cloud Databases i.e. PaaS side of Microsoft Azure.
  • Shared Storage Using Azure File ServiceOct 10, 2017. In most cases, the virtual disks we are creating for an Azure VM are connected to that particular VM with a 1:1 relationship which can’t be accessed by another VM at the same time. In case you need a shared storage by multiple VMs you should use Azure File Shares. Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. This is mostly used in case of any requirement of something like a shared application setting or if you need to share any tools or utilities between developers and administrators.
  • Introduction To Document DB In AzureOct 10, 2017. In this article, we will see how to create Azure Document Db which we also call Azure Cosmos Db.
  • Azure App Service - Deployment SlotOct 08, 2017. Azure makes it easy, to create deployment slots for App Services. It’s available in the Standard or Premium App Service plan mode. Deployment slots are actually live apps with their own hostnames. App content and configurations elements can be swapped between two deployment slots, including the production slot.
  • How To Connect Facebook to Twitter With Microsoft FlowOct 08, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one place and do something with the data from that event in another one service.
  • How To Save Email Attachment From Outlook To Dropbox With Microsoft FlowOct 08, 2017. This article helps you to learn how to create a Flow between the Outlook attachment to Dropbox.
  • ASP.NET - Connect To Azure Cosmos DBOct 07, 2017. This article will show how to configure and use CosmoDB on an ASP.Net MVC web application, The tasks will be stored as JSON documents in Azure Cosmos DB.
  • ASP.NET - Connect to MySQL Azure DatabaseOct 07, 2017. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a MySQL Azure database.
  • Create Simple Azure FunctionOct 07, 2017. Azure functions allow up to run the code in a server-less manner. That means we do not have to create the VM to host the running code nor do we have to create a web application and publish code to web applications to run continuously.
  • Deploying A Virtual Machine Using Unmanaged DiskOct 07, 2017. In the previous article, we deployed a Windows VM using the managed disk. In this article, we are going to see how we can deploy a VM using an unmanaged disk. For demo purpose, I am using a Linux VM instead of windows here.
  • Understand Azure Machine Learning WorkbenchOct 07, 2017. Understand Azure Machine Learning Workbench and see what is new and how it works.
  • Azure Blob Storage In ASP.NET Core 2.0Oct 06, 2017. In this article you will learn how to use Azure Blob storage in ASP.NET Core.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part OneOct 06, 2017. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need to identify an encryption approach that best suits the requirement. I'm going to share my experience in finding the encryption approach and implementing it on a sample database.
  • How To Connect OneDrive To Google Drive With Microsoft FlowOct 05, 2017. This article helps you to learn how to create a Flow between the OneDrive files and Google Drive files.
  • How To Log Messages (Information, Errors, Warnings) In ASP.NET CoreOct 04, 2017. Framework provides logging capability through ILoggerFactory, to which you could attach one or more providers. Providers act on the logged data in some form i.e., log it to file, database, Azure etc.
  • Introduction To Machine Learning In AzureOct 04, 2017. In this article, we will see what machine learning is and how it differs from traditional programming.
  • Deploying A Windows Virtual Machine In The Azure PortalOct 04, 2017. Azure Virtual Machine (VM) is one of the several types of on-demand, scalable computing resources that Azure offers. Typically, you choose a VM when you need more control over the computing environment than the other choices offer. Let's see how to create an Azure VM from the portal.
  • Azure Machine Learning - Classification Predictive Analysis Using Iris DatasetOct 04, 2017. In this tutorial, you will learn to create a machine learning model in Microsoft Azure Machine Learning Studio.
  • Azure Deployment Details And LogsOct 03, 2017. I am working on Microsoft Azure services from last 3-4 years. I always like to work on cloud platform provided by Microsoft. Microsoft always comes up with new services, features with their products. I have observed one thing with Azure that creating any resources or creating design is not big deal. There are lots of technical material and forums provided by Microsoft. Most challenging thing with azure is troubleshoot any issue till you actual route cause.
  • How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)Oct 03, 2017. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Migrate SharePoint On-Premises Content To SharePoint Online Using SPO APIOct 02, 2017. Below is the step by step SharePoint Online PowerShell cmdlets to migrate the content. It requires minimal CSOM (Client object model) call to avoid the threshold. It leverages a temporary Azure Blob Storage container to hold the content and Azure Queue, which schedule parallel jobs.
  • How To Start VM Automatically In AzureSep 29, 2017. Virtual Machines provides flexibility to install and configure anything, any time and use it as you want. As well as all these features, VMs are costly so developers or managers of VMs needs to make the cost effective, for this Azure provides Automation Scripting to start and stop a VM automatically so that it will be cost effective besides it is flexible.
  • How To Create Blobs In Microsoft Azure Using C#Sep 29, 2017. This article is in continuation of a previous article - “Understanding Cloud Storage in Azure”, where we created a storage account and a Blob container with the name “images”.
  • WebGrid Custom Paging Links To Avoid Load On Server Using Stored Procedure And ASP.NET MVCSep 27, 2017. I will show you how to fetch the data dynamically from the database and bind to the WebGrid control, using the stored procedure in MVC 4.0. In this blog, today, I will show you how to write code in ASP.NET MVC for implementation of WebGrid Control using Static Data. In later sessions, I will show you the process of using GridView Dynamically, that means using SQL Server data source.
  • Azure NoSQL In ASP.NET Core 2.0Sep 26, 2017. The sample code will require you to set up an Azure account, NoSQL database and collection.
  • Understanding Cloud Storage In AzureSep 26, 2017. In this article, I will explain about Storage Accounts (Storage Accounts can hold hundreds of terabytes of data.) and we will see how we can use Azure Storage as a place to keep uploaded files for our web application and how we can allow users to download files from storage by creating and handling out what is known as a shared access signature (SAS).
  • Azure Logic Apps Integration With Microsoft TeamsSep 22, 2017. In this article, you will see how you can use Azure Logic Apps to get your RSS Feeds converted into short links and get them delivered directly into your Microsoft Teams channel and mailbox.
  • How To Secure PII Data In SQL Server Using .NET AssemblySep 21, 2017. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data WarehouseSep 21, 2017. I will share how you can start migrating your data into the Azure SQL Data Warehouse
  • 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical InterviewsSep 19, 2017. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
  • Create A Website Having Azure Active Directory Authentication Using Visual StudioSep 19, 2017. Azure Active Directory (Azure AD) is Microsoft’s multi-tenant, cloud based directory and identity management service. Azure AD combines core directory services, advanced identity governance, and application access management. Azure AD also offers a rich, standards-based platform that enables developers to deliver access control to their applications, based on centralized policy and rules.
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.
  • Convert Rows To Columns Using Dynamic Pivot In SQL ServerSep 17, 2017. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
  • Create Log Backup Maintenance Plan In SQL Server 2016Sep 17, 2017. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
  • Building Web Applications And APIs In AzureSep 14, 2017. In this article, we will look at building Web Applications and APIs with Microsoft Azure. We will see how we can use Azure as a platform for our applications, and we will see different options for creating and deploying an application.
  • Azure SQL Data Warehouse - Why Enterprises Should Now Consider It SeriouslySep 14, 2017. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
  • SQL Server DB Backup Using Stored Procedure In WinForm ApplicationSep 14, 2017. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
  • Kickstart Azure Database For PostgreSQLSep 10, 2017. This blog post will walk you through creating an Azure Database for PostgreSQL in Azure Portal. PostgreSQL is a powerful, open source object-relational database system and has capability to handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Azure Database for PostgreSQL is a managed service which enables you to run, manage, and scale PostgreSQL databases in the cloud.
  • Introduction To Translator Speech API - Microsoft Cognitive ServicesSep 09, 2017. In my previous article on Microsoft Azure Cognitive Services, we saw how to register for Microsoft Cognitive Services and how we can use Face and Emotional API’s. In this article, we will see how we can use Translator Speech API and what its features are.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • Getting Started With Bing Image Search APISep 08, 2017. In this tutorial, we will learn how to use Bing Image Search API. Remember, in our first example of cognitive services, we had created a demo Bing Speech API. In this tutorial, we will extend the same demo to search images, i.e., we will pass the text result of Bing Speech API to Bing Image Search API.
  • Getting Started With Bing Emotion APISep 08, 2017. In this tutorial, we will learn how to use Bing Emotion API. In our previous example of the cognitive service demo, we had combined two cognitive services, Bing Speech API and Bing Emotion API, so as to find images using speech to text (STT). To extend this demo, we will be using Bing Emotion API which will detect the emotions of a person from the image that we had searched using Bing Image Search API.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • Windows Azure Bot FrameworkSep 06, 2017. During //Build 2017 Microsoft announced Azure Bot Framework
  • Where Can I Use Common Azure CosmosDB (Use Cases)?Sep 06, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service for managing data at planet-scale. It builds upon and extends the earlier Azure DocumentDB which was released in 2014.
  • How Should We Store Images And Blob Files In SQL ServerSep 06, 2017. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects also know as BLOBs, such as images and sounds, into SQL Server.
  • New String Function In SQL Server 2017Sep 06, 2017. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
  • Deep Dive Into Microsoft AzureSep 06, 2017. Microsoft Azure is a growing collection of integrated cloud services which developers and IT professionals use to build, deploy and manage applications through our global network of datacentres. With Azure, you get the freedom to build and deploy wherever you want, using the tools, applications and frameworks of your choice.
  • Understanding Bot Service In AzureSep 06, 2017. This article will give an overview about the MS bot framework. Open azure portal and click on add and choose category “Data + Analytics” and then select the option “Bot Service”.
  • Understand Serverless Architecture In AzureSep 05, 2017. This article will give an overview about the server-less architecture functionality present in Azure using Logic App.
  • How To Backup A Mirrored Database Using SQL AgentSep 04, 2017. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.
  • Getting Started With Azure SchedulerSep 04, 2017. Azure Scheduler allows you to describe actions to run in the cloud. You can schedule and run the actions automatically. You can schedule the scheduler by using Rest API or azure PowerShell.
  • Connecting To MySql Database In StrapiSep 04, 2017. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • Getting Started With Azure TablesSep 01, 2017. In this article, we will walk through some important concepts of Azure Tables through Emulator. Create the Azure Tables by using Microsoft Azure Storage Explorer.
  • Learn About Azure Cognitive ServicesSep 01, 2017. Microsoft Cognitive Services (earlier known as Project Oxford) provides us the ability to build intelligent applications, just by writing a few lines of code. These applications or services are deployed on major platforms like Windows, iOS, and Android. All the APIs are based on machine learning APIs and enable developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications.
  • Setup Of Virtual Machines On Azure Using TerraformSep 01, 2017. Microsoft recently announced increased investment in integrating Terraform with Azure (Aug 2017). This is a continuation of Microsofts’ reach into the agnostic/multi-cloud cloud arena, where they are doing whatever it takes to help developers succeed in the cloud. It used to be the case that Azure was only for Micosoft developers - well no more. The crew in Redmond and every office around the globe are really pushing the open-source and 'Azure for everyone' opportunity.
  • How To Upgrade ADFS 3.0 To AD FS Server 2016 - Part OneAug 31, 2017. Being said that, Now a days ADFS is one of the very critical infra since it is used for Identity services which being used for office365, Azure, Applications be it in any which way it is been created/developed in terms of SAAS, PAAS and On-premises. I have seen the scenarios where ADFS is down, the complete company’s major applications are also going down. So we need to carefully plan and upgrade the ADFS infra. Any wrong command or wrong execution plan can mislead the infra and complete ADS infra can go down.
  • Working With Azure Tables - Part OneAug 31, 2017. You will see the introduction to Azure tables, accessing the table using emulator, and managing tables manually.
  • All About Azure Government Training ResourcesAug 31, 2017. We can’t imagine our world without cloud computing, whether we realize or not. Without it there would be no Facebook, no Twitter, no Gmail.
  • What Is New In Azure Portal UpdatesAug 29, 2017. In this article I am talking about a video in which Leon Welicki and Scott Hanselman introduce us to an update from Azure Portal.
  • Learn About Azure Mobile ServicesAug 28, 2017. Azure mobile app service provides high scale functionality of azure app services to add sign -in, push notifications, data sync and many more. It also helps us to connect your app to many Enterprise systems. It provides a scale up facility for many customers across multiple geographies.
  • Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
  • Creating Login Form For Users With Image Uploading For Password RecallAug 27, 2017. The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if you forget your password.
  • Azure API App With ASP.NET WEB APIAug 27, 2017. In this article, we will see how to create Azure Web Api with your Visual Studio tool. Create a sample Web API Application in VS 2015 and publish Web api in Azure.
  • New Features In SQL Server 2017Aug 27, 2017. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new features in SQL server 2017.
  • Deep Dive Into Xamarin With Azure Mobile ServiceAug 26, 2017. This article shows you how to add a cloud-based backend service to a Xamarin.Forms app.
  • Availability Of Azure Database For MySQL And Azure Database For PostgreSQL In IndiaAug 26, 2017. In Indian data centers (Central and West India), the public preview of Azure Database for MySQL and Azure Database for PostgreSQL are available. And their services provide app developers the ability to choose from an even wider number of geographies, and deploy their favorite database on Azure, without the complexity of managing and administering the databases.
  • Getting Started With Azure Cognitive ServicesAug 25, 2017. This article will give you a kick-start for getting started with Azure Cognitive Services.
  • Understand Azure Cosmos DB - DocumentDB API (SQL)Aug 24, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service "for managing data at planet-scale." It builds upon and extends the earlier Azure DocumentDB, which was released in 2014. It is schema-less and generally classified as a NoSQL database. In this article I am going to create an Azure Cosmos DB using SQL.
  • Getting Started With Azure Service BusAug 24, 2017. It's communication engine which provides secure and reliable communication between components. It allows you to build applications and connect with different roles between Web and worker TL, you can use this for load labeling and or for decoupling where your web TS sent messages into a queue.
  • Accessing Microsoft Graph Data Using Azure AD Authentications From SPFxAug 24, 2017. Let us see how to call Microsoft cloud data using Azure Active Directory authentications from SharePoint framework components.
  • Creating Virtual Machine Using PowerShellAug 22, 2017. This article is about the creation of Virtual Machines in the Azure Cloud Service with the help of PowerShell commands.
  • How To Build A Linear Regression Web Service In Azure ML ModelAug 22, 2017. In this article, we are going to build a linear regression model. After building the model, we will train it and publish it as a web service so that we can use the service in any application.
  • Azure Cloud - A Close LookAug 22, 2017. Every two or three years, a new technology comes along which carries the potential to change the world, and “Cloud Computing” is the one. However, there are numerous terms and definitions floating around in the industry for “the cloud”, “cloud computing”, “cloud services”, etc.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Introduction To Azure Media ServicesAug 21, 2017. In this article, we will see how to create and use Media Services in Azure.
  • Building Serverless Mobile App With Azure Functions Using Xamarin.FormsAug 20, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. We can create, execute, and test our custom logic function without creating a VM or web applications and also without needing to install any software or infrastructure to run the function. In this article, we'll learn how to implement azure functions and directly call through HTTP from Xamarin Forms Application
  • Getting Started With Microsoft Azure Machine Learning - Part TwoAug 19, 2017. This article will give you an idea about Microsoft Azure Machine learning.
  • Developing ASP.NET Apps With Azure Active DirectoryAug 19, 2017. In this article, we will see how to authorize our MVC application using Azure Active Directory.

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!