C# Corner

Resources  
  • 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.
  • 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
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Windows Azure Bot FrameworkSep 06, 2017. During //Build 2017 Microsoft announced Azure Bot Framework
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Getting Started With Azure Cognitive ServicesAug 25, 2017. This article will give you a kick-start for getting started with Azure Cognitive Services.
  • 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.
  • 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.
  • 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.
  • How To Use Microsoft Graph Provider In Visual Studio Connected ServicesAug 22, 2017. In this article, I am introducing the newly added Microsoft Graph Provider in Visual Studio 15.3.1. This article demonstrates how a developer can use this feature to work with Microsoft Graph API.
  • 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.
  • 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
  • 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.
  • Getting Started With Microsoft Azure Machine Learning - Part TwoAug 19, 2017. This article will give you an idea about Microsoft Azure Machine learning.
  • Getting Started With Microsoft Azure Machine Learning - Part OneAug 19, 2017. It’s a data modeling environment from which we can get an end-to-end approach to a problem to an answer. Use Azure Machine Learning to deploy your model into production as a web service in minutes—a web service that can be called from any device, anywhere and that can use any data source.
  • Understand Azure Cosmos DB - Table APIAug 18, 2017. Cosmos DB is a globally distributed multi-model database. Using the API, applications running on Azure Table storage can take advantage of secondary indexes, turnkey global distribution, dedicated throughput, and single digit millisecond latency with 99.99% comprehensive SLAs.
  • Creating A Web App Service Using AzureAug 18, 2017. In this article, you’re going to learn how to host your web app using Azure and how to update your app using Staging slot and external repository such as GitHub.
  • Understanding Media Services In AzureAug 17, 2017. Azure helps you to build custom media workflows in the cloud. It’s an end-to-end solution that delivers audio and video virtually in any device anywhere. It offers end-to-end workflow which is very highly scalable in coding, packaging, storing and distribution of media content to a wide range of devices including TV, PC, and mobile devices.
  • Understanding API Apps In AzureAug 17, 2017. API apps in Azure make it easier to develop, host, and consume APIs in the cloud and on-premises. It provides security, simple access control, hybrid connectivity, automatic SDK generation, and seamless integration with Logic Apps. It’s a fully managed platform for web, mobile, and integration scenarios.
  • Getting Started With Windows AzureAug 17, 2017. Windows Azure can be anything you want it to be. As a cloud platform from Microsoft that gives a wide variety of different services, windows Azure helps you to construct, install, and manipulate solutions for nearly any motive you may consider. In different words, windows Azure is a global service of unlimited possibilities.
  • Getting Started With Microsoft Azure Functions Using Visual Studio 2017Aug 17, 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.
  • Deploying Traffic Manager On Azure PortalAug 17, 2017. In this article, I am going to describe what Traffic Manager is and how to deploy the Traffic Manager on the Azure portal.
  • Configuring Azure AD With App Permissions For SharePoint REST API AuthenticationsAug 15, 2017. Let us see how to setup the Azure Active Directory with necessary app permissions for accessing the Microsoft data using graph API.
  • Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
  • Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
  • How To Create And Test Azure Functions Using Azure PortalAug 15, 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, you will learn about create and test azure functions using azure Portal.
  • Understanding Connectors In AzureAug 14, 2017. This article will give a quick start-up for creating the storage account and logic App for connection
  • Understand Service Scheduler In AzureAug 14, 2017. It is a task scheduling service provided by Microsoft Azure. It can perform many actions regarding the job details in the scheduler and can also check Scheduler’s monitoring and management capabilities.
  • Getting Connected With Twitter In AzureAug 14, 2017. This article will give you a quick start for connecting with the Twitter social app in your Azure account.
  • Google OAuth 2.0 Authorization In Azure APIAug 13, 2017. Here, I am going to demonstrate how can we use Google OAuth 2.0 in Azure API. App Service Authentication/Authorization is exposed in the Azure Preview Management Portal.
  • Introduction To Microsoft's Coco Framework For Blockchain Applications - Part OneAug 13, 2017. Nowadays, we all are going through the boom of Blockchain technology. There is lot of information coming in our way, regarding implementation and adoption of this technology. So far we are aware of blockchain technology, its implementation for public networks like bitcoin, and platforms for creating private blockchain network like azure ethereum consortium blockchain.
  • Key Capabilities Of Azure Cosmos DBAug 12, 2017. A few years ago, Microsoft offered DocumentDB as a Service (DaaS) that supported a limited set of features and functionalities. Today, most of the cloud-based services, such as Bing, Azure, and Office 365 are using DocumentDB. Microsoft took DocumentDB to the next level and came up with Azure Cosmos DB - A globally distributed, multi-model database.
  • IoT Solutions - Architecture/Design And Business AspectsAug 11, 2017. IoT is the abbreviated term meaning "Internet of Things". By definition Internet of Things is: the inter-networking of physical devices, vehicles (also referred to as "connected devices" and "smart devices"), buildings, and other items embedded with electronics, software, sensors, actuators, and network connectivity which enable these objects to collect and exchange data.
  • Deploying Batch Services On Azure PortalAug 11, 2017. In this article, I am going to describe what Batch Services are and show how to deploy them on the Azure Portal.
  • Deploying Batch Services In User Subscription Mode On Azure PortalAug 11, 2017. This article is in continuation of my previous one and we'll learn how to use User Subscription for Batch Services in Azure portal.
  • Learn Azure Blob StorageAug 11, 2017. Basically, it represents the durable store in the Azure cloud. And also, it allows storing blob, tables, messages, and queues.
  • Buy Domains Using Azure App Service DomainAug 10, 2017. Here, I’m going to explain how to purchase a domain using Azure App Service domain.
  • Getting Started With Azure Functions Using Azure Free Trial AccountAug 09, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. Azure Functions let you develop serverless applications on Microsoft Azure. In this article, you will learn how to create Azure Functions without creating an Azure account.
  • Overview Of Azure Data LakeAug 09, 2017. In this article, we will walk through some important concepts of Azure Data Lake and its implementation.
  • Understanding Azure Mobile ServicesAug 09, 2017. This article will give you an idea about the Azure Mobile Services. It allows the functionality of Azure App Service to add sign-in, push notifications, and data sync to your mobile app. Connect your app to enterprise systems and on-premises resources.
  • Architecture Of Azure Ethereum Consortium Network - SimplifiedAug 08, 2017. A network created using Azure Consortium Blockchain template consists of shared transaction nodes and mining nodes. User application will interact with transaction nodes for any operation like submit transaction etc. For each consortium member (the number of members is specified while configuration), specified number of mining nodes are created.
  • Understanding DocumentDB In AzureAug 08, 2017. This article will give you a feel for Azure DocumentDB. It is a NoSQL document database service designed from the ground up to natively support JSON and JavaScript directly inside the database engine.
  • Deploying A Docker On Ubuntu Using Microsoft Azure PortalAug 08, 2017. This article shows how to install docker on ubuntu in the Azure portal. Sign-in into the Azure Portal by entering your email and the password, If you don't have any account press this Link to create a new account.Enter the mail address and press next.
  • Getting started With Azure Ethereum Consortium BlockchainAug 08, 2017. Azure started supporting a number of distributed ledger technologies that fulfill business requirements in security domains and many more. Azure has started Blockchain as a Service (BaaS). It will emerge as platform for creating applications rapidly on cloud technologies. Azure has come up with many blockchain solutions like Ethereum Consortium, STRATO Blockchain LTS, Emercoin Blockchain etc.
  • Deploying An Ubuntu Server 16.04 LTS Virtual Machine Using Microsoft AzureAug 08, 2017. In computing, a Virtual Machine is an emulation of a computer system. Virtual machines are based on computer architectures and provide functionality of a physical computer. Their implementations may involve specialized hardware, software, or a combination. Azure Virtual Machine (VM) is one of several types of on-demand , scalable computing resources that Azure offers.
  • Connecting SharePoint Online Using PowerShellAug 08, 2017. PowerShell is a powerful Command Line Shell Script mainly used by the administrators, and manages anything in Microsoft products.
  • SQL Azure With Entity FrameworkAug 08, 2017. Exploring SQL Azure With Entity Framework
  • Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
  • Understanding Blob Storage In AzureAug 07, 2017. This article will give you an idea about the Blob storage accounts in Azure Explorer.
  • Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
  • Understanding Virtual Machines In AzureAug 06, 2017. It is an operating system or application environment that is installed on software, which reproduces dedicated hardware. End user has the same experience on a virtual machine as they would have on dedicated hardware.
  • Understanding SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • Understanding SQL Azure - Part OneAug 06, 2017. This article will give a idea about creating SQL DB in Azure and using it in Visual Studio
  • How To Determine The Version And Edition Of SQL Server And Its ComponentsAug 06, 2017. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.
  • Understanding App Service In AzureAug 06, 2017. It will allow you to get started with the app-services in Azure.
  • Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.

About connect-to-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!