C# Corner

Resources  
  • Introduction To SSISNov 24, 2017. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and first time introduced in SQL Server 2005. It’s a powerful replacement of legacy DTS (Data Transformation Services) exists in SQL Server 2000.
  • Essentials Of Azure AD Application RolesNov 23, 2017. One can do a simple guess work here and understand that the roles required in the application maybe called as application roles, and this is right! 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 which are specific to the application e.g. 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 the Facebook post by creating flow between the 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio
  • 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.
  • 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.
  • 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.
  • 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.
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • 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.
  • 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.
  • 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.
  • 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.
  • How To Connect The Outlook Mail To Excel With Microsoft FlowOct 31, 2017. This article helps you to learn how to create a Flow between the Outlook Mail and Excel Spreadsheet.
  • 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.
  • 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.
  • 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.
  • 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.
  • Enable And Disable Wi-Fi In Android Application Using Android StudioOct 20, 2017. In this article, I will show you how to Enable and Disable WI-FI in android App using Android studio. The information that an application can access includes connected network's link speed, IP address, negotiation state, other networks information. Applications can also scan, add, save, terminate and initiate Wi-Fi connections.
  • 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.
  • 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”.
  • 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.
  • 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.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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 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.
  • Starting With Microsoft TeamsOct 05, 2017. Microsoft Teams is a chat based workspace in Office 365. It enables the users to have the contents from all office 365 applications in a single place and it even allows us to connect with third party applications through Connectors.
  • 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.
  • 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.
  • 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.
  • Export Active Users (Licensed Users) In .CSV Format From Office 365 Using PowerShellOct 04, 2017. Sometimes, there is a situation in which we need to connect our PowerShell with Office 365. We have received a requirement from one of our clients, they want csv for all licensed users available in Office 365.
  • 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.
  • 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.

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!