Server Resources

Share

Related resources for Server

Next.js Vs ReactJs12/20/2024 8:39:32 PM. Next.js and React.js are both powerful tools for building web applications. React.js is a JavaScript library focused on UI components, while Next.js is a framework that enhances React with features li
How to Launch Your First EC2 Instance12/20/2024 9:12:14 AM. Launching your first AWS EC2 instance introduces you to cloud computing. It involves choosing an AMI, selecting instance types, configuring security groups, and setting up key pairs. Use the AWS Free
Create FTP Task in SQL Server Integration Services 12/19/2024 11:18:54 AM. Learn how to create and configure an FTP Task in SQL Server Integration Services (SSIS). This task simplifies automated file transfers using the FTP protocol, making it essential for ETL processes.
How to Install Nginx on EC2 AWS12/18/2024 10:09:52 AM. Deploy Nginx on an AWS EC2 instance to serve as a powerful web server, reverse proxy, load balancer, and HTTP cache. This guide provides a step-by-step process for setting up Nginx on EC2, including i
Unlocking Faster INSERT Operations in SQL Server with TABLOCK12/17/2024 6:48:30 AM. In this article learn how using the TABLOCK hint in SQL Server can significantly speed up INSERT operations by reducing logging overhead and enabling parallel insertions.
SQL Server ACID Properties12/16/2024 8:24:34 AM. Understanding SQL Server ACID(Atomicity, Consistency, Isolation, Durability) Properties. This article explains ACID properties—Atomicity, Consistency, Isolation, and Durability—highlighting their impo
Azure AD B2C as an Identity Provider for Blazor Applications 12/16/2024 7:04:28 AM. From this article, you will learn how to integrate Azure AD B2C as an identity provider for a Blazor application. This article explains integrating Azure AD B2C with a Blazor server application, cover
Git GUI Clients (3-1), GitHub Server12/13/2024 5:45:19 PM. This article will briefly describe GitHub Server basic functionalities. This article is part of a series on Git GUI Clients. Focusing on GitHub Server, it delves into its major functionalities, guidin
Using SignalR for Real-Time Communication in Blazor Applications12/10/2024 9:10:45 AM. SignalR enables real-time communication in Blazor applications, providing instant updates and efficient data transfer. This article explores its integration in Blazor Server and WebAssembly, including
Automating Table Creation using SSIS12/10/2024 8:44:47 AM. In this article, we will see how to create a database table in SQL Server using the SSIS package. Learn how to create a database table in SQL Server using an SSIS package. Follow step-by-step instruct
Understanding Triggers in SQL Server12/9/2024 7:29:47 AM. SQL Server triggers are automated procedures executed on DML/DDL events. This guide explores trigger types, real-world examples, and implementations for logging, validation, and restriction in SQL Ser
Token Caching in .NET 8 with Microsoft Entra ID12/7/2024 3:22:18 AM. Learn how to optimize .NET 8 web apps with token caching using Microsoft Entra ID. Discover in-memory and distributed caching strategies to boost performance, reduce latency, and improve scalability i
Unit Test (2) --- TSQLT12/7/2024 2:51:50 AM. This article will discuss TSQLT Unit Test.
INSERT INTO and SELECT INTO: Which is Better?12/6/2024 5:50:06 AM. In this article, we’ll explore the differences between these two methods, their impact on temporary tables, and practical recommendations for SQL developers, data engineers, and DBAs. Using examples f
Deploying a Web Application Using NGINX on Alibaba Cloud12/6/2024 5:25:43 AM. Learn how to deploy a web application using NGINX on Alibaba Cloud with updated console steps, covering ECS setup, NGINX configuration, security, and optimization.
ASP.NET Core CRUD using Dapper, .NET 8 using SQL Server12/5/2024 7:18:42 AM. Learn to build a CRUD (Create, Retrieve, Update, Delete) application in ASP.NET Core MVC using .NET 8 and Dapper ORM. This guide covers creating models, repositories, controllers, and Razor views with
Integration of an LDAP server in servicenow12/1/2024 5:58:17 AM. In this article, we will learn how to enhance authentication, streamline user provisioning, and connect ServiceNow to directory services like Active Directory for seamless access control.
What is a CTE, and How Do You Write a CTE in SQL Server?11/29/2024 8:23:30 AM. A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into ma
How to Configure Azure Cloud Backup Service to Windows 1111/28/2024 9:39:46 AM. This article guides you through configuring Azure Cloud Backup Service on Windows 11. It covers the entire process from creating a resource in the Azure portal to setting up backup with the MARS agent
Learning SEQUENCE in SQL Server11/28/2024 6:02:51 AM. A SEQUENCE in SQL Server is a user-defined object that generates a sequence of numeric values in a specified order. Unlike identity columns, SEQUENCE objects are independent of tables, offering flexib
Explaining CTE in SQL Server11/27/2024 8:21:27 AM. Common Table Expressions (CTEs) in SQL simplify complex queries by creating temporary result sets. They can be used in SELECT, INSERT, UPDATE, and DELETE statements, supporting scenarios like hierarch
Renaming a Database in SQL Server11/27/2024 5:11:47 AM. Renaming a database in SQL Server is vital for tasks like aligning naming conventions, testing, or version control. It involves setting the database to single-user mode, ensuring no active connections
Rank Functions in SQL server11/26/2024 6:44:08 AM. In this article, we will learn about Rank functions in SQL Server, like RANK(), DENSE_RANK(), ROW_NUMBER(), and NTILE(), are used to assign rankings to rows within a result set.
JSON Data Handling in SQL Server11/26/2024 4:58:34 AM. SQL Server supports JSON for managing semi-structured data. You can store JSON in NVARCHAR(MAX) columns, parse it with JSON_VALUE, JSON_QUERY, and OPENJSON, and modify it using JSON_MODIFY.
Alibaba Cloud ECS: Features, Benefits, and Service Architecture11/25/2024 5:58:24 AM. Learn about Alibaba Cloud ECS, its features, benefits, and scalable architecture. Discover how it simplifies cloud computing for businesses of all sizes.
New Features in SQL Server 2025: A Guide for Data Engineers11/24/2024 5:46:37 AM. SQL Server 2025 introduces advanced AI integration, vector support, and performance upgrades like optimized locking and enhanced columnstore indexing. New features include JSON data type, regular expr
Data Cleansing in SQL Server11/24/2024 5:13:36 AM. Learn the essentials of Data Cleansing in SQL Server to enhance data quality and reliability. This guide covers techniques like removing duplicates, handling null values, standardizing formats, and tr
Exploring SQL Databases in Microsoft Fabric11/22/2024 11:29:28 AM. Microsoft Fabric now integrates SQL databases, bridging transactional and analytical workloads in a unified platform. It enables cloud-native data storage in OneLake, supporting Parquet and Delta form
Comparison Between SQL and MongoDB Database11/22/2024 5:23:46 AM. SQL and NoSQL(MONGO) DB Comparison. This article compares MS SQL Server and MongoDB, highlighting their development, data models, schemas, performance, and query mechanisms, aiding in understanding th
User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single valu
Setup .NET Core on Windows Server with IIS Migration11/21/2024 4:53:48 AM. This guide covers the installation of software required for .NET Core on Windows Server and the process of configuring IIS for hosting .NET Core applications.
Temporary Tables vs Table Variables in SQL Server Explained11/19/2024 10:49:20 AM. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Unlocking the Power of the SELECT Feature in SQL Server11/18/2024 12:04:57 PM. This article explores the basics of the SQL Server SELECT statement, demonstrating how to query data from tables using practical examples. Learn how to fetch specific columns, improve query performanc
How to Install Ubuntu Server on VMware ESXi Using VMware Client Browser11/18/2024 11:07:48 AM. This guide explains how to install Ubuntu Server on VMware ESXi using the web client. It covers steps like creating a virtual machine, selecting storage, uploading the Ubuntu ISO, configuring network
Enhance SQL Server Stored Procedure Performance – Tuning Tips11/18/2024 3:51:42 AM. Covering indexes and filtered indexes in SQL optimize database performance by efficiently retrieving data for queries. Covering indexes include all needed columns, while filtered indexes target specif
Deploying ASP.NET Core 9 Application on IIS11/14/2024 8:33:56 AM. Learn how to publish ASP.NET Core 9 applications on IIS. This guide covers key steps such as setting the correct target framework, configuring IIS settings, handling common errors like 503, and using
Converting HTML to PDF or Image in C# Using wkhtmltopdf11/13/2024 9:02:59 AM. This guide explains generating PDFs and images from HTML using wkhtmltopdf in C#. With wkhtmltopdf's Webkit-based engine, convert HTML content, including complex CSS and JavaScript, into high-qual
Beginner's Guide to CRUD Operations in .NET Core 8 Web API11/12/2024 7:30:14 AM. This guide walks you through creating a .NET Core 8 Web API for managing employee data with full CRUD operations. Using Entity Framework Core, you’ll define models, connect to a SQL database, create e
Explaning AWS Lambda Function11/12/2024 7:11:04 AM. AWS Lambda is a service that computes the code without any server. It doesn't need any server running, so It is said to be serverless computer. The code is executed based on the response of events
SSRS (4) --- SQL Server Database Project in Visual Studio11/11/2024 8:37:33 PM. This article is to discuss: SQL Server Database Project in Visual Studio
SSRS (1) --- Server Setup: SSIS, SSAS, and SSRS11/11/2024 8:31:56 PM. This article is to discuss SSRS (1) --- Server Setup, SSIS, SSAS, and SSRS
Creating Interactive Charts with Chart.js and TypeScript11/10/2024 6:08:34 AM. To create a responsive chart in a TypeScript application, use Chart.js—a popular library for data visualization. Set up your TypeScript project, install Chart.js and its types, and configure Webpack f
Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
Managing Exchange Online with Exchange 201911/2/2024 4:13:52 AM. In this article, we will learn how to integrate on-premises infrastructure with cloud-based Exchange services for seamless administration, enhanced security, and efficient mail flow control.
BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
Securing Remote Access to SQL Server10/30/2024 5:39:48 AM. Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
Create a Model with Database Table in .NET 8 using EF Core10/28/2024 7:16:12 AM. This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection str
Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
Server-Driven UI: Building Dynamic React Applications10/25/2024 11:44:23 AM. This video will explore how SDUI, combined with React, empowers teams to build flexible, maintainable, and quickly adaptable applications that deliver exceptional user experiences.
TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
Understanding the Role of Servers in Modern Networking10/25/2024 4:56:40 AM. Servers play a crucial role in modern networking by managing data storage, processing, and communications across networks. From web hosting and cloud computing to secure data transfer, servers enable
Enhancing Forms with React Server Components10/24/2024 11:49:57 AM. In this video, we explore the application of React Server Components (RSC) to elevate the functionality and efficiency of forms.
Caching HTML Tags Using WebForms Core Technology10/22/2024 8:31:41 AM. In this article, we teach how to cache static HTML tags (header, footer, right and left menus, etc.) in the user's browser by using WebForms Core technology in the CodeBehind framework.
Activate Server-Side Encryption for Azure Disks with Customer Keys10/21/2024 6:21:07 AM. Azure Disk Storage offers server-side encryption (SSE) with customer-managed keys, allowing users to control encryption for managed disks. By utilizing Azure Key Vault, users can manage access and enh
Troubleshooting 404 or 500 Error After Deploying Vue 3 App to IIS10/21/2024 6:06:12 AM. Facing a 404 or 500 error after deploying a Vue 3 application to IIS? This guide helps troubleshoot common issues, from configuring the web.config file to resolving routing problems with Vue Router&#3
Check Constraint in SQL Server 201210/16/2024 9:55:46 AM. A Check Constraint in SQL Server enforces Domain Integrity by ensuring valid values for specific table columns. It restricts invalid data entries, rejects values that don't meet set conditions, an
STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server10/16/2024 9:01:22 AM. The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of ea
Gitea - an Open Source, Self Hosted GitHub Alternative10/16/2024 4:51:49 AM. Gitea is a lightweight, self-hosted Git server that offers features similar to GitHub, including issue tracking, pull requests, and a web-based interface. It's ideal for organizations needing data
Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
How To Delete Duplicate Rows From A Table In SQL Server10/12/2024 5:29:23 AM. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the o
Get All Instances of SQL Server in C#10/11/2024 12:29:27 PM. If you're writing a Database Manager application or simply want to retrieve all the instances,this trick might come in handy.
Integration And Server Broadcast With SignalR 210/11/2024 12:29:10 PM. Discover how to implement real-time communication in your applications using SignalR 2. This guide covers the integration of SignalR for server broadcast functionality, enabling seamless data transfer
Building a Blazor Server App to Fetch RSS Feeds Using .NET Core10/11/2024 8:54:06 AM. In this article, we will explore how to build a Blazor Server app using .NET Core 6.0 to fetch and display RSS feeds. You’ll learn about setting up the Blazor environment, using HTTP clients for data
Exclude Exchange Databases from Auto-Provisioning in New DAG - Exchange 201910/10/2024 3:49:52 AM. In a multi-DAG Exchange environment, there are often scenarios where we want to ensure that primary mailboxes remain on a specific DAG, while a new DAG is reserved solely for archive mailboxes. This c
DATETRUNC New T-SQL Enhancements in SQL Server10/9/2024 6:48:59 AM. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)10/8/2024 8:54:22 AM. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
How To Send Mail Using SQL Server: Part 210/8/2024 8:32:47 AM. This tutorial demonstrates how to send emails using SQL Server 2008. It covers configuring an email profile, selecting data from a student table (tblStudents), and binding that data to an HTML-formatt
DATE_BUCKET Function New T-SQL Enhancements in SQL Server10/5/2024 6:28:43 AM. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL fun
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
A Fix To PolyBase Issue In SQL Server 2019 Developer Edition10/3/2024 1:16:46 PM. This article will introduce the problem, the reason and the fix related to a PolyBase issue when installing the SQL Server Developer Edition 2019.
Generate or find Connection String from Visual Studio10/3/2024 11:44:59 AM. This guide covers various methods, including using the Connection String Builder, accessing app.config and web.config files, and integrating with SQL Server and Entity Framework. Mastering connection
NTile Function in SQL Server10/3/2024 11:44:37 AM. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual
Creating Stored Procedures with Managed Code10/3/2024 11:41:01 AM. This article demonstrates how to create a stored procedure in Microsoft SQL Server 2005 using managed code in C#. It details the process of setting up a SQL Server project in Visual Studio, writing th
How to Use a Cursor in SQL?10/3/2024 11:08:13 AM. A cursor in SQL is a database object that allows row-by-row processing of query results. It enables you to iterate through a result set, perform operations on each row, and manage data more efficientl
Uploading Multiple Files in ASP.NET 2.010/1/2024 9:05:24 AM. The FileUpload control in ASP.NET 2.0 allows users to upload files from a web page. By using multiple FileUpload controls and a button, users can select and upload several files at once. The files are
Introduction To SignalR With .NET Core - Part One10/1/2024 8:24:06 AM. Learn how SignalR enables seamless server-client messaging, the basics of its architecture, and step-by-step instructions to set up your first SignalR project in ASP.NET Core.
A Detailed Explanation of COUNT in SQL Server10/1/2024 5:10:59 AM. This article explores the differences between SQL counting methods: COUNT(*), COUNT(1), COUNT(column_name), and COUNT(DISTINCT column_name). It highlights their purposes, performance considerations, a
Rank and Dense_Rank Function in SQL Server9/30/2024 4:48:24 AM. RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION
How to Send Mail Using SQL Server: Part 39/27/2024 10:16:21 AM. In this third installment of our series, "How to Send Mail Using SQL Server," we delve into the configuration and implementation of Database Mail. Learn how to set up SMTP settings, create m
Inserting Form Data Into DataBase Using Stored Procedure In ASP.NET C#9/27/2024 10:10:24 AM. Learn how to insert form data into a database using stored procedures in ASP.NET with C#. This guide covers setting up a form, handling user input, creating a stored procedure, and securely inserting
How To Add Dependency Injection In Your Sitecore Application9/27/2024 8:17:09 AM. Dependency Injection (DI) is a design pattern that enhances code maintainability and reusability by allowing developers to create loosely coupled components. It facilitates unit testing and supports v
How To Create Word Add-Ins9/27/2024 8:16:56 AM. This article outlines the steps to create and run a Word add-in using technologies like HTML, CSS, JavaScript, and C#. Word add-ins enhance functionality and work across platforms, including Windows,
Getting Started with Azure SQL Database – A Beginners Guide9/27/2024 7:19:23 AM. A quick introduction to Azure SQL Database that showcases some key offerings and highlights the flexibility and scalability that comes with it.
How To Get Unique Records Without Using Distinct In SQL Server9/26/2024 4:35:41 AM. In this guide, you'll learn how to retrieve unique records in SQL Server without using the DISTINCT keyword. We'll explore alternative methods like GROUP BY, ROW_NUMBER(), and Common Table Exp
Schedule Background Jobs Using Hangfire In ASP.NET Core9/24/2024 9:04:17 AM. Hangfire is an open-source library for ASP.NET Core that simplifies scheduling and monitoring background tasks like data processing and email reminders. By using Hangfire, you can create fire-and-forg
Check Disk Space Utilization by Tables in SQL Server Database9/23/2024 8:53:17 AM. In this guide, learn how to effectively check disk space utilization by tables in a SQL Server database. We’ll cover essential SQL queries and techniques to analyze table sizes, identify storage usage
Blazor Server Interactivity: It’s Like Magic. But, You Know, It Actually Works!9/22/2024 12:24:12 PM. Discover how Blazor Server achieves real-time interactivity using SignalR and render trees. We'll explores the behind-the-scenes mechanics that enable seamless UI updates without full-page reloads
A Comprehensive Guide to Migrating Azure Functions C# to C# 12 with .NET 8 Isolated9/21/2024 4:12:20 AM. Ziggy Rafiq shows how to leverage modern C# features, and how to optimize the performance and scalability of Azure Functions by migrating them to .NET 8 Isolated Processes.
Concurrency in SQL Server9/20/2024 4:06:27 PM. This article will discuss Concurrency in SQL Server
Database Backup With Compression in SQL Server9/20/2024 9:18:22 AM. This article explains how to perform database backup compression in SQL Server 2012 using SQL Server Management Studio or a Transact-SQL statement. It provides a step-by-step guide to visually create
How to Keep SQL Server Table Columns in Sync9/19/2024 4:29:35 AM. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
Create Backup and Restore Database in SQL Server9/18/2024 9:01:35 AM. This tutorial covers essential techniques for backing up your databases, restoring them when needed, and ensuring data safety. Master these skills to safeguard your SQL Server environment effectively.
Create A Timer Job In Sharepoint Programmatically Using Server-Side Object Model9/18/2024 8:59:02 AM. Learn how to programmatically create a Timer Job in SharePoint 2013 using the Server-Side Object Model. This guide covers setting up a SharePoint project, defining a TimerJob class, adding a Feature a
Bulk Insert From ASP.NET Web Form Using C#9/17/2024 10:39:37 AM. To insert bulk records into a database from a web form, create a ProductsSold table. Design a web form with GridView, TextBoxes, and Buttons to add and display products. Use a DataTable in ViewState t
Explaning SignalR in ASP.NET Core 89/17/2024 5:13:33 AM. Learn about setting up SignalR hubs, managing connections, and utilizing WebSocket and Server-Sent Events for efficient, scalable messaging in .NET 8 environments.
Overview Of Data Gateway In Power BI9/16/2024 11:19:33 AM. A Power BI Gateway connects on-premise data sources, such as SQL Server or SharePoint, to online services like Power BI. It ensures secure communication, supports both Personal and Enterprise Modes, a
Socket Class and ServerSocket Class in Java Networking9/16/2024 6:21:43 AM. TCP/IP sockets are the most reliable, bi-directional, stream protocols. It is possible to send arbitrary amounts of data using TCP/IP. Sockets are used for data communication using this protocol.
Implement Rate Limiting in REST API in .NET 89/13/2024 9:02:49 AM. Rate limiting is a technique used to control the number of API requests a client can make within a set timeframe, helping to prevent server abuse, protect resources, and ensure fair usage. This articl

Topics