Server Resources

Share

Related resources for Server

Step By Step Installation Of Active Directory On Windows Server 2019 Core8/15/2018 11:08:32 PM. I have recently started using windows server core version not only to save space it is also use very low memory to run my domain controllers.
Azure SignalR Messaging With .Net Core Console App Server And Client8/15/2018 9:00:14 AM. Real-time technologies are now part of every modern applications and SignalR is the most popular .net library to create real time scenarios. Recently Microsoft announced the public preview of Azure Si
Working With Joins In SQL8/14/2018 11:05:17 AM. In this post, we will discuss how to work with join's and explain the concepts with an example in simple way. I hope this is very useful for beginners and intermediate to help them understand the
Learn About SQL Server Architecture8/14/2018 10:47:38 AM. This is my very first article on the understanding SQL Server Architecture. I tried to make this as simple as possible. I just want to share what I learnt. If there is any error or wrong information p
SQL Server 2008 R2 SP3 Install Errors8/14/2018 12:47:55 AM. Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would surmise that, in most cases, installing the service pack is a non-event. No flashing lights,
Making Custom Function Deterministic With SCHEMABINDING And Its Impact On DB Objects8/13/2018 11:44:43 PM. In this video, we will learn to make custom functions or User-Defined Functions in SQL Server Deterministic by using the "SCHEMABINDING" keyword.
Amazon Aurora Serverless Made Generally Available By AWS8/13/2018 11:28:14 AM. Amazon Aurora Serverless is now generally available.
Single Page Application Using Server-Side Blazor8/13/2018 9:14:44 AM. We will create a Single Page Application (SPA) using the Server-Side Blazor with the help of Entity Framework Core database first approach.
Microsoft Announces Team Foundation Server 2018 Update 3 RC8/13/2018 1:36:38 AM. Recently, Microsoft has announced the release candidate of the Team Foundation Server 2018 update 3.
How To Securely Delete Files From Your Servers8/10/2018 9:38:07 AM. If data isn’t securely deleted from your servers, it can be recovered by anyone who has access to the drive. We look at why ordinary deletion isn’t good enough, and two techniques for making sure that
How To Use Images Stored In SQL Server Table With Images And Varbinary Datatype In Power BI8/10/2018 9:02:22 AM. In this article, we will learn how you can use blob image data from your SQL Server and Load it into Power BI.
Server Load Balancer In Networking Services Of Alibaba Cloud8/10/2018 1:55:04 AM. In this article, we will understand the Server Load Balancer of Networking Services on Alibaba Cloud.
Windows Admin Center Setup And Configuration For Server And System Management8/9/2018 9:59:11 AM. Windows Admin Center allows Server admin or Infrastructure admin to manage all server Infrastructure using browser-based management tool. This tool will give admin full control over all infrastructure
Step By Step Installation Of Windows Server 2019 Standard8/9/2018 8:53:54 AM. Windows Server 2019 Preview Build 17692 Available for IT personnel to explore. Today we will install Windows Server 2019 Standard on Hyper-V. As Microsoft has only issued this for insider preview only
Zero To Hero In MS SQL Server - Part Four8/8/2018 12:19:16 PM. In this article, I have shared some concepts about Dropping, Deleting and Truncating tables in SQL Server.
SQL Server And Relational Database - Part Two8/7/2018 9:03:13 AM. The server name is important because it is the server where you’re developing the database. If you’re working locally then by default here you’ll see your server name which is installed in your machin
Indexes In SQL Server8/6/2018 2:54:57 PM. One of the most important routes to high performance in SQL server database is an index.
Clauses In SQL Server8/6/2018 1:47:37 PM. We add Clauses in Query to provide the additional facilities like filtering the records, storing the records, fetching the records and grouping the records in the Table.
Installation Method Of SQL Server Management Studio 20178/6/2018 1:41:37 PM. This article explains how to install SQL Server Management Studio 2017 in step by step way.
Step-By-Step Solution To Set Up Angular With Your Visual Studio 20178/3/2018 3:03:09 PM. Simple Project For Beginner T understand how to bind dropdown using client side(Angular 2),, Middleware(C# using web api)and Backend(SQL_Server)
Step By Step Installation Of SharePoint Server 2019 Preview For Single Server Farm Topology8/3/2018 3:00:29 PM. As we know that SharePoint Server 2019 and Project Server 2019 preview available, I was excited with this news and thought to have it installed on and check what’s now.
Zero To Hero In MS SQL Server - Part Three8/3/2018 1:59:40 PM. In this article, I have shared knowledge in Schema and Tables in MS SQL Server.
Creating a Computed Column in SQL Server8/2/2018 11:48:10 PM. Learn to create a Computed Column in SQL Server through Management Studio GUI without writing T-SQL.
Generating SELECT (JOIN) Query Through Criteria Pane, SQL Pane, and Diagram Pane8/2/2018 11:43:29 PM. In this training video, we will learn how to generate SELECT (INNER JOIN) Query through Criteria pane, SQL Pane, and Diagram Pane. We will not write query ourselves; instead, we will use SSMS GUI to g
Implementation Of SQL Server Data Tools (SSDT)7/31/2018 1:06:10 PM. There are many problems which we face while using SQL Server. Its very important to design your database correctly and keep it working.
Understanding Server-Side Blazor7/31/2018 9:15:37 AM. We will explore server-side Blazor which is introduced with Blazor 0.5.0 release.
SQL Server And Relational Database - Part One7/31/2018 5:02:19 AM. In this article, we will discuss SQL Server And Relational Database.
SSAS - Automating SQL Server Agent Service Logon As Administrator7/30/2018 3:25:14 PM. Recently we ran into an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Anal
Using UNION With Different Tables, Fields And Filtering7/30/2018 2:44:28 PM. All fields must be at the same position and the same data type, you can make all kind of selects, joins, where etc the UNION ALL comand is best then UNION if you want select all rows if they are the s
Zero To Hero In MS SQL Server - Part Two7/30/2018 2:41:23 PM. In this article, I have shared knowledge about Database and schema and table creation in SQL. This is a continuation of Part One
How To Import JSON Data In SQL Server Using MVC 57/30/2018 1:25:22 AM. In this article, I will demonstrate how to import JSON data into SQL server using MVC 5 and Entity Framework. I will create a JSON file and upload it into FileUpload in the project.
How To Import XML Data In SQL Server Using MVC 57/27/2018 10:00:28 AM. In this article. I will demonstrate how to import XML data into SQL server using MVC 5 and entity framework. I will create a XML file and upload it into FileUpload in project. I will also use jQuery d
SQL Server - Various Methods To Generate Number Sequence7/27/2018 9:56:47 AM. Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number sequence. But there also other ways to accomplish the same thing without using ranking f
Getting Start With Data Analysis Using SSAS Tabular Modeling In Excel - Part Two7/27/2018 9:36:37 AM. In this article, we are going to see how business users or we can utilize the tabular model for data analysis and visualization in Excel.
How To Replace Newline Character From The SQL Server Field7/26/2018 9:40:09 AM. In this post, we will learn about how to replace newline characters from SQL fields. In this post, we have to use replace function for replace string and also use char function to remove newline chara
Getting Started With Data Analysis Using SSAS Tabular Modeling In Excel - Part One7/26/2018 9:24:49 AM. As we all know that SQL Server analysis service (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business repo
How To Make SQL Server Search Faster - Part Two7/25/2018 4:07:48 PM. In this article, we will discuss how to make faster SQL Server Search - Part Two.
How To Install, Configure And Unconfigure Build Agent In TFS 20157/25/2018 2:49:40 PM. In this article, I’ll explain how to configure the agent as a service. To run a build or release definition we need at least one agent. So let’s start.
Synonyms In SQL Server7/24/2018 11:36:50 AM. Synonyms is database object which can be created as an alias name/duplicate name for any object like table views ,procedure etc.
Resolving: "Failed To Deploy The Project. Try again later. Microsoft SQL Server, Error: 27118" In SSIS Deployment7/24/2018 11:34:53 AM. In this post, we will be stepping through details of how we can troubleshoot the infamous error while we face during the SSIS deployment.
Stuff Function In SQL Server7/24/2018 3:02:47 AM. Stuff is a function in SQL Server used to perform special operations on a string value.
To Overcome "The Given Key Was Not Present In The Dictionary" Exception In MySQL7/23/2018 1:52:08 PM. In this article, I will give one of the solution to overcome “The given key was not present in the dictionary” exception in MySQL.
Observer Pattern - Implementation In .Net Framework7/23/2018 1:05:24 PM. This article describes the Observer pattern and the interfaces .Net Framework provides.
SQL Server - Rollback Transaction Completely In Case Of Error7/23/2018 1:03:50 PM. Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback if we use multiple insert statement in transaction.
Zero To Hero In MS SQL Server - Part One7/23/2018 11:13:58 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
FOR JSON Clause With AUTO Mode In SQL Server 20167/19/2018 10:21:09 AM. JSON stands for JavaScript Object Notation. JSON is a lightweight format which is used for storing and interchange the data. JSON uses standard javascript function to convert JSON data into native jav
How To Make Faster SQL Server Search - Part One7/19/2018 10:12:21 AM. Do a small change on database and on your query to make it faster.
ASP.NET Core - Expense Manager Using EF Core And Highcharts7/18/2018 12:10:45 PM. We will create a personal expense manager using Asp.NET Core 2.1 and Entity Framework core Code first approach with the help of Highcharts to show the expense summary chart and a modal dialog to handl
SQL Server Database Connection To MVC Application7/17/2018 9:57:11 AM. This article demonstrates how to establish SQL Server database connection to MVC 5 application using Entity Framework. It is beneficial for beginners and for students as well. This article is focused
Migrate SQL Server Database To Azure SQL Server7/15/2018 10:38:06 PM. I will also try to share my experiences. When I was moving from SQL Server to SQL Azure for the first time. My first article of this SQL Server database to Azure SQL Server Import and Export Wizard is
New Version of dotNetTips.Utility Dev App Released7/15/2018 7:26:31 PM. New Version of dotNetTips.Utility Dev App Released today!
Using Window Ranking Function With UPDATE Statement7/13/2018 10:31:44 AM. In this article, we will learn using Window Ranking Function With UPDATE Statement.
Drop Indexes In Views In SQL Server7/12/2018 12:10:10 PM. In this article, I am going to tell about dropping of indexes in view in SQL Server.
File Growth Rate: The GUI Lies7/12/2018 10:10:58 AM. If you are like me, you use the SSMS GUI for various things. Though I tend to use scripts for the management of most things, I do check on the database growth rates of files using the GUI interface.
Auto Query Generator In MSSQL Server7/10/2018 9:31:34 AM. If you’re a developer, irrespective of the platform, you would have to work with Databases. Creating SQL statements for tables is quite often a monotonous job and it gets hectic especially with dealin
Contained Database - No Need For Server Level Logins Anymore7/6/2018 9:23:06 AM. Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained database is a database that is completely un-reliant on the instance of SQL
Trick To Use Dark Theme In SQL Server Management Studio 20177/3/2018 5:31:08 PM. SQL Server Management Studio (SSMS) has been the favourite tool among SQL Server users as it comes as an integrated tool for managing SQL Infrastructure as well day to day tasks like deploy, monitor,
Is Server Side Code Dying Out In SharePoint7/3/2018 3:44:23 PM. SharePoint Online is a Software as a Service (SaaS) offering from Microsoft which is part of Office 365 suite. In the SaaS model, we only consume the service provided by the service provider that we n
Multiple SQL Operation In Single Procedure7/2/2018 9:32:47 AM. In Single Procedure, we will write multiple SQL operations. Based on the request the corresponding SQL operations will execute.
Finding Composite Primary Key Columns7/2/2018 9:27:58 AM. I had to work with composite primary keys recently while working on a project for a client. More specifically, I had to create a process that would dynamically (dynamic SQL?! Say it isn’t so?!) handl
Server Side Pagination And Searching With DataTable And ASP.NET MVC6/21/2018 3:46:47 PM. Integrating DataTable with asp.net MVC website and performing server side searching and Paging with it.
Learn Oracle PL/SQL - Create & Use View6/21/2018 1:00:55 PM. Do you know the type of views ,how to create them and their uses. In this blog I will tell you about views , how you can use them practically. Before that I want to tell you that this is my third blog
Introduction To SharePoint Server 2019 - A Modern Platform For Choice And Flexibility6/21/2018 11:34:43 AM. Introduction to SharePoint Server 2019 - a modern platform for choice and flexibility
Replication Of Max Text Length6/21/2018 10:37:23 AM. Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce it to those that had not.
Difference Between ROW_NUMBER, RANK, and DENSE_RANK In SQL Server6/20/2018 1:18:35 PM. Ranking functions returns a ranking value for each row either in a partition, or not. We can produce the very same result for all functions, but they have different purpose.
How To Validate File Uploader Server Side In ASP.NET6/20/2018 1:10:17 PM. In this blog I will demonstrate how to validate file upload server side in asp.net.
SQL Server 2016 Install - Issues "Oracle JRE 7 Update 51 (64-Bit) Or Higher Is Required For Polybase" Failed6/19/2018 11:11:50 AM. When Install the SQL Server 2016 got "Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase" Failed
Load Database Records To Another Table And Excel Sheet Using SSIS6/18/2018 4:09:27 PM. In this session, we will briefly discuss how to load data from one table to another table and Excel sheets at the same time using SSIS package.
Install SSL Certificate (.pfx File)To IIS On Windows Server Machine6/16/2018 10:57:07 PM. In this article, we will install SSL certificate to IIS on windows server with .pfx file.
How To Get Started With Always Encrypted For Beginners - Change Is Coming - Part Four6/14/2018 4:51:26 PM. A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part 4, I am going to talk about the changes that are coming in vNext of SQL Server.
How To Dynamically Bind ASP.NET Server Control From Database6/14/2018 4:43:04 PM. In this article, I will demonstrate how to dynamically bind ASP.NET server control from the database. I will bind DropdowList, RadioButtonList, CheckBoxList, ListBox, and BulletedList.
Create An HTTPS Server And Run Application HTTPS In Node.js6/13/2018 9:50:39 AM. In this article we will learn to create https self signed certificate and create node js application in HTTPS server
Attaching Installed SSL Certificate To Website Hosted On IIS On Windows Server6/13/2018 6:54:55 AM. We have an SSL certificate which was already installed on IIS. In this article, we are going to attach that SSL certificate to the website on IIS.
Transfer Database From SQL Server 2008 To 20146/7/2018 12:50:23 AM. Transfer database from SQL Server 2008 to 2014 using different migration techniques with the help of this article.
How To Get All Row Count For All Tables In SQL Server Database6/7/2018 12:47:25 AM. In this post, we will learn about how to get all tables records count from the selected database. Here we are using sys.objects and sys.partitions for getting the record count. Here we are using join
Enable IIS, Web Deploy & Web Platform6/4/2018 12:14:03 AM. This video is about the installation of Web Deploy & Web Platform tools on IIS Server.
Windows Server 2019 Insider Preview Build 17677 Announced5/30/2018 2:19:32 AM. Recently, Microsoft has announced the Windows Server vNext Long-Term Servicing Channel.
Deploying Docker Swarm On NGINX Web Server5/29/2018 3:45:04 PM. This HOL will guide you in deploying Docker Swarm along and hosting NGINX web server. Followed by the same, load balancing and scaling the number of instances will be shown.
Azure Machine Learning Client And Server Applications5/29/2018 11:43:04 AM. In this post, I will work on Machine learning predictive models and how to explore the types of client and server application that you can use create to consume Azure Machine Learning web service.
How To Import Excel Data Into SQL Server Using Angular In MVC 55/29/2018 10:19:39 AM. In this article, I will demonstrate how to import Excel data into SQL Server using AngularJS in MVC5. I will use jQuery AJAX to retrieve the data from database and also use jQuery datatable for sortin
Simultaneous Data Queue Polling Request Processing In SQL Server5/24/2018 4:02:11 PM. This article explains how to implement simultaneous data queue processing using SQL Server. In many of our enterprise applications, we have the design to handle incoming request coming from multiple
Microsoft Announces SharePoint Server 20195/24/2018 3:35:59 PM. Recently, Microsoft has announced SharePoint Server 2019.
Tips And Best Practices To Improve ASP.NET Web Application Performance5/24/2018 3:42:02 AM. This article suggests you a few tips to improve the performance of an ASP.Net application. There are many more things which may ensure a better performance and faster response time for a web applicati
Transfer And Manage Files On LAMP Server Using FileZilla5/20/2018 3:32:49 PM. In this article we will see how to upload our files to a LAMP Server using FileZilla. FileZilla is a cross-platform FTP, SFTP, and FTPS client with a vast list of features, which supports Windows, Mac
Configuring A LAMP Server On A Linux VM In Azure5/20/2018 3:25:32 PM. This article walks you through how to deploy the LAMP stack on an Ubuntu VM in Azure
ASP.NET Core - CRUD Using Angular 5 And Entity Framework Core5/18/2018 1:34:54 AM. CRUD Operations in ASP.NET Core application using Angular 5 , Web API and Entity Framework Core DB first approach with the help of VS 2017.
How To Create CLR Triggers In C# And Install And Uninstall CLR Assembly In MSSQL Server5/16/2018 12:52:28 AM. In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.
Installing Office Online Server - Part One5/14/2018 1:39:14 PM. Office Online Server is the new version of Office Web Apps with a lot of new features which you see in Office Online part of Office 365 subscription. It is compatible with SharePoint 2013 and SharePoi
How To Build Personal Web API Server Using Raspberry PI And Node.js5/14/2018 11:43:53 AM. This articles explains how to build a Personal Web Server in your local network using Raspberry PI and NodeJS
SQL Server Tips - SQL Server Paging Made Easy With OFFSET And FETCH Keyword5/14/2018 10:44:53 AM. This post contains SQL Server tips for applying paging in SQL that can be used in real-world applications for long-running processing with better performance
Create CLR Stored Procedure With And Without Namespace In C# And Install And Uninstall CLR Assembly In MSSQL Server5/13/2018 5:17:50 AM. In this article, we will learn how to create a CLR Stored Procedure with & without namespace in C# and install & uninstall CLR assembly in MSSQL Server.
Create A Job In SQL Server5/8/2018 10:52:28 AM. In this session, we are going discuss how to create the SQL JOB, how to connect the Job with SSIS package and how to schedule the job on server.
Learn About SQL Server DB Statistics5/8/2018 9:46:37 AM. In any application persistence of data is required. Database plays a very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables to m
Load Data From Database To Text File Using SSIS Package5/8/2018 1:46:39 AM. Let’s discuss how to connect the database to SSIS package and how to load the table record(s) from database to notepad file. We can pull it into notepad, excel, csv or any other extension that you wan
Apply Custom Order In A Given Order Except Ascending And Descending In MSSQL Server5/4/2018 10:31:04 AM. In this article we will learn how to display records in custom given order except ascending & descending in MSSQL Server.
ASP.NET Core - Using Highcharts With Angular 55/3/2018 10:45:41 AM. We will create an online poll application using ASP.NET Core, Angular 5 and Entity Framework Core. The Poll results will be displayed as a column chart, created using Highcharts.
Five Ways To Examine Cardinality Metrics5/3/2018 9:00:10 AM. In SQL Server, the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics to
Row_Number() function in Microsoft SQL server | How to use Row_Number in SQL server5/2/2018 2:33:36 AM. Row_Number is used to generate the number of each row dynamically in a sequential order based on some column orders.
How To Find The Highest Number Of Employees In a Department Using SQL Server5/1/2018 9:45:01 AM. In this blog, I will demonstrate how to find the highest number of employees in a particular department using SQL server 2014.
Money Precision Issues5/1/2018 9:42:48 AM. This blog shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

C# Corner

Topics