C# Corner

Resources  
  • 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.
  • Exposing Local Web Server To Internet Using NgrokSep 19, 2017. I was recently working on some bot framework applications where I wanted to test if my bot application was working properly with different available channels like Facebook messenger, Skype etc. But there was one problem. Before I could integrate my bot with different channels, I needed to publish my bot application and register it on http://dev.botframework.com/ site. Also the endpoint should support HTTPS. This is where ngrok comes into play.
  • Introduction To Tag Helpers In ASP.NET CoreSep 18, 2017. Tag helper is a new feature in ASP.net MVC. It enables server-side code to create and render HTML elements in Razor View. It is feature of Razor View engine. They are the C# classes which participate in view generation by creating the HTML elements. Using the tag helper, we can change the content of HTML element and add additional attributes to the HTML element. It is very similar to HTML helper in ASP.net MVC.
  • 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.
  • Missing Security Section In PWA Settings In Project Server 2016Sep 18, 2017. In this article, we will discuss and solve the issue of Missing Security Setting in PWA Settings in Project Server 2016 / 2013.
  • 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.
  • Use Of Slicer In Power BI And Its Integration In SharePoint OnlineSep 17, 2017. Power BI is a Microsoft tool which provides many types of Visual Reports such as Clustered Column Chart, Clustered Bar Chart, Pie Chart,Donut Chart,Gauge,R script Visual, Tree map, Filled Map, Waterfall Chart, Scatter Chart, Slicer and many more. Among these I will be demonstrating a slicer which can be used to filter a tabular report and other reports.
  • SharePoint Permission Mode Vs Project Permission Mode In Project Server 2016 / 2013Sep 14, 2017. In this article, we will discuss the Permission Modes in Project Server 2016 / 2013.
  • 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.
  • 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.
  • Build Chat Application On MEA2N Stack - Part OneSep 13, 2017. In this article we are going to build a basic chat application on NodeJs platform using Express and Angular 2. For saving chat history we will use MongoDB. We will be using socket.io for communication between server and client.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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”.
  • 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.
  • How To Upgrade AD FS 3.0 To AD FS Server 2016 - Part TwoSep 01, 2017. This article is in continuation of my previous one. Here we will see how to upgrade AD FS 3.0 to AD FS Server 2016.
  • 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.
  • 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.
  • Extend Built In Label Tag Helper In ASP.NET Core ApplicationAug 31, 2017. Tag helpers is one of the new feature introduced in ASP.NET Core which allows us to add server side code while creating and rendering HTML elements. They are similar to HTML helpers in ASP.NET MVC. ASP.NET Core comes with various built in tag helpers for rendering HTML elements like label, input, img, select etc.
  • How To Auto Increment An Existing Column In SharePoint Online (O365) Using FlowAug 29, 2017. Microsoft Flow is a set of rules that lets various apps communicate with each other automatically. Flow is used to automate processes and tasks.
  • 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.
  • 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.
  • Create Your Own Home .NET /Apache Web Server In 30 MinutesAug 25, 2017. Most C# developers have been yearning to install their work on Apache and Linux, using the Mono project for years. Unfortunately this has been historically very difficult, since the documentation for how to do this has been lacking. In addition, securing and configuring the system after you've installed it, often requires a whole slew of knowledge with which most C# developers are not very familiar.
  • 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.
  • Create Office Web Add-In Project Using Visual StudioAug 24, 2017. In this article, I would like to share the steps to create Office web add-in projects using Visual Studio. In this article, we have explored what Office add-ins are and how to create Office web add-in projects using Visual Studio 2015.
  • Dynamic Menu Using Entity Framework And AngularJS In ASP.NET MVC Aug 23, 2017. The logic behind this is all main menus should have parentid = 0 and whatever ID column value of Main menu that ID value should be mentioned in parentid column of sub menu. Then the sub menu will appear for corresponding Main Menu.
  • 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.
  • JavaScript Code For Validating U.S. Format Phone NumbersAug 21, 2017. In this article, we shall learn how to do client side validation of US format phone numbers in three textbox fields. It means the application will be more responsive because the load on the server is reduced. JavaScript uses the client machine processing power.
  • 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.
  • How To Create A Simple Approval App Using PowerApps And Flow In SharePoint OnlineAug 18, 2017. In this article, you will see how to create a simple approval app using PowerApps and Flow in SharePoint Online. Refer getting started with PowerApps and Flow for more details. I have created a custom list in SharePoint online named Change Request which contains the following columns.
  • 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.
  • 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.
  • Building Container Image Through AutomationAug 10, 2017. The following is the continuation of the previous document. Here we will work with the automation concept through which the container images can be created.
  • 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.
  • 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.
  • 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 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 SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • 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.
  • Building Your Own Container ImagesAug 04, 2017. Here, we will be building our own container images. For doing this we have two different ways, namely manual method and automated method. Let us see both ways.
  • Running Windows Containers On Windows Container HostsAug 03, 2017. In this module, we will be seeing the different commanding techniques that can be used to work with the containers. We will check on how to start and stop a container, and to run them interactively or even in the background.
  • Pulling Base Container ImagesAug 03, 2017. So far, we have deployed our container in the Nano Server VM and Windows Server VM. The next piece of work is to pull down the Images for these containers. The Docker is the container which we have created so far. In the following lab, we will pull some image for that container form the Microsoft Container images repository.
  • Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
  • AWS Lambda And Serverless ComputingAug 02, 2017. Before we learn and understand one of the great features provided by AWS known as AWS lambdas, let’s try to understand what Serverless Computing is.
  • Configuring Nano Server For Remote ConnectionsAug 02, 2017. Here, we are going to connect with the Docker engine remotely using the PowerShell. For this we can either use our local machine or a VM. Before we proceed further, make sure that your Nano Server is up and running.
  • Connecting To Docker In Nano ServerAug 01, 2017. This is about creating a firewall path in between the local machine and the Nano server to get connected with the Docker. This will give access for local machines to access the docker.
  • Creating Windows Server Machine On Virtual Network And Load Balancing itAug 01, 2017. Welcome back to an article about creating another Windows Server Machine on Virtual Network and to work with Load Balancing. Here with this demo article we will be working with the Virtual Network and we will be creating a Load Balancer on it.
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • Installing Docker In Nano ServerJul 31, 2017. This is about the installation of Docker in the Nano Server VM which has been created previously.
  • Creating A V-Net And Adding A Windows Server Machine On ItJul 31, 2017. Welcome to an article about creating a Virtual Network and adding a Windows Server Machine on it
  • How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
  • Why Developers Should Pay Attention To Cognitive ComputingJul 31, 2017. Why Developers Should Pay Attention To Cognitive Computing
  • Installing Windows Server-2016 Nano Server Using PowerShellJul 30, 2017. The following exercise is all about the installation of Windows Server 2016-Nano Server. Open your PowerShell in the administrator privileges.
  • Installing Docker In Windows ServerJul 29, 2017. The following document will provide you the step by step guide to create a windows server operating system and install the docker in it. To proceed with this, you need to login into your Microsoft Azure portal.
  • Creating Web API With ASP.NET Core Using Visual Studio CodeJul 28, 2017. Web API is is framework that allows us to build web or http based endpoints. If you are building services today for mobile, HTML 5, and even client-server desktop applications, all these different types of applications need services in the backend.
  • Managing Your Traffic On Server Applications Using Geographic RoutingJul 28, 2017. Welcome to my first writing on Azure Traffic Manager using Geographic Routing.
  • Azure WebApps - A Complete Walk Through ItJul 28, 2017. This article is about Azure WebApps which is a service from Azure App Service. Azure WebApps is a completely computed platform from Microsoft Azure which helps us to host, manage, create slots, go with traffic manager and many more flexible options to make your WebApp an easier one for the client and for developer.
  • Fog Networks / Fog Computing - An OverviewJul 27, 2017. Like I mentioned in earlier posts, technology is evolving at a very fast pace, though this post will throw light on an up-coming technology, which is set to disrupt most of our networking/cloud compute environments. And the name is FOG
  • Learn MVC Using Angular Dynamic Control In DataTableJul 26, 2017. In this article, we will learn MVC using Angular data binding for dynamic control in datatable from server side Web API using visual studio 2017.
  • Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical DataJul 26, 2017. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
  • How To Check Long Server-Side Process Progress In Real TimeJul 26, 2017. Today, I will show you a way to monitor a long server-side process (like, a long running process, file generation etc.) in real time in your web application. The whole demonstration will be covered through asp.net C# but you can also implement the same sort of code in other languages.
  • Cache Headers For MVC File Action Result (ASP.NET Core 2.0 Preview 2)Jul 25, 2017. I’m pretty sure that you are familiar with StaticFiles middleware of the framework. All it does is serve static files (CSS, JavaScript, image, etc.) from a predefined/configurable file location (typically from inside the web root, i.e., wwwroot folder). But along the way, it also does some cache headers configuration. The reason behind this is you don’t want your server to be called up every time for a file that doesn’t change frequently. Let’s see how a request for a static file looks in the browser’s network tab.
  • Learn Web API : Using SQL Helper ClassJul 25, 2017. This article demonstrates how to use Web API Using SQL Helper Class with easy to use data base access in Visual Studio 2017.
  • Angular, Bootstrap And ASP.NET MVC - Part TwoJul 25, 2017. In this tutorial series, we are going to learn AngularJS as a server side, Bootstrap for layout styling and ASP.NET MVC as server side.
  • Create Your First VM In AzureJul 25, 2017. Cloud computing can be a complex term nowadays, as there are already many services that can run on Cloud. Services like Data mining, Machine learning, creating virtual machines, host APIs for mobile applications and many other endless services.
  • Angular, BootStrap And ASP.NET MVC - Part OneJul 24, 2017. In this tutorial series, we are going to learn AngularJS as a server side, Bootstrap for layout styling and ASP.NET MVC as server side.
  • How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • Project Server 2013 Migration From One Farm To AnotherJul 21, 2017. In this article, I will explain step by step how to migrate/move a PWA Instance from one farm to another in Project Server 2013.
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
  • Ability To Develop HTTP Methods Or Verbs (GET, POST, PUT, DELETE etc)Jul 17, 2017. Before going to explain the significant verbs or methods (GET, POST, PUT, DELETE, HEAD, OPTIONS, TRACE and CONNECT) for the communication among different clients and servers, first of all we should understand what HTTP methods are and how they are useful in real time.
  • Selecting A Content Management System That Supports Your BusinessJul 17, 2017. Recently, a customer asked for a Content Management System (CMS), and being a SharePoint developer and consultant, I proposed SharePoint Server as CMS. Afterwards, by analyzing different CMS in the market, I thought of writing this article and will focus mainly on a CMS named – “Sitefinity” (http://www.sitefinity.com/).
  • Site Columns In SharePoint 2013Jul 15, 2017. Site column is on of the good features in SharePoint . You can reuse the column within your site and subsites. you can also reuse within content type in SharePoint.
  • SharePoint 2016 Build NumbersJul 15, 2017. SharePoint Server 2016 released on March 14, 2016. So let's try to track all the version numbers, Build numbers, and Issue lists.
  • ABC Of WPFJul 15, 2017. Basically I am working on .Net/Sql. For the project requirements I went through the WPF. I visited so many online tutorials and videos to get the knowledge. In this article I am going to share my understanding with you.
  • How Autodiscover Service Works In ExchangeJul 14, 2017. In this article, we will cover how Autodiscover works in Exchange to configure outlook profile for users without manual intermission of the user or administrator. Let’s begin!!
  • How To Create A List/Library Programmatically In SharePoint 2013Jul 13, 2017. We need to install Visual Studio in our machine for creating a list using SharePoint Server Object Model. The Server Object Model will be executed in the server side & it provides a rich set of classes in representing & manipulating SharePoint objects. Server object model is like production server environment to access the data where Sharepoint is installed on the machine.
  • Commands For "Add", "Install", "Update" The Solutions For SharePoint SiteJul 13, 2017. In this article, I would like to share the steps and commands for how to Add, Install and Update, Uninstall and Remove the solutions (WSP Package) in SharePoint server.
  • Connecting And Working With Azure SQL Database Using Visual Studio 2017Jul 12, 2017. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
  • Consume Web API In Winform For File HandlingJul 12, 2017. In this article, we will see in detail how to consume Web API in Windows Form for Uploading File to Web server, get the list of file Information from Server folder and download the file from Server using C# Windows application.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • Deploying The Windows Server 2016 Virtual Machine Using Microsoft AzureJul 10, 2017. This article shows how to deploy the Windows server 2016 virtual machine in Azure Portal.
  • Getting Started With MongoDB - MongoDB In Azure Cosmos DBJul 10, 2017. My last article demonstrated how to interact with the MongoDB database server from a simple C# console application. Now, when you build enterprise applications using MongoDB, your local database server should always be up and running for 365 days or more. This is not appropriate for enterprise applications.
  • Monitoring Our Database When Accessing From Outside Or Applications In SQL ServerJul 08, 2017. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
  • Get Started With Azure DevTest Creating Server Machines With ArtifactsJul 07, 2017. Azure DevTest is an effective resource that Azure has come up with for supporting developers and testers to avoid environment delays, allow self-service actions on turning the VM’s (Virtual Machines) on or off, and works with simple cost effective solutions to leverage the application which we host on the cloud.
  • Simulate SharePoint Online Timer Jobs Using Azure FunctionsJul 05, 2017. SharePoint Server provides native Timer Jobs that inherit SPJobDefinition class to run at regular intervals defined in the SPSchedule object. This way we can create solutions that have to be iteratively run to process logic at regular intervals. However, in case of SharePoint Online Native Timer Jobs cannot be used.
  • Installing SQL Server vNext On Linux - Part TwoJul 04, 2017. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.
  • Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.

About Computed-Columns-in-SQL-Server

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!