C# Corner

Resources  
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • 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.
  • 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.
  • 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.
  • Using Collection In KotlinJan 02, 2018. Collections are used to store groups of related Objects in memory. Like java, kotlin also supports collection frameworks.
  • Consuming ASP.NET Core 2.0 Web API Using HttpClientDec 26, 2017. We’ll create a library to wrap the functionality of HttpClient. I’ll use builder pattern for this purpose. Add a class with methods for storing parts of HttpClient.
  • Linking Android-Kotlin Application With Google Play Store For RatingDec 26, 2017. In this article, I am going to illustrate how a developer can link their app with Google Play store so that a user can navigate to the play store to rate applications by clicking on a particular button or image.
  • Read And Write Operation In HDFSDec 26, 2017. HDFS is hadoop distributed file system; in simple terms a file is stored in a distributed machines. The Hadoop framework was designed considering reliability, throughput, network I/O, and disk I/O; but compromised with latency, which is best in RDBMS.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • MVC Angular CRUD Operation Using WEB API 2 With Stored ProcedureDec 18, 2017. In this article, I am going to explain how to do CRUD Operation in Asp.Net MVC AngularJS Using WEB API 2 With Stored Procedure.
  • 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.
  • 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.
  • 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.
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • 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.
  • How To Save Multiple Links In A List Column And UI On Custom List Form In Visual Web PartDec 06, 2017. In this article, we will discuss how we are storing multiple links in the list field and supporting the UI on custom list form in Visual web part
  • Step By Step Procedure To Create An Azure Logic AppDec 06, 2017. The article is on the detailed procedure of building an Azure Logic App. These steps are described with photos.
  • How To Use Indexed DB To Improve Page Load PerformanceDec 05, 2017. Indexed DB is a local storage system, which will store data in client-side on browser. This is useful for applications that require us to store large amounts of data. These applications can run more efficiency and load faster.
  • 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.
  • Difference Between MySQL DATETIME And TIMESTAMP DataTypesNov 29, 2017. A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let's check those things out with the help of a small example.
  • Introduction To ngrx In AngularNov 27, 2017. In Angular, ngrx is built on the concept of Redux, a state management container. In ngrx, this state management is achieved by a store.
  • 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.
  • 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.
  • 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.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • 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
  • 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.
  • 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.
  • Simplest WPF Dependency Property For Beginners On Background ColorNov 19, 2017. Dependency property is not wrapped over any private members unlike CLR properties, and it is also stored in Key-Value pairs inside the DependencyObject host instance. You must use Dependency properties if you need to create and apply properties on custom usercontrols, or change properties based on external inputs like Theme, Style, animation etc, or while applying data binding or set with a resource (static/dynamic) .
  • 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
  • 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.
  • 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.
  • ASP.NET Core 2.0 MVC Distributed Cache Tag HelperNov 09, 2017. Cache and Distributed Cache Tag Helper help improve performance of your application by caching view’s content, either in-memory or in a distributed cache (e.g. Redis). Distributed Cache Tag Helper uses IDistributedCache to store contents in a distributed cache. To learn more about distributed caching, please refer to an earlier post here.
  • Create A Flash Light App In Xamarin.Android Using Visual StudioNov 08, 2017. Here it goes, My friend receive Samsung mobile phone few month ago. She like it in particular, yet one thing that it doesn't accompany is the toolbox for fundamental utilities. One of them is the spotlight application that triggers the gadget to enact or deactivate the electric lamp as required. Android supports you to have Camera API devoured in your application (all things considered, electric lamp is given to photographs or recordings and not as a floodlight). Anyway, I was believing that I ought to get an application from Play Store, correct? No! Despite the fact that it would give me an "exquisite" answer for my spotlight issue, yet shouldn't something be said about the armed force of ad I should experience, or the hazy UI of the application. So I figured I should manufacture an application for herself to have the capacity to trigger the spotlight on or off.
  • 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.
  • 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.
  • 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.
  • 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
  • ASP.NET Core 2.0 Session StateOct 09, 2017. Using an empty project from a previous post, amend Startup class ConfigureServicee() method, and add services for session and its backing store.
  • 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.
  • 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.
  • 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 Secure PII Data In SQL Server Using CLE (Column Level Encryption)Oct 03, 2017. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • TextBox Validation Client Side And Server Side In ASP.NET WebFormOct 03, 2017. Validation is main thing to process the data. We store the textbox value into database table. Before moving to storing and storing data into database first we check the value of each textbox.
  • WebGrid Custom Paging Links To Avoid Load On Server Using Stored Procedure And ASP.NET MVCSep 27, 2017. I will show you how to fetch the data dynamically from the database and bind to the WebGrid control, using the stored procedure in MVC 4.0. In this blog, today, I will show you how to write code in ASP.NET MVC for implementation of WebGrid Control using Static Data. In later sessions, I will show you the process of using GridView Dynamically, that means using SQL Server data source.
  • Stored Procedure With Input And Output Parameter Using Entity Framework In ASP.NET MVCSep 23, 2017. In this article, we are going to learn how to get list and output value from a stored procedure using Entity Framework in ASP.NET MVC.
  • 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
  • Store Images In App Directory In Xamarin iOSSep 21, 2017. In this article, you will learn how to store images in the App Directory in Xamarin iOS, using Xamarin Studio.
  • 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.
  • Store Photo In Backend Using Entity Framework In MVC Razor And BootstrapSep 21, 2017. Here i will show you image details will be shown along with user name. This one a sample exmaple of student management system In mvc and bootstrap.
  • 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.
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.
  • Create Log Backup Maintenance Plan In SQL Server 2016Sep 17, 2017. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
  • Convert Rows To Columns Using Dynamic Pivot In SQL ServerSep 17, 2017. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
  • Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
  • 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.
  • Step By Step Procedure To Create A Microsoft FlowSep 14, 2017. Microsoft Flow is a part of Office 365 suite which is a cloud-based software tool that allows users to create an automated workflow across multiple applications and services without the need for developer help. Microsoft flows is built on top logic app engine. But as this app is built for targeting business personnel, the total process is UI based. To create a flow, the user specifies what action should take place when a specific event occurs.
  • 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.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • 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.
  • 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 Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
  • 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”.
  • 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.
  • 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.

About SQL-Stored-Procedure

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!