Related resources for Server
  • 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
  • SSRS (1) --- Server Setup: SSIS, SSAS, and SSRS9/29/2024 3:16:53 PM. This article is to discuss SSRS (1) --- Server Setup, SSIS, SSAS, and SSRS
  • 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
  • Entity Framework In MVC - Part Three9/12/2024 12:12:57 PM. This article explains the Code First approach in MVC using Entity Framework. It covers creating a new database from domain classes, reverse engineering an existing database to generate POCO classes, a
  • Entity Framework Core Feature - Global Query Filters9/12/2024 5:59:39 AM. Learn how to implement Global Query Filters in Entity Framework to apply automatic filters at the model level. This feature is commonly used for scenarios like soft delete and multi-tenancy, ensuring
  • Configure SQL Server Session State In ASP.NET Core9/12/2024 5:49:48 AM. This guide covers setting up SQL Server as a session storage provider, configuring the connection string, enabling session middleware, and ensuring session persistence for scalable web applications.
  • CRUD Operation Using Repository Unit Of Work Pattern9/12/2024 5:44:14 AM. Create an ASP.NET MVC project in Visual Studio 2013, add a class library, and set up a SQL Server database. Implement Entity Framework with an EDMX model, then use the Repository pattern for CRUD oper
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode9/12/2024 5:10:58 AM. This article explains how to configure a Data Gateway for an On-Premise SQL Server Database using Power BI's Recommended Mode. It covers the installation steps, including downloading and setting u
  • Database Mail Configuration in SQL Server 20089/10/2024 10:16:49 AM. Learn how to configure Database Mail in SQL Server 2008 with this guide. Discover step-by-step instructions for setting up email profiles, configuring SMTP settings, and managing mail settings using S
  • How to Install FTP Server on Windows Server 20129/9/2024 11:47:46 AM. This guide covers step-by-step instructions, including setting up IIS (Internet Information Services), enabling the FTP service, creating FTP sites, and configuring security settings for efficient fil
  • SQL Data Analysis Using Azure Synapse Built-in Serverless Pool9/6/2024 6:06:58 AM. In this video, I demonstrated how to perform SQL Data Analysis in Azure Synapse Analytics using built-in serverless pool.
  • Working With FTP Using C#9/5/2024 11:26:20 AM. Learn how to work with FTP (File Transfer Protocol) using C# in this comprehensive guide. Explore how to connect to FTP servers, upload and download files, and manage file transfers programmatically.
  • Export Data Table To Excel in ASP.Net MVC 49/5/2024 11:09:19 AM. This article demonstrates exporting a Data Table to Excel in ASP.NET MVC. It covers creating a new project, adding a ClosedXML reference, and setting up models and controllers. It details fetching dat
  • How To Implement CKEditor In ASP.NET MVC9/5/2024 10:45:12 AM. CKEditor is a powerful, browser-based WYSIWYG editor that simplifies HTML content creation. It integrates seamlessly with ASP.NET MVC, allowing users to easily create and manage rich text content.
  • Temporary Tables vs Table Variable in SQL Server9/5/2024 7:20:02 AM. In this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. Temporary tables come in two types: Local (prefixed with "#", accessible only to the current con
  • What are Temporary Tables in SQL Server?9/5/2024 7:19:46 AM. Temporary tables in SQL Server, stored in tempdb, assist with short-term data management. They come in Local (scope limited to current connection, prefixed with "#") and Global (accessible t
  • Remote Bind Kendo Grid Using AngularJS And ASP.NET WEB API9/4/2024 9:09:52 AM. This article demonstrates integrating Kendo UI with AngularJS and ASP.NET Web API. It covers creating a WEB API application, setting up an Employee model and controller, testing with POSTMAN/Fiddler,
  • Database Mail in SQL Server 2008R29/4/2024 8:38:30 AM. Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure e
  • GridView Paging Sample in ASP.NET9/4/2024 8:21:34 AM. Learn how to implement various paging styles in ASP.NET GridView using C#. This guide covers binding SQL Server data to a GridView, enabling paging, and customizing pager settings like Numeric, NextPr
  • Configure SQL Server Database Mail for Sending Emails9/4/2024 7:01:19 AM. This guide covers the step-by-step process for setting up Database Mail, including creating and managing mail accounts, profiles, and ensuring your SQL Server can successfully send email notifications
  • Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
  • Learn Database Mail in SQL Server8/29/2024 10:53:40 AM. Database Mail in SQL Server is a robust feature that enables sending emails via an SMTP server without relying on MAPI clients like Outlook. It offers secure SSL encryption, asynchronous processing, e
  • SSRS (4) --- SQL Server Database Project in Visual Studio8/29/2024 2:28:31 AM. This article is to discuss: SQL Server Database Project in Visual Studio
  • Inner Join vs Cross Apply and Left Outer Join vs Outer Apply8/28/2024 5:32:30 AM. In SQL, INNER JOIN and CROSS APPLY differ in functionality; INNER JOIN merges rows based on a condition, while CROSS APPLY uses a table-valued function for dynamic row operations. LEFT OUTER JOIN incl
  • SQL Data Analysis using Azure Synapse Built in Serverless Pool8/28/2024 4:28:22 AM. In this Azure Data Engineering episode, I discussed how to perform SQL Data Analysis using Azure Synapse Built in Serverless Pool
  • How to use React and Gatsby.js?8/27/2024 5:29:35 AM. Pairing React with Gatsby.js allows for the creation of high-performance, SEO-friendly websites. This guide walks you through setting up a Gatsby project, integrating React components, and using essen
  • How to Create API Gateway for React JS Application?8/24/2024 7:31:16 AM. This guide covers setting up an API Gateway for your React.js application using Express.js. Learn how to centralize API requests, enhance security, and optimize performance by routing frontend request
  • Decouple Frontend and Backend with Postman Mock Server in Angular8/23/2024 9:55:11 AM. Postman Mock Servers let front-end developers bypass backend dependencies by simulating API responses. In an Angular project, configure interceptors to direct API calls to mock servers or actual APIs
  • Reading Email and Attachment From Microsoft Exchange Server8/23/2024 9:30:57 AM. In this article you will learn how to read an email and its attachment(s) from Microsoft Exchange Server.
  • Intalling Windows Server 2025 Preview on VMware ESXi8/23/2024 5:27:28 AM. Learn how to set up a virtual machine, configure ESXi settings, and optimize your server for the latest Windows Server version. Ideal for IT professionals and system administrators looking to explore
  • How to get all the user properties using powershell in SharePoint 2010 8/22/2024 7:23:23 AM. Learn how to retrieve all user properties in SharePoint 2010 using PowerShell. This guide covers how to get user details with scripts that access the SharePoint site, fetch user profiles, and handle c
  • Real-Time Pageview Tracking With .NET Core8/21/2024 5:28:26 AM. Learn how to implement real-time pageview tracking in your .NET Core application. This guide covers setting up live monitoring of website traffic, capturing pageview metrics, and integrating real-time
  • Prompt Management in Amazon Bedrock using .NET Console App8/20/2024 7:40:21 AM. Learn to create and manage prompts in Amazon Bedrock using a .NET console application. This guide covers setting up your environment with AWS CLI and Visual Studio, and using the AWSSDK.BedrockAgent p
  • Learn to Shrink a Microsoft SQL Server Database Programatically 8/20/2024 4:59:45 AM. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause
  • Recursive CTE: Simplifying Complex Queries with SQL8/16/2024 7:14:44 AM. Recursive CTEs in SQL simplify querying hierarchical or recursive data by breaking down queries into anchor and recursive members. They are ideal for traversing structures like organizational charts o
  • Learn Server-Sent Events in C# .NET8/14/2024 5:36:57 AM. Server-Sent Events (SSE) in C# .NET enable real-time, one-way communication from server to client over HTTP, ideal for live updates like notifications or data streaming. Unlike WebSockets, SSE is simp
  • SQL Server on Azure VMs vs Managed Instance vs SQL Database8/12/2024 11:18:45 AM. Based on the type of the cloud service each Relational azure service use and different aspects formulated the differences and uses cases when to use each database solution.
  • Deploy Internet Information Services (IIS) on Windows Server8/12/2024 11:13:33 AM. Internet Information Services (IIS) is a Microsoft web server on Windows Server, used to host and manage websites and web applications. It supports various web technologies like HTML, ASP.NET, and PHP
  • Building a centralized OAuth server With OpenIddict in .NET8/12/2024 7:17:23 AM. Recently, I completed a project aimed at constructing a standalone identity service. This endeavor aimed to implement OAuth 2.0 and OpenID Connect protocols in ASP.NET Core applications, enabling othe
  • Angular SSR (server-side rendering)8/10/2024 4:28:35 AM. Angular SSR (Server-Side Rendering) with Angular Universal enhances web app performance by rendering pages on the server before they reach the client. This approach improves load times, SEO optimizati
  • Integrating SharePoint Data Into Node.JS Application8/9/2024 9:47:50 AM. Learn how to integrate SharePoint data into Node.js applications. This guide covers setting up a Node.js environment, installing necessary packages (node-sp-auth, request-promise), and authenticating
  • How To Change Suite Bar In SharePoint 20168/9/2024 9:44:45 AM. Learn how to customize the SharePoint suite bar by changing the default text and adding a logo using PowerShell. This guide covers updating the suite bar text to custom labels like "Central Admin
  • Optimizing Performance in Next.js8/8/2024 10:06:30 AM. Performance is crucial in web development, and Next.js offers several tools and strategies to ensure your application runs efficiently. This article covers essential techniques for optimizing performa
  • Understand HTTP.sys Web Server In ASP.NET Core8/7/2024 10:47:20 AM. HTTP.sys is a Windows-based web server for ASP.NET Core, offering features like Windows Authentication, response caching, WebSockets, and HTTPS with SNI. Unlike Kestrel, it does not support IIS or IIS
  • Using Next.js with TypeScript8/7/2024 7:29:18 AM. Integrating TypeScript with Next.js enhances code quality by adding static types. Start by creating a Next.js project, then install TypeScript and necessary type definitions. Configure tsconfig.json,
  • Implementing Pagination and Filtering in ASP.NET Core 8.0 API 8/6/2024 6:40:33 AM. Learn how to efficiently implement pagination and filtering in your ASP.NET Core 8.0 API using Entity Framework Core. Enhance performance, scalability, and user experience with server-side data handli