Serv Resources

Share

Related resources for Serv

How to Fix Recovery Pending State in MS SQL Server Database1/24/2025 11:32:57 AM. Learn about the causes of SQL Server's "Recovery Pending" state, methods to resolve it, and preventive measures. Explore manual fixes, recovery tools, and best practices to ensure databa
Understanding Precision in SQL Server Calculations1/24/2025 5:28:27 AM. Learn why SQL Server calculations can produce different results depending on the approach used. Discover how single-step and multiple-step calculations handle precision and rounding, and how to achiev
How to Encrypt Data in Amazon S3 Using Server-Side Encryption1/22/2025 8:58:03 AM. This article walks you through accessing your S3 bucket, enabling SSE-S3 encryption, uploading files, and verifying encryption. Protect sensitive information easily with default encryption settings in
How to Create and Attach an Amazon EBS Volume to an EC2 Instance1/22/2025 8:31:14 AM. Amazon Elastic Block Store (EBS) provides scalable, high-performance block storage for EC2 instances in AWS. EBS volumes offer reliable, fault-tolerant, and persistent storage for data, databases, and
Differences Between TRUNCATE and DELETE in SQL Server1/22/2025 8:14:06 AM. Learn the key differences between TRUNCATE and DELETE in SQL Server, two commands used to remove data from tables. Understand their syntax, performance impact, transaction logging, and use cases.
How to Implement Search Function in PowerApps1/22/2025 8:09:51 AM. Learn how to implement a dynamic search function in Power Apps to filter data from sources like SharePoint. This article covers step-by-step instructions for adding search features, improving usabilit
Introduction to Azure DevOps1/21/2025 8:22:04 AM. Azure DevOps is a SaaS platform from Microsoft offering tools for managing DevOps workflows. It integrates with popular tools, supporting CI/CD, version control, testing, and collaboration, available
Working with gRPC API in .NET 81/21/2025 5:23:12 AM. We create a simple gRPC service using .NET C# to perform CRUD operations on a book management system. Learn how to define a .proto file, implement server-side logic, and test with tools like Postman
Fabric Data Factory: On-Prems Folder to Fabric SQL Database1/20/2025 9:45:15 AM. In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for
Integrate GPT Models with Azure OpenAI Service1/18/2025 6:33:14 AM. Learn to set up Azure OpenAI Service: create an account, request access, deploy resources, obtain API keys, explore models like GPT-4, integrate via APIs, test, monitor usage, and scale for powerful A
How Using Features-as-a-Service Makes App Development Faster and Easier1/16/2025 3:48:59 AM. While coding can be an art form, the point of most software development is getting something done. Coding is fundamentally about solving a problem, and that privileges code reuse, software libraries,
Let's Play with ServiceNow Table API Using Postman1/15/2025 3:39:16 AM. Learn how to create and test a POST Table API in ServiceNow using Postman. Step-by-step guide covers API setup, JSON payload, authentication, headers, and testing, ensuring secure and efficient data h
SQL Server – Query Performance – Database Maintenance can Help1/15/2025 3:19:58 AM. To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual
How to Configure Security Groups in AWS VPC1/14/2025 8:43:39 AM. A Security Group in AWS is a virtual firewall controlling inbound/outbound traffic for resources like EC2 and RDS. It defines rules for IPs, ports, and protocols, ensuring secure access within your Vi
How to Create an User in AWS1/13/2025 10:39:20 AM. Learn how to create an IAM user in AWS to manage resources securely. This article covers the steps to configure user details, set permissions, add tags, and ensure proper access control for an organiz
Local and Global Temporary Tables in SQL Server1/13/2025 6:55:28 AM. Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
Transaction in SQL Server1/13/2025 5:32:43 AM. This article covers the basics of SQL transactions, including BEGIN, COMMIT, and ROLLBACK commands, ACID properties, isolation levels, and error-handling techniques for effective database management.
Database Dictionary (1-1) --- Server, Database, Schema, Table and Column1/11/2025 2:46:44 PM. This article is to discuss the major schemata in SQL server.
Database Dictionary (3) --- Loop Databases and Servers by AI1/7/2025 3:34:49 PM. This article will discuss to loop databases and servers
What’s the Difference Between localhost and 127.0.0.1?1/7/2025 6:08:53 AM. Understand the difference between localhost and 127.0.0.1, their roles in networking, and when to use each for development, testing, or troubleshooting.
Architecting for Observability in iOS Applications: Building Resilient and Measurable Systems1/2/2025 11:09:39 AM. In this video, you will learn how to build Resilient and Measurable Systems
How to Set Up DynamoDB in AWS?1/2/2025 7:33:42 AM. Amazon DynamoDB is a fully managed, serverless NoSQL database service offering fast performance, scalability, and flexibility. It supports key-value and document data models, with global availability
How to create an AWS SNS (Simple Notification Service)1/1/2025 9:53:11 AM. Amazon Simple Notification Service (SNS) is a scalable messaging service by AWS, ideal for sending notifications via email, SMS, or HTTP. Easily create topics, add subscribers, and publish messages to
What the Pub/Sub Building Block: Dapr in Action - Ep. 21/1/2025 5:28:12 AM. In this video, you will understand what the Pub/Sub building block is, what are some of its concrete component implementations and how you can use it in your own applications.
Service-to-Service Invocation: Dapr in Action - Ep. 31/1/2025 5:24:27 AM. In this episode, you will understand what the Service-to-Service invocation building block is, how it works, and how you can use it in your own applications.
A Fix to SQL Server Error 18456 - Login Failed12/31/2024 2:32:42 PM. This article is to discuss A Fix to SQL Server Error 18456 - Login Failed.
What is .NET Aspire?12/30/2024 5:00:58 AM. .NET Aspire enhances application development with modern practices, cross-platform support, scalability, and cloud-native capabilities. Leverage powerful tools, rich libraries, and community support t
Using Derived Column Task in SQL Server Integration Services12/30/2024 4:50:34 AM. The Derived Column Task in SQL Server Integration Services (SSIS) allows you to transform or modify data within your ETL process. It enables the creation of new columns or updates to existing ones usi
Efficient Data Handling in Angular 16 Using RxJS Observables12/28/2024 6:03:30 AM. Explore how RxJS Observables integrate with Angular 16 to handle asynchronous data efficiently. Learn key concepts, examples, pros, and cons, including real-time data handling, chaining operators, and
API Gateway Example with .NET and Ocelot12/26/2024 5:26:22 AM. Discuss the concept of an API Gateway using a sample .NET (Core) application. In this example, Ocelot (version 23.4.2) is used to manage key functionalities such as routing, rate limiting, and caching
Containerize React JS and .NET Core Apps using Azure Kubernetics Service (AKS)12/24/2024 10:00:38 AM. This article covers the entire process, from setting up Docker containers for your apps to deploying and managing them on AKS. Explore container orchestration, scaling, and cloud-native solutions with
Hello World! In 20 Different Programming Languages12/24/2024 9:01:37 AM. In this article, we are going to see how to print “Hello World” in 20 different programming languages. Explore how to print "Hello, World!" in 20 popular programming languages, showcasing sy
RxJS Subjects in Angular12/24/2024 5:57:30 AM. RxJS Subjects in Angular act as both Observable and Observer, enabling real-time data sharing. Multiple subscriptions and Angular services allow seamless communication between components using the ne
Conditional Split in SQL Services Integration Services (SSIS)12/23/2024 9:16:38 AM. Conditional Split in SQL Server Integration Services (SSIS) allows you to route data based on specific conditions within a data flow. It is used to direct data into different paths, enabling dynamic d
What Developers Should Know about Observability 12/21/2024 4:27:18 PM. In this video, we will explore modern observability and instrumentation approaches, focusing on the Pillars of Observability - “Metrics, Logs, Traces”
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.
Unit Testing in .NET Core with xUnit12/16/2024 11:34:13 AM. One of the main aspects of software testing that a developer can manage themselves is unit testing. It is employed to test your code's tiniest elements. Unit tests are used to verify that your cod
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
SQS Message Polling using C#12/15/2024 5:49:24 AM. This article explores integrating Amazon Simple Queue Service (SQS) with C# applications, covering essential concepts like long polling, receiving messages, and using the AWS SDK for .NET.
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
Overview of Azure App Service Environment V3 - ASE V3 12/13/2024 7:31:17 AM. In this article, we will learn about what is Azure App Service Environment V3, The basics of ASE V3, and how to create ASE V3 infrastructure using Terraforem
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
How to Install Node.js on AWS EC2 and Check Services Status12/7/2024 3:04:42 AM. Learn how to install Node.js on an AWS EC2 instance with this step-by-step guide. We’ll walk you through setting up an EC2 instance, installing Node.js, and verifying the installation. Additionally, y
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
Create Worker Service and Deploy as Windows Service .NET Core12/4/2024 5:01:25 AM. In this article, we will learn how to create a .NET Worker Service in Visual Studio, configure it as a Windows Service, and manage it using commands for seamless background task execution.
Alibaba Cloud IMS: End-to-End Media Management Solution12/3/2024 6:32:39 AM. Explore Alibaba Cloud IMS, a powerful media service for content collection, processing, production, and delivery with advanced AI-driven workflows.
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
Minimal Web API With .NET 911/27/2024 11:10:40 AM. In this article, you will learn about RESTFul Minimal Web API with .NET 6 and .NET 7. REST APIs use the REST architecture style to provide standardized resource access using HTTP verbs. Minimal APIs
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.
Yet another framework11/25/2024 11:46:45 AM. In this video, you will learn about missing patterns from the perspective of MVC.
Azure Storage Account Vs Azure Data Lake Service Gen 211/25/2024 8:15:25 AM. Azure Data Lake Storage Gen2 (ADLS Gen2) is a highly scalable and analytics-optimized storage solution in Azure, offering hierarchical namespace, big data processing capabilities, and Secure File Tran
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.
Events: Love Triangle in Integration Testing11/20/2024 6:30:48 AM. This video will delve into the main problems of not creating integration tests that check whether the application works fine, showing different alternatives with their pros and cons.
Apache Kafka with Dapr Bindings in .NET11/20/2024 4:30:36 AM. This content provides an in-depth overview of integrating Apache Kafka with Dapr Bindings for building distributed event-driven applications. It explains the key concepts of Apache Kafka, Dapr, and Da
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
Install and Enable IIS Express on Windows 1111/16/2024 10:18:05 AM. Learn how to install and enable IIS Express on Windows 10/11. Follow simple steps to download, install, and activate IIS Express for hosting web applications on your system.
Amazon OpenSearch Service Setup with Kibana11/15/2024 9:48:13 AM. Amazon OpenSearch Service enables real-time search, monitoring, and analysis of business data. It integrates with AWS services like CloudWatch Logs and Lambda for log aggregation, with Kibana for data
🚀 Amazon Bedrock Agents for Efficient Automation 🌟11/14/2024 11:35:26 AM. Unlock the power of Amazon Bedrock Agents with this comprehensive guide. Learn how to master efficient automation, streamline workflows, and optimize your cloud-based processes like a pro using AWS to
Azure Data Factory PRESERVE HIERARCHY Copy Behaviour11/14/2024 9:41:42 AM. In this video, I covered how to use the Preserve Hierarchy in Azure Data Factory Copy Behaviour.
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
Micro-Service Architecture in Devops11/13/2024 11:35:44 AM. Microservice architecture in DevOps focuses on developing and deploying applications as a collection of small, independent services. It enhances scalability, flexibility, and continuous integration/co
Understanding Keyed Services in .NET 811/13/2024 9:12:24 AM. Keyed Services in .NET 8 enhance dependency injection by allowing multiple implementations of an interface to be registered with unique keys. This enables flexible dependency resolution, ideal for tai
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
🚀 Unlock Your Coding Potential with Amazon Q: AWS’s New AI Coding Assistant! 🚀11/13/2024 7:02:38 AM. If you are looking to enhance your coding workflow, check out Amazon Q. This AI-Powered coding assistant helps simplify coding with features like Code Understanding, Code Generation, Refactoring and T
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
RxJS Operator Essentials: Map, Tap, Filter, and More11/12/2024 5:15:13 AM. This article explores key RxJS operators in Angular, like map, tap, filter, take, and takeLast. You'll learn how each operator manipulates data streams to handle emitted values, log information, a
An Introduction to Microsoft Fabric Fundamentals11/12/2024 5:13:49 AM. Learn the core concepts, including Fabric architecture, data lake integration, and analytics capabilities, designed to streamline data management and empower insights across organizations.
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
Azure Logic App11/10/2024 7:04:51 AM. In this article, we will learn about Azure Logic Apps, which is a cloud-based service that enables users to create automated workflows and integrate applications, data, and services across the cloud a
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
Simplifying Multi-Cloud Observability11/6/2024 11:31:54 AM. This video highlights the essential role of standardized, vendor-agnostic approaches in ensuring scalability and usability in modern monitoring practices.
Create Azure App Service via PowerShell 711/5/2024 10:05:05 AM. In this guide, learn how to create an Azure App Service using PowerShell 7. We'll cover the essential steps, including setting up your environment, configuring your app service plan, and deploying

Topics