Serv Resources

Share

Related resources for Serv

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.
Understanding API Gateways in Microservices11/1/2024 5:34:50 AM. The API Gateway pattern centralizes client requests, managing authentication, logging, rate limiting, and load balancing, optimizing resilience and scalability in complex microservice architectures th
Dependency Injection & EF Migrations in ASP.NET MVC with Autofac10/30/2024 8:29:43 AM. This article demonstrates how to implement Dependency Injection (DI) using Autofac in an ASP.NET MVC application and integrate Entity Framework for database operations, including migrations.
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
Data Reliability and Availability with Microsoft Fabric Mirroring10/29/2024 4:05:52 AM. Mirroring in Microsoft Fabric enhances data reliability and availability by creating redundant copies of data across multiple locations. This ensures high availability, fault tolerance, and rapid disa
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.
Speedy Microservices: Build and Deploy in 30 min with Copilot & Devprime10/25/2024 11:40:16 AM. In this video, you will learn how Copilot & Devprime revolutionize your Dev Experience.
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
Understanding ARC in Email Authentication10/25/2024 9:03:52 AM. Email authentication is crucial for preventing spoofing and phishing attacks, and ensuring secure communication. Authenticated Received Chain (ARC) helps mitigate failures caused by message modificati
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.
Create a Data Visualization Adaptive Card Extension10/24/2024 7:03:25 AM. Creating a Data Visualization Adaptive Card Extension (ACE) for SharePoint Online using the SharePoint Framework (SPFx) involves building a custom ACE component to display visual data in the form of c
Enhancing Microservices with Kafka: A Distributed Messaging Solution10/23/2024 8:17:59 AM. In this video, we will explore how to effectively bridge various pods and JVMs while considering key factors such as scalability, resilience, high availability, and performance for intensive applicati
Introduction to Power BI: A Beginner's Guide10/22/2024 9:31:36 AM. Power BI is a powerful business analytics tool from Microsoft designed for data visualization and sharing insights across organizations. This beginner-friendly guide covers its key components, includi
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.
Serialization and DeSerialization in C#10/21/2024 10:18:19 AM. Serialization is the process of converting an object into a storable format, such as XML, JSON, or binary, while deserialization restores it to its original form. Common types include XML, JSON, Binar
Learn AngularJS From Beginning: Service - Part Three10/21/2024 9:48:47 AM. This article explores AngularJS services, emphasizing their role in organizing and sharing code through dependency injection. It covers creating custom services using the factory, service, and provide
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
Azure service bus queue with .net core and python10/20/2024 9:30:13 AM. This article demonstrates how to implement Azure Service Bus queues using both .NET Core and Python. It covers creating a message sender with a web API in .NET Core and a receiver using a console app.
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
What are the Main Differences in Service Offerings Between AWS and Azure?10/11/2024 3:44:42 AM. AWS and Azure offer similar core cloud services, but AWS generally provides a broader range of options while Azure excels in Microsoft ecosystem integration.
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
Integration of Angular with Microservices10/9/2024 7:27:58 AM. This content explores the integration of Angular with microservices, highlighting the advantages of building scalable and efficient web applications. It covers key concepts such as RESTful APIs, async
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.
Creating Custom Restaurant Reservation Alexa Skill Using Alexa Hosted NodeJS10/8/2024 9:35:47 AM. This guide walks you through setting up a voice-activated reservation system, integrating it with Alexa's developer console, and automating bookings for restaurants using simple Node.js coding tec
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
What is Alibaba Cloud Object Storage Service (OSS)10/8/2024 3:55:37 AM. Discover Alibaba Cloud OSS, scalable and secure cloud storage for unstructured data, offering high durability, cost-effectiveness, and global accessibility.
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
Understanding Service, Factory, And Provider10/3/2024 11:38:34 AM. AngularJS provides three methods for creating reusable utilities: Service, Factory, and Provider. All serve the same purpose but differ in implementation. Services are singletons, Factories return new
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
Design Pattern (5-1), Dependency Injection Implementation10/1/2024 1:44:22 PM. This article will discuss more about the implementation of Dependency Injection.
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
How to Use Scoped Service from Singelton Service in .NET Core9/30/2024 5:43:28 AM. This guide explains how to resolve scoped services from a singleton service, highlighting best practices to avoid common pitfalls and ensure proper resource management in your application.
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
Getting Started with GPT-3.5 Turbo on Azure OpenAI Service in .NET9/28/2024 5:48:07 AM. This article explores how to integrate Azure OpenAI Service and GPT-35-Turbo into .NET applications for generating text responses based on user prompts.
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.
Why "Service Locator" is an "Anti-Pattern" for Dependency Injection9/26/2024 8:29:26 AM. The "Service Locator" pattern, while widely used, often leads to issues in software design, making it an anti-pattern in the context of Dependency Injection (DI). This article explores the d
JWT Token Authentication And Role Authorization Using .Net Core 6.0 Web APIs9/26/2024 6:13:29 AM. This post covers implementing JSON Web Tokens (JWT) for authentication in an ASP.NET Core Web API. It details creating a new project, using JWT for secure token generation, and implementing role-based
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
Create List in SharePoint Using REST API9/23/2024 10:54:30 AM. Learn how to create a list in SharePoint 2013 using the REST API in this comprehensive guide. We'll explore step-by-step instructions, key concepts, and practical examples to help you leverage Sha
Geographical Information by IP Address in ASP.NET and C#9/23/2024 9:27:00 AM. This article explains how to obtain geographical information about website visitors using their IP addresses. It showcases a free service from iplocationtools.com that provides data in XML, JSON, and
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
Exploring the Performance Boosts in .NET 99/20/2024 4:22:58 AM. .NET 9 introduces key performance improvements, including Native AOT for faster startup times and reduced memory usage, optimized garbage collection, enhanced threading for multicore systems, and HTTP
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 jqGrid Using WebService9/18/2024 9:21:38 AM. Discover step-by-step instructions on setting up jqGrid, connecting it to a backend WebService, and efficiently loading and displaying data. Perfect for developers looking to enhance their web applica
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
Machine Translation Services: Synchronous and Asynchronous Translation in SharePoint 20139/17/2024 10:40:32 AM. Learn how these approaches can enhance your SharePoint environment, streamline multilingual communication, and improve overall efficiency in document and content management.
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
How to Create a Simple Web Service and Use it in ASP.NET9/17/2024 10:29:10 AM. Learn to create and use a web service in ASP.NET with this guide. Start by setting up a new ASP.NET project in Visual Studio, adding a web service file, and defining methods for basic arithmetic opera
Azure App Service: Create Web App from Visual Studio9/17/2024 10:25:52 AM. To create a new web application in Visual Studio, go to File -> New Project and select “Web Forms,” ensuring the “Host in the Cloud” checkbox is checked with “App Service” selected. After configuri
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.
CRUD Operations Using Knockout in MVC Application: Part 29/16/2024 11:22:32 AM. This article demonstrates CRUD operations using Knockout.js in an MVC application. It covers the View class, focusing on Knockout bindings, observable arrays, and AJAX calls for creating, editing, and
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
Understanding Three-Phase Commit in Microservices9/12/2024 11:24:23 AM. Delve into how distributed transactions ensure consistency, atomicity, and fault tolerance across decentralized systems, maintaining ACID properties crucial for scalability and robust transaction mana
Create A Simple Web Service In ASP.NET Using C#9/12/2024 6:14:14 AM. This guide covers building a REST API, handling HTTP requests, and integrating with JSON/XML data formats. Ideal for beginners, it provides step-by-step instructions using Visual Studio, focusing on p
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
Deploying Simple Storage Service (S3) Account in AWS9/12/2024 5:07:32 AM. Learn how to deploy and configure an Amazon S3 (Simple Storage Service) account in AWS. This guide covers setting up your AWS account, creating S3 buckets, and managing storage efficiently. Ideal for
Understanding Two-Phase Commit in Microservices9/11/2024 6:47:37 AM. The Two-Phase Commit (2PC) protocol ensures data consistency in microservices by coordinating transactions across services. It involves a prepare phase where participants log changes and vote, and a c
Keyed Service Dependency Injection in .NET9/11/2024 5:16:26 AM. Keyed Service Dependency Injection in .NET allows services to be registered and resolved using unique keys, improving flexibility in scenarios where multiple implementations of an interface are requir
Getting Started With Apache Kafka: Introductory Guide9/11/2024 3:36:55 AM. Apache Kafka is a distributed event streaming platform that enables real-time data processing and integration across microservices. It supports publishing and subscribing to streams of records, storin
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

Topics