C# Corner

Resources  
  • What Does This Little Check Box DoFeb 21, 2018. Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty handy. Use query governor to prevent long running queries.
  • VLFs - The Forgotten FoeFeb 19, 2018. How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
  • SQL Database Query Editor In Azure Portal - An IntroductionFeb 19, 2018. Learn SQL Database Query Editor In Azure Portal.
  • Download User License Information For PowerApps And Microsoft FlowFeb 16, 2018. PowerApps is one of the services available in the Office 365 environment that enables us to create apps or forms for business and other uses without coding experience. We can connect against external data sources like SQL, SharePoint, Salesforce, etc... to develop an application. PowerApps has its own data source called Common Data Service.
  • How To Get Started With Always Encrypted For Beginners - Part ThreeFeb 15, 2018. A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the project was to prevent the DBA from being able to view salary information, while still allowing the application to function without issue.
  • A Beginners Guide To Microsoft BizTalk Server - Part 1Feb 15, 2018. BizTalk Server is a middleware product from Microsoft that helps to connect various systems together. Let’s take an example: If you look at any modern organization it will run its operations using a variety of software products. SAP for their ERP needs, Salesforce for their CRM needs, Oracle for their Database needs, + tons of other home-grown system like HR, Finance, Web, Mobile etc.
  • Publish ASP.NET Core 2.0 Application On Azure With SQL ServicesFeb 15, 2018. In this article, we will learn how to deploy or publish an Asp.Net Core 2.0 application on Azure.
  • SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.
  • How To Get Started With Always Encrypted For Beginners - Part TwoFeb 12, 2018. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or through our applications. You’ll be surprised to see how easy it is.
  • Increase Data Disk Size In AzureFeb 11, 2018. Retaining data in the same VM requires us to increase the disk space when the utilization of allocated space is full. Increasing the disk space in Azure is quite easy with a few clicks.
  • Creating An Azure Database For PostgreSQL ServerFeb 11, 2018. In this article, I am going to demonstrate how to create a database in Azure for the PostgreSQL server in the Azure Portal.
  • Creating And Configuring A MySQL Server On The Azure PortalFeb 10, 2018. This article demonstrates how to create a MySQL database on the Azure Portal.
  • Database Naming Standards For The ProgrammerFeb 09, 2018. Let us face it, in most companies that programmers work for, we end up doing database work. I do not agree with this since I think the DBA or BIA should handle database programming and we should stick to what we do best… coding. Would you want a DBA writing code? I think not. With that said, here are database naming standards that I use when in this situation. DBA’s might not agree with how database coders name databases; stored procedures etc. but we need something.
  • Introduction To LINQ With Entity Framework In Visual StudioFeb 08, 2018. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
  • How To Get Started With Always Encrypted For Beginners - Part OneFeb 08, 2018. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.
  • Synchronous VS Asynchronous Statistics UpdatesFeb 07, 2018. Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
  • Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
  • SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part TwoJan 30, 2018. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creation). But I decided to put it in a SharePoint list because my css selectors are grouped and I could not reference them using "styles.selector".
  • SharePoint Online Automation - Increase SharePoint Storage Quota In SharePoint Online Using PowerShellJan 24, 2018. As we know when a site collection is created in SharePoint online, we must specify a storage quota. This site size value must be between 100 MB and 100 GB. We will discuss more about site collection quota and usage in the next article.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.
  • Converting SQLite Database To Excel And Excel To SQLite Data In AndroidJan 23, 2018. In this article, we will learn how to export Android SQLite Database to Excel or Import Excel into SQLite Database. We can use SQLiteToExcel library to perform these functionalities.
  • Deploying Multiple ASP.NET Core Apps To Docker And AzureJan 22, 2018. API - has controller with CRUD operations for a movies database. It uses a class library Data, which contains repositories. Database is hosted in Azure and connection string stored in application settings (appsettings.json).
  • SharePoint Online/2016/2013 - How To Upload Large Files Using PowerShell AutomationJan 22, 2018. Uploading large files to SharePoint On-Premise or Online is an obvious problem during data migration from any external system like Lotus Notes.In this article I will explain a data upload strategy where we can split a large file into multiple chunks of smaller size.
  • Database First In .Net Core 2.0 CRUD Operation - Part OneJan 17, 2018. In my previous post, I have explained how to create an Angular 5 application in Visual Studio 2017 using .NET Core templates which you can find here.
  • 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.
  • Angular 5 CRUD Operation Using Node, Express, MongoDBJan 13, 2018. In this article, we’ll learn to create basic CRUD application using angular 5, Nodejs, Express and Mongodb nosql database.
  • Bind Menu And Sub Menu Dynamically In ASP.NET MVC From Database Using LINQJan 12, 2018. Many times we need to create a menu for a simple application. We ususally get stuck on how to bind the menu. Here in this article we you will learn how to bind menu and sub menu dynamically in ASP.NET MVC from database using linq.
  • 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.
  • 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".
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Using jTable Grid With ASP.NET MVCJan 03, 2018. In this article, we are going to learn how to use jTable Grid with ASP.NET MVC, and along with that we are going to use Entity framework for accessing the database.
  • 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.
  • How To Display Analog Clock Using BoxView In Xamarin.FormsDec 29, 2017. Although Xamarin.Forms doesn't have a vector graphics programming interface, it does have a BoxView. Although normally used for displaying rectangular blocks of color, BoxView can be sized, positioned, and rotated. This is enough to render a classic analog clock.
  • Creating A CRUD With ASP.NET Core And EF CoreDec 28, 2017. Entity Framework Core (EF) is an ORM that makes it simpler to work with database by using POCO classes that map to database entities and DbContext to interact with them.
  • 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.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • 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.
  • 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.
  • Xamarin.Android - Working With Firebase Database - Part TwoDec 20, 2017. Today, we are going to learn how to save and retrieve data from Firebase in Android.
  • Using Gijgo Grid With ASP.NET MVCDec 20, 2017. In this article, we are going to learn how to use Gijgo Grid with ASP.NET MVC along with that we are going to use Entity framework for accessing the database.
  • 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
  • Xamarin.Android - Working With Firebase Database - Part OneDec 19, 2017. Today, we are going to learn how to save and retrieve the data from Firebase in Android.
  • 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.
  • 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.
  • Xamarin.Android - SQLite DatabaseDec 17, 2017. In this article, I shall show you how to handle all database CRUD operations using SQLite.
  • Xamarin Android - Working with Existing DBDec 16, 2017. In this article, I shall show you how to retrieve user data from existing SQLite Database.
  • Introducing Hadoop /Big Data For BeginnersDec 14, 2017. Companies like Facebook ,NASA, and Google have huge amount of data (can be hundreds of petabytes or exabytes). Each and every like, click, comment, review, update, search, call, visit, piece of financial and health information, transaction, photo upload etc., which is a very huge data set, gets stored somewhere(database).This data is called Big Data.
  • 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.
  • Starting With Google Cloud Firestore Database With AngularDec 12, 2017. Cloud Firestore is a NoSql Document database built for automatic scaling, high performance, real time, and ease of application development.
  • Getting Started With CosmosDBDec 12, 2017. DocumentDB is a NoSQL database which is massively scalable and it works with schema free JSON documents.
  • 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).
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Introduction To Firebase Cloud Messaging (FCM)Dec 08, 2017. Firebase Cloud Messaging is a powerful API that lets you deliver messages reliably and independent of the platform you are developing on. With the help of FCM you can send notifications and messages to your client’s app. We can send instant messages of up to 4KB in size.
  • 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.
  • 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.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • Building An ASP.NET Core Application With Web API And Code First DevelopmentDec 05, 2017. In the previous article, we’ve learned the high-level overview of what Entity Framework is all about and learned how to build a web application quickly using Entity Framework’s Database-First development.
  • Xamarin.Forms - Text AppDec 04, 2017. In this article, we are discuss about how to display text in different styles and font sizes in Xamarin.Forms using Visuaal Studio 2017
  • 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.
  • View Product Details Using Kendo ScrollView In ASP.NET MVC5 With Entity FrameworkNov 29, 2017. Here, I will demonstrate how to work with Kendo ScrollView to View the product details from a database using Entity Framework in ASP.Net MVC5
  • 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.
  • Configuring Log4Net With Database - A Tutorial For BeginnersNov 26, 2017. Log4Net is a framework for logging .NET applications. It is an open source library that can be used to log output for different targets like logging output in Text files, Database, Console, Mail (SMTP), Remote and others. In this article, I will explain how to log output in a database.
  • 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.
  • Agile Story Point Estimation Techniques - T-Shirt SizingNov 24, 2017. In this article, we will learn Story Point Estimation using T-Shirt Sizing Technique. In my previous articles, we have discussed Agile Story Point Estimation and Agile Story Point Estimation Techniques - Planning Poker In this article, we will learn Story Point Estimation using T-Shirt Size Technique.
  • 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.
  • Connecting R Software With Oracle DBNov 24, 2017. This article is about how to connect the R software with Oracle database so that the data can be brought inside R environment for analysis
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Xamarin.Android - Working With MongoDBNov 21, 2017. Today, I will show you how to create MongoDB and how to use MongoDB using Xamarin.Android.
  • Implement DropDown MultiSelect Using Kendo UI MultiSelect In ASP.NET MVC5Nov 21, 2017. In this article, I am going to explain how to bind the value to a dropdown from the database, how to implement drop-down multi-select, how to group the drop-down values, and how to implement Custom Template using Kendo UI MultiSelect in ASP.Net MVC5.
  • Migrate From TFS To VSTSNov 21, 2017. Migrate from TFS to Team Services with the TFS Database Import Service.
  • 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.
  • Uploading, Validating, And Storing A File Into Database Using EF In ASP.NET MVC5Nov 20, 2017. Here, you will learn how to upload a file, validate a file and store a file into database using JQuery, Entity Framework in ASP.NET MVC5
  • Set Paging Size In ASP.NET MVCNov 19, 2017. This article is an answer to common ASP.NET MVC searches
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • 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
  • Building A Questionnaire Site With Node.jsNov 14, 2017. This was our first project with Node.js, and by God, it was a pain. Node.js is an excellent framework, with blazing fast speed, and an intuitive development framework. For those who are familiar with HTML, CSS and JavaScript, Node.js is one of the best alternatives to PHP, ASP.NET or other server-side scripting languages that require a language to be learnt. Node.js is light-weight, resilient and community-led and in-development framework. This article is primarily focused on teaching the beginners in Node.js development. You can expect to learn a few basics of Node.js setup, how to manage the databases in Node.js environment and a bit more (less too, maybe).
  • 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.
  • 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.
  • Get Your Hands On Entity Framework Code First Workflow With New Database And Existing DatabaseNov 10, 2017. In this article we are going to learn how to create code first workflow with new database and existing database.
  • 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.
  • 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
  • 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.
  • If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used in the old Operating System. For more details check Windows startup process.
  • 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.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • 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.

About SQL-Database-Size

NA
Web Development Outsourcing
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.