C# Corner

Resources  
  • Deploying ASP.NET Core 2.0 App To Azure Using DockerJan 18, 2018. Azure provides a highly scalable, configurable and easy to use Platform-as-a-Service (PaaS) environment for our ASP.NET Core web applications. Azure Web App is one of the simplest ways to host web applications and the new Web App Container makes it really easy to host Docker containers.
  • Create Your First ASP.NET Core 2.0 Service Fabric Container Application In WindowsJan 16, 2018. Learn how to create your first ASP.NET Core 2.0 Service Fabric Container application in Windows.
  • Basics Of Angular And Its Versions - Part ThreeJan 16, 2018. In this article, I am going to explain more on one of the 8 main building blocks, that is, Services.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Create An Intelligent Bot Application Using Microsoft Bot FrameworkJan 12, 2018. In our previous article, we learned how to create and connect a chatbot with Azure Bot Service. But in this article, we are going to create an intelligent Bot Application using Microsoft Bot Framework.
  • AI Series - Part Two - Programming EmotionsJan 12, 2018. I will be showing how to start AI Development with Cognitive Services. Previously, we kickstarted our new article series “AI HowTo” and talked about how to register for Emotion API Preview(Project Oxford) through Azure Portal.
  • Creating REST Service Using Flask And PythonJan 11, 2018. This article will explain to create REST service by using Flask framework and Python.
  • AI Series - Part One - Registering For Emotion APIJan 11, 2018. I will be showing how to start AI Development with Cognitive Services.
  • How To Create An Angular Service And Access It In Multiple ComponentsJan 10, 2018. In our previous article, we developed a single page application using Angular 4. Now in this article, we are going to talk about services.
  • How To Configure User Profile Service Application Step By StepJan 10, 2018. In the last article I described about how to delete and create User profile service, today I'm demonstrating about how to configure UPA service application step by step with a screen shot. This articles applies to SharePoint 2010, 2013 and 2016.
  • Introduction TO PowerApps And Creating Template With ItJan 09, 2018. PoweApps is a collection of software services and apps that work together to fundamentally transform and accelerate. It is provided by Microsoft as a service under Office 365 for non-technical users (no coding experience is required) to build business apps. It can be simple and fast.
  • Add Some Intelligence To Your C# Apps With Microsoft Cognitive ServicesJan 09, 2018. In this article, you will learn how to use Microsoft Cognitive Services from your C# applications.
  • How To Remove And Create User Profile Service Application In SharePointJan 09, 2018. The purpose of this article to is to delete an existing UPA service from the SP server and create the same from scratch. As we know, there are two ways to configure or delete UPA server, Using UI and SharePoint PowerShell. We are going to delete and create UPA using UI.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • Using HTTPS In ASP.NET Core 2.0Jan 05, 2018. Create an empty project and update Startup to add services and middleware for MVC, including the filter for HTTPS.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • Share Code Between ASP.NET Core MicroServicesJan 04, 2018. Microservice architecture or microservices is a method of developing software applications as a suite of independently deployable, small, modular services in which each service runs a unique process and communicates through a well-defined, lightweight mechanism to serve a business goal.
  • Create And Connect A Chat Bot With Azure Bot ServiceJan 04, 2018. This article explains how to Create and Connect a chat bot with Azure Bot Service.
  • Custom Service Dependency Injection In .Net Core 1.1Jan 04, 2018. In this article we will go through one of the key features of .Net Core, Custom Service dependency injection in .Net core 1.1, particularly at controller’s action level .
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Intelligent Image Object Detection Bot Using Cognitive Computer Vision APIJan 02, 2018. Microsoft Cognitive services is set of cloud based intelligence APIs for building richer and smarter application development. Cognitive API will be used for searching meta data from Photos and video and emotions, sentiment analysis and authenticating speakers via voice verification.
  • Worker Role In Azure Cloud ServiceJan 02, 2018. From this article, you will learn how to play with worker role in Azure cloud service
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • Azure Service Bus Queues Dec 29, 2017. From this article, you will learn how to work with Azure Service Bus Queues.
  • Getting Started With Azure Service BusDec 26, 2017. From this article you will learn an overview of Azure service bus and ow to create an Azure service bus namespace using the Azure portal
  • Build Scalable Web Applications With Azure Database For MySQLDec 26, 2017. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managing a database. See how the service helps you quickly respond to changing customer needs by scaling up and down. And see how capabilities like high availability and replication help you meet and exceed customer expectations.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • SharePoint 2013 - Different Ways To Enable User Information ListDec 22, 2017. You can find a great description of User Information List on MSDN, yet if I had to explain it in brief I would say it’s a list which stores the users and their information. The information of the users includes details like their Name, Email ID, Display Name, Login Name, Job Title, About User, and Department. Whenever a user is added to the site, he/she appears in the User Information List. The User Profile Services sync the user data into the User Information List from Active Directory.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Asynchronous Messaging Using ASP.NET Core 2.0 Web APIDec 21, 2017. How to implement asynchronous messaging using ASP.NET Core Web API. Create an empty project and update the Startup class to add services and middleware for MVC.
  • Get Started With DevOps With VSTSDec 19, 2017. Zero to DevOps with Visual Studio Team Services.
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • Building Multitenant Architecture Using ASP.NET Core And Micro ServicesDec 18, 2017. Instead of deploying an application per client, organizations prefer multitenancy to save infrastructure cost and deployment time. Multitenant architecture helps to adapt changes for different clients under the hood. In this article I am not going to discuss database design for multitenant applications but I will be focused on achieving separation for different clients.
  • Implementing Power BI - Part 1Dec 18, 2017. Power BI is the product of Microsoft. It is used as a tool for developing and creating business analytics. It provides interactive visualizations for creating reports, charts, tables and dashboards.
  • Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.
  • Export SQL Result To A Text FileDec 18, 2017. This article gives an overview of how to export SQL query results to a text file.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • Versioning ASP.NET Core 2.0 Web APIDec 13, 2017. As your Web API changes, you would need to add versioning support in order for clients to continue working correctly. Adding versioning support in ASP.NET Core involves first configuring services in Startup and then choosing a versioning strategy i.e. via query string, URL or HTTP header.
  • Xamarin.Forms - Working With Files Using DependencyServiceDec 13, 2017. In this article, you will learn how to create a file using Dependency Service in Xamarin.Forms.
  • Sorting In ASP.NET Core 2.0 Web APIDec 12, 2017. Sorting information is usually received via query parameters. The POCO SortingParams simply hold this information and passes to service (or repository).
  • 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.
  • Paging In ASP.NET Core 2.0 Web APIDec 11, 2017. Paging information; i.e., page number and page size, is usually received via query parameters. The POCO PagingParams simply holds this information and passes it to service (or repository).
  • Filtering In ASP.NET Core 2.0 Web APIDec 10, 2017. Filtering information is usually received via query parameters. The POCO FilteringParamssimply hold this information and passes to service (or repository).
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • 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.
  • 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.
  • 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.
  • Introduction To BotsDec 03, 2017. Introduction to Bots and Bot Framework.
  • 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.
  • 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.
  • Passing Data Between Components - Day TwoNov 29, 2017. We have seen that we can pass the data between the components using the @Input and @Output directives and using event emitters. Let’s see the other two methods - @View child and the services which can be used to pass the data between components.
  • Client Side Routing Using Angular In MVCNov 29, 2017. AngularJS supports a Single page application routing module called ngRoute. When a user requests a specific url, the routing engine fetches that url and renders the view based on the defined routing rules. AngularJS appends '/#/' to the url to redirect to a particular url using $location service. For example, to redirect to '/Article', the url would be http://localhost/#/Article.
  • Custom Vision Service REST API Using Web Interface To Upload Image And TrainNov 28, 2017. Custom Vision Service using Visual intelligence made easy to just bring a few example of labeled images and let Custom Vision do the hard work.
  • 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 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.
  • 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.
  • Angular Components And ModulesNov 23, 2017. In programming terms, Modules can be described as the self-contained chunks of the functionality in your application which can run independently. In Angular, Modules are the collection of the components, services directives, and Pipes which are related such that they can be combined to form a module.
  • SharePoint 2016/2013/Online - How To Apply Password Encryption For Component As Service Using PowerShellNov 22, 2017. In this article, I will discuss the mechanism to authenticate the requests to SharePoint Lists while working with PowerShell.
  • Developer's Tools - How To Generate Basic Authentication TokenNov 22, 2017. This demo is about another tool that I worked out during an assignment while working with an integration scenario using web services supporting Basic Authentication.
  • How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • Migrate From TFS To VSTSNov 21, 2017. Migrate from TFS to Team Services with the TFS Database Import Service.
  • Building API Gateway Using Ocelot In ASP.NET CoreNov 21, 2017. Ocelot is aimed at people using .NET running a micro services / service orientated architecture who need a unified point of entry into their system.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • 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.
  • Make A Text Recognition App Using Xamarin.AndroidNov 20, 2017. Today, I shall show you how to create a Text Recognition app using Xamarin Android. I shall used Xamarin Google-Play-Services Vision for text recognition.
  • 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.
  • How to Return Files From Web APINov 18, 2017. This article explains how to transfer/ return files(PDF/Doc/Excel/zip) files from Web API service
  • 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.
  • Monitoring S3 With Events And SNSNov 16, 2017. This is Muhammad Habib Jawady in a new DevOps hands-on tutorial. In my first Amazon Web Services tutorial, I will be showing you how to leverage the S3 events feature and Simple Notification Service In order to monitor actions taken on certain assets .
  • How To Save Office 365 Email Attachment To OneDrive With Microsoft FlowNov 16, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another one Service. It makes it practical and simple for line-of-business. The users build workflows that automatically do some business tasks and processes across applications and services.
  • Basic Introduction To ISAPI FiltersNov 15, 2017. In this article we will have a look on ISAPI filters in windows SharePoint services
  • 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.
  • Calculated Columns In Power BINov 15, 2017. In this article, we will talk about calculated columns in Power BI. To prepare any report in real life, we must have to prepare calculated columns and measures in Power BI.
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • 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.
  • 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.
  • How To Lock Objects In Power BINov 11, 2017. Sometimes, there is a situation where when we open a report and click on any visuals, it accidentally nudges a chart a little bit to the right or left. Sometimes, by mistake when end user viewing a report, arrangement of visuals scatters little bit. Microsoft rolls out one new amazing feature to resolve this issue and that is Lock Objects in Power BI.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • ASP.NET Core 2.0 MVC Dependency Injection In ViewsNov 01, 2017. In ASP.NET Core dependency injection is not limited to middleware, controllers and models etc. Views can also benefit from the services configured in the service container.

About SQL-reporting-service

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!