Server Resources

Share

Related resources for Server

How To Back Up SQL Server In Azure9/16/2019 9:11:54 AM. In this article, we are going to learn how to backup SQL Database in Azure.
Using star to call all setter methods of Java Bean9/13/2019 2:28:59 AM. In this article we will learn how to use asterisk (*) to call all setter methods of a java bean. Before going forward we should know what a java bean is.
Top 50 SQL Server Interview Questions9/12/2019 10:11:10 PM. This tutorial lists top 50 SQL Server Interview questions and answers asked in SQL Server interviews. SQL Server Q&A for freshers and experienced SQL developers.
Quick SSMS Tip9/12/2019 8:29:28 AM. In this article, you will learn a Quick SSMS Tip.
Understand WCF: Part 2: Understand RESTful Service9/11/2019 3:19:25 AM. This article will clarify a few more concepts related to services and protocols.
Insert, Update and Delete Data in GridView Using WCF Service9/10/2019 2:11:11 AM. Today, I have provided an article showing you how to insert, delete and update data in a GridView using a WCF service from C# code.
MSMQ In WCF9/10/2019 1:18:32 AM. In this article we try to learn how to implement a MSMQ feature in WCF service.
WCF Service to Connect Between Windows Forms Application and SQL Database9/9/2019 12:44:35 AM. Today, I have provided an article showing you how to insert and display data in a DataGridView control using a WCF service from C# code.
Primefaces5, Spring4, Hibernate4, CRUD Using Netbeans 8.02 And MySQL5 Database Server9/9/2019 12:03:18 AM. In this article, you will learn about Primefaces5, Spring4, Hibernate4, CRUD using Netbeans 8.02 and MySQL5 Database Server.
Top 5 Tricky/Important SQL Queries And Their Answers9/5/2019 8:05:56 PM. In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.
What SQL Server Performance And Management Tools Do I Use9/5/2019 9:51:51 AM. In this article, you will learn about SQL Server Performance and Management Tools I use.
ASP.NET Core Identity | How To Add Custom Columns In dbo.AspNetUsers Using Entity Framework Core9/5/2019 1:17:41 AM. This video shows how to create Identity tables in a database with custom columns in the dbo.AspNetUsers table.
Encrypt an Azure Virtual Machine VHD File in 5 Minutes9/4/2019 1:09:09 AM. In this video, I will show how you can encrypt an Azure VM (VHD) file manually.
Backup and Restore an Azure SQL Database9/4/2019 1:01:52 AM. In this video, we will discuss how to take manually DB Backup and restore into the Local server environment and how to change the backup retention period.
Some Simple And Important SQL Server Query Based Interview Questions9/1/2019 9:33:58 PM. In this article I explain some important SQL query qustions that are commonly asked when you go for an interview for a position requiring one to three years of experience in this field.
Grant and Revoke Command in SQL Server9/1/2019 11:19:33 AM. In this article, I will describe Grant and Revoke Commands in SQL Server.
Are My Indexes Being Used8/30/2019 12:39:44 AM. In this article you will learn about that are my indexes being used.
Connect SQL with Azure Machine Learning Studio8/29/2019 3:34:44 AM. This video talks about how to build a SQL database connection with Azure Machine Learning Studio.
Insert, Update and Delete Data With DataGridView in Windows Form Using WCF Service8/29/2019 2:28:15 AM. In this article, I am showing you how to Insert, Edit, Update and Delete Data with DataGridView in Windows Form Using WCF Service from C# code.
How To Deploy Node.js Web Application On Heroku Server8/28/2019 1:45:14 AM. You must install Node.js, Git (to commit our code in the git repository), Heroku command-line tools and web storm (it is optional. Here I used web storm for the terminal. You can use any shell termina
Indexes In SQL Server🔗8/27/2019 8:32:20 AM. In this article, I am going to explain the indexes available in the SQL Server and their advantages and drawbacks. I am covering the clustered and non-clustered index.
Use Of Table-Valued Parameter In SQL Server8/26/2019 10:06:19 PM. Learn what is a Table Valued Parameter in SQL Server and how to create and use table valued parameters in stored procedures and queries.
Creating and Using Stored Procedure in SQL Server8/22/2019 8:47:55 PM. This article explains how to create stored procedures and execute them in SQL Server.
Understanding Stored Procedure In SQL Server8/22/2019 9:07:31 AM. In this article, I am going to explain about the stored procedure in SQL Server and what the advantages of using the procedure are. I will explain how to create the procedure and how to execute it.
Learn to Deploy ASP.NET MVC Application on Windows IIS Server8/22/2019 7:56:45 AM. This video explains the process of the deployment of ASP.NET MVC Application on Windows IIS Server.
How To Get Data From On Premise SQL Server Database In PowerApps8/22/2019 2:26:31 AM. In this article, we will see how to fetch data from On-premise SQL Server database in PowerApps using FLOW.
Pivot And Unpivot In SQL Server8/21/2019 9:25:55 AM. In this article we will learn how to use the pivot and unpivot operators in SQL Server.
What Is SQL Common Table Expression (CTE)8/21/2019 9:22:28 AM. Common Table Expression in SQL Server offers a more readable form of the derived table, which can be declared once and referenced multiple times in a query.
Step By Step SSRS in 11 Hours : Hour 10 (Report deployment)8/21/2019 5:11:42 AM. In this article, you will learn about SSRS report deployment.
Step by Step SSRS in 11 Hours: Hour 88/21/2019 4:53:33 AM. In this article, we will create a style for SSRS report.
Step By Step SSRS in 11 Hours: Hour 78/21/2019 4:46:40 AM. This article shows how to create a sub-report in SQL Server Reporting Services (SSRS). SSRS is a part of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Serv
Step By Step SSRS in 11 Hours: Hour 68/21/2019 4:34:46 AM. In this article, we will create a drill-down report in SSRS.
Step By Step SSRS in 11 Hours: Hour 58/21/2019 3:10:10 AM. In this article, we will learn how to create a custom template inside the report.
Step By Step SSRS in 11 Hours: Hour 48/21/2019 3:05:38 AM. This article shows how to create a report that expects a parameter, in other words a parameterized report.
Step By Step SSRS in 11 Hours: Hour 38/21/2019 2:59:45 AM. In this article, we will see what is SQL Server Reporting Services (SSRS).
Step By Step SSRS in 11 Hours: Hour 18/21/2019 2:48:56 AM. In this article we will see what SQL Server Reporting Services (SSRS) is.
How To Convert DataTable To XML In C#8/20/2019 10:06:34 PM. In this article, I will discuss how to read data from a SQL Server into a DataTable and then export DataTable data into XML file in C#.
Functions In SQL Server8/20/2019 9:29:53 AM. This article explains how to create functions in SQL Server using the SQL function operator.
Calling a Function From a Stored Procedure in SQL Server 20128/20/2019 8:00:58 AM. In this article, we will see how to call a function from a stored procedure in SQL Server 2012.
Learn Everything About Stored Procedures In SQL Server8/20/2019 7:58:35 AM. This tutorial explains everything about SQL Server Stored Procedures including creating a stored procedure, updating a stored procedure, deleting a stored procedure, and executing a stored procedure i
Indexes in SQL Server8/20/2019 7:10:28 AM. A SQL Server Index is used on a database table for faster data access. In this article, learn what SQL Server Indexes are, why do we need them, and how to implement Indexes in SQL Server.
jQuery DataTables With ASP.NET Core Server Side Processing8/19/2019 7:14:43 AM. In this article we will try to look at jQuery DataTables with Asp.Net Core Server Side. The goal of this article is to make multiple column server-side sorting and searching along with pagination and
Encrypt and Decrypt in SQL Server: Part 58/19/2019 3:32:58 AM. In this article, we will create a symmetric key and encrypt and decrypt string using this key.
Encrypt and Decrypt in SQL Server: Part 48/19/2019 3:25:48 AM. In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.
Encrypt and Decrypt in SQL Server: Part 38/19/2019 3:13:05 AM. In this article, we will generate a certificate and using this certificate we will encrypt and decrypt the string.
Encrypt and Decrypt in SQL Server: Part 28/19/2019 3:04:45 AM. In this article, we will discuss Database Master Key. The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database.
Encrypt and Decrypt in SQL Server: Part 18/19/2019 2:54:48 AM. In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.
List of Most Common Regular Expressions and Their Uses8/18/2019 8:06:28 PM. This article lists common regular expressions and their uses in JavaScript and C#.
Export Tables and Stored Procedures in SQL Server8/18/2019 6:12:53 PM. This article shows how to export or import tables and procedures from one SQL Server database to another SQL Server database.
Copy Table Schema and Data From One Database to Another Database in SQL Server8/18/2019 5:35:43 PM. This article is all about how to copy SQL Server tables and their data from one database to another database.
Zero To Hero In MS SQL Server - Part One8/18/2019 5:06:05 AM. This is part one of Zero To Hero Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technic
Create and Schedule a Job in SQL Server8/15/2019 12:33:42 PM. In this article you will learn how to create a new job and schedule that job for execution in SQL Server 2008.
Jobs In SQL Server8/15/2019 11:26:28 AM. In this article we’ll going to learn about Jobs in SQL Server and we’ll also see how we can setup simple backup job.
Procedure to Create a New Job in SQL Server 20088/15/2019 11:19:00 AM. Learn how to create a new job task in SQL Server 2008.
CRUD Operations Using Web API And ReactJS8/15/2019 8:15:10 AM. In this article, you will learn how we can perform the CRUD operations using Web API and ReactJS.
Getting Started With gRPC Client And Server Using ASP.NET Core8/14/2019 8:44:40 AM. In this article you will learn about gRPC Client and Server using ASP.NET Core.
T-SQL For Beginners8/13/2019 7:04:01 AM. T-SQL (Transact-SQL) is a Microsoft extension to the SQL (Structured Query Language). T-SQL is central to using Microsoft SQL Server. In this course, you will learn the basics of this language in a fe
Create User Registration And Login Using Web API And ReactJS8/12/2019 10:28:03 AM. In this article, we will learn how we can create the registration and login pages using Web API and ReactJS.
How To Connect And Load Data From MS SQL Server To Microsoft Excel8/12/2019 8:51:02 AM. In this article, we will see how to connect and load data from MS SQL Server to Microsoft Excel.
Track Database Changes With Git Using Visual Studio8/9/2019 12:28:21 PM. In this video, you will learn how to track and manage your SQL Server database changes with Git using Visual Studio database project.
Constraints in SQL Server8/9/2019 12:10:37 AM. In this article, you will learn about SQL Server constraints with examples.
Understanding SQL Server Constraints8/8/2019 11:55:40 PM. In this article, I am going to explain SQL Server constraints such as Unique key constraint Primary key and foreign key and how to implement constraints in SQL Server.
Compare And Update SQL Server Database Project With Visual Studio8/8/2019 9:26:23 AM. In this article, you will learn how to create a SQL Server Database project using Visual Studio 2019 and how to compare and update the SQL Server Database Project from the remote SQL Server Database a
SQL Server 2017 Docker Container And Web API In .NET Core In Ubuntu 18.048/8/2019 8:55:15 AM. In this article, we will be looking at how to use SQL Server 2017 Docker image for Web API development on Ubuntu 18.04.
Execute A Stored Procedure Programmatically8/8/2019 12:11:36 AM. In this article, I will explain how to create a Stored procedure (SP) and execute an SP programmatically.
SQL Server Database Connection In C# Using ADO.NET8/8/2019 12:08:15 AM. ADO.NET provides classes to connect to databases in .NET using C#. This article describes how to create a connection in .NET and use SqlConnection in C#.
Exploring SqlConnection In ADO.NET8/7/2019 11:28:55 PM. In this article, you will learn SqlConnection class in ADO.NET and connection to a SQL Server using ADO.NET and C#.
How To Add A User And Log In To Azure Database8/6/2019 11:21:31 AM. In this video, we will discuss how to add a user into the Azure SQL Database and log in with that.
SQL Assessment API (Public Preview)8/6/2019 10:55:07 AM. Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.
MySQL To SQL Server Database Migration8/6/2019 10:40:08 AM. In this video, we will learn how to migrate a MySQL Database to SQL Database. This technique is useful while migrating data from a WordPress website to an ASP.NET Core web.
Life Cycle of Java Server Faces (JSF)8/5/2019 3:20:53 AM. In this article, I will explain the phases in the life cycle of the Java Server Faces (JSF) framework.
Jenkins Server Backup Using Command Line8/1/2019 8:08:06 AM. Jenkins is an open source automation server written in Java and it helps us to automate the software development process, with continuous integration and facilitating technical aspects of continuous d
Introduction To Socket Programming In Java8/1/2019 6:00:19 AM. In this article, we discuss socket programming in Java.
CRUD Operations In ReactJS With Axios Using Web API And SQL Server8/1/2019 12:21:15 AM. In this article, I'm going to perform CRUD operations in ReactJS with Axios using Web API with the help of an example. And the backend is a SQL Server database.
SQL Server Foreign Key Update And Delete (Cascading Referential Integrity)7/31/2019 9:15:54 AM. In this article, you will learn about SQL Server Foreign Key Delete (Cascading Referential Integrity).
ASP.NET MVC 5 - Deployment On Windows IIS Server7/31/2019 7:45:40 AM. This article is about deployment of any ASP.NET MVC5 application on Windows machine with IIS server installed.
Import Excel File In Angular 7 Using Web API And SQL Server7/31/2019 4:56:07 AM. In this article, I'm going to tell how to import an Excel file in an Angular 7 Web application using Web API.
Azure SQL Database IP Firewall Rules7/31/2019 2:00:31 AM. In this video, you will learn about the security features of Azure SQL Database. We will dive deep into Azure SQL Database IP Firewall rules.
Multithreaded Sockets (Multithreaded Server) and Working With URL Class7/30/2019 3:51:24 AM. In this article, we describe the basic need of creating a Multithreaded server and what is the URL class and its methods. We also give examples of Multithreaded server and URL classes method.
How To Install Jenkins Server On AWS EC2 Instance7/28/2019 12:21:37 PM. Jenkins is an open source Continuous Integration server which helps you to perform a chain of actions and thus helps you to achieve the Continuous Integration.
Comparison Of Different SQL Query Responses Of SQL Server On Windows And Ubuntu Linux7/26/2019 2:28:39 PM. The article consists of some benchmark tests of SQL Server on different Operating Systems, the parameters considered are CPU Time, Elapsed Time and Total Execution Time.
Search Records From SQL Server Using PowerApps Canvas App7/26/2019 12:10:16 AM. In this article, we will learn how we can search records from SQL Server database and display the data within the PowerApps Forms.
Hibernate and Primefaces CRUD Using NetBeans 8.02 and MySQL Database Server7/25/2019 9:53:44 AM. In this article, you will learn about Primefaces 5 and Hibernate 5 CRUD using NetBeans 8.02 and MySQL Database Server.
Temporary Tables In SQL Server7/24/2019 8:58:31 AM. In this article, you will learn about temporary tables in SQL Server.
Installing SQL Server And SQL Operation Studio On Windows And Ubuntu Linux7/24/2019 8:35:10 AM. The article shows how to install SQL Server and SQL Operation Studio on Windows and Ubuntu Linux.
Establishing Connection Between On-Premises Server To Azure VM Using Azure Site To Site VPN7/23/2019 8:44:58 AM. In this article, we will learn how to connect our On-premises server to Azure Virtual Server using Routing and Remote Access.
Inserting Image in Database Using Java7/23/2019 3:54:22 AM. This application inserts an image into a database (SQL Server using Java..
Azure SQL Database DTU Calculator7/22/2019 10:20:25 PM. DTU Calculator provides information about service tier, performance level, and DTU recommendation based on your current on-premise workload.
SQL Server Profiler And Tuning Tips7/22/2019 10:12:15 AM. In this article, let us see how we can identify slow running queries and how to improve SQL Server performance by using the Database Engine Tuning Advisor.
Azure SQL DB Failover Group Orphaned Users7/22/2019 9:21:52 AM. In this article, you will learn about Azure SQL DB Failover Group Orphaned Users.
Networking in JAVA7/22/2019 4:56:39 AM. In this article, we are exploring networking using TCP/IP protocols and try to make a small server and clients and show some information.
UDP Client Server Programing7/22/2019 1:36:02 AM. In this article we are going to describe the major differences between TCP and UDP protocols. We will also describe the difference in programming terms of which type of method is used in UDP client/se
Types of Commands in SQL Server7/19/2019 10:25:16 PM. This article explains various types of SQL Server commands, like DDL, DCL, DML, and TCL etc.
Inserting and Retrieving Images From Database Using Servlets and JSP7/19/2019 4:57:18 AM. In this article we are using Servlets and JSP to store and retrieve images from a database.
How To Install And Configure Apache Tomcat7 Server In Windows7/19/2019 1:39:16 AM. In this article, we discuss how to install and configure apache tomcat server and take a look upon Apache Tomcat Server.
Getting Started with Server-Side Blazor7/18/2019 10:38:08 PM. This video tells how to get started with Blazor server-side. Blazor is a feature of ASP.NET Core that allows you to build full-stack web applications using C# instead of JavaScript.
Understanding Columnstore Indexes In SQL Server - Part Three7/18/2019 10:47:00 AM. In this article, you will learn about columnstore indexes in SQL server.
Setting Up A MongoDB Server On Windows VM In Azure7/18/2019 9:26:08 AM. In this post, we will see how to setup a MongoDB server on Windows VM in Azure and connect from any other remote machine using public IP.
On vs Where Clause in SQL Server 20127/18/2019 6:29:30 AM. Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
Protect Your Data: Prevent SQL Injection7/18/2019 4:18:42 AM. SQL injection is a code injection technique, used to attack data-driven applications, in which nefarious SQL statements are inserted into an entry field for an execution. How to prevent SQL Injection

C# Corner

Topics