sharepoint-foundation-server

Resources

How to Encrypt Data in Amazon S3 Using Server-Side EncryptionJan 22, 2025. 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 AWS.
How to Implement Search Function in PowerAppsJan 22, 2025. 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 usability, and boosting app performance.
Differences Between TRUNCATE and DELETE in SQL ServerJan 22, 2025. 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 use SharePoint List Input Tool in AlteryxJan 16, 2025. Use Alteryx Designer to connect to SharePoint lists across versions (2007 to SPO). Configure the SharePoint Site URL, and credentials, and select the desired list and view. Filter data, limit records, and export to Excel using the output tool.
SQL Server – Query Performance – Database Maintenance can HelpJan 14, 2025. 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 or automatic execution for optimal results.
How to Configure Security Groups in AWS VPCJan 14, 2025. 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 Virtual Private Cloud (VPC).
Transaction in SQL ServerJan 13, 2025. 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.
Local and Global Temporary Tables in SQL ServerJan 13, 2025. Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
Database Dictionary (3) --- Loop Databases and Servers by AIJan 07, 2025. This article will discuss to loop databases and servers
What’s the Difference Between localhost and 127.0.0.1?Jan 07, 2025. Understand the difference between localhost and 127.0.0.1, their roles in networking, and when to use each for development, testing, or troubleshooting.
SharePoint Data from Azure Function using Self Signed CertificateJan 04, 2025. This article covers configuring Azure Functions, setting up certificate-based authentication, and connecting to SharePoint Online, enabling secure integration for seamless data access.
Apply UI to Enhance Choice Fields with Conditional FormattingJan 02, 2025. Enhance SharePoint lists with UI Conditional Formatting. Use JSON to customize Choice Fields, changing colors, icons, and text dynamically based on values like "Done" or "In progress" for better data visualization.
How to Add and Manage connections in Power Automate Jan 01, 2025. Learn how to add, manage, and secure connections in Power Automate. Integrate 500+ services like SharePoint, Excel, and Office 365 for seamless workflows, time-saving automation, and centralized management.
Add Data Bars UI in SharePoint List Column Formatting in SharePoint ListJan 01, 2025. This article walks you through the process of customizing your SharePoint list columns for better data visualization and enhancing the current view with conditional formatting to display dynamic, visually appealing data bars.
New Modern Microsoft Lists Forms Experience in SharePointJan 01, 2025. Master the new modern Microsoft Lists forms experience in SharePoint with this comprehensive guide. Learn how to create, customize, and optimize forms for better data collection and user interaction.
How to Apply Conditional Formatting with JSON in SharePointDec 31, 2024. This article covers the basics of JSON formatting, step-by-step instructions to customize SharePoint lists, and tips for creating dynamic and visually appealing displays to improve user experience.
How to Format List Views in SharePointDec 31, 2024. SharePoint list formatting enhances data presentation by customizing appearance, adding alternating row styles, and applying conditional formatting. It improves readability, highlights key data, and boosts user experience for efficient collaboration.
LookUp Function in Power Apps for Efficient Data RetrievalDec 31, 2024. The LookUp function in Power Apps allows efficient data retrieval by searching for a single record in a data source based on a condition. It's ideal for scenarios like pulling specific employee details from a SharePoint list.
Using Derived Column Task in SQL Server Integration ServicesDec 30, 2024. 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 using SSIS expressions.
Configure SharePoint Site Settings Using Power AutomateDec 26, 2024. This article covers automating site settings configuration, reducing manual tasks, and improving efficiency. With Power Automate workflows, you can manage permissions, update site properties, and automate administrative tasks effortlessly.
Conditional Split in SQL Services Integration Services (SSIS)Dec 23, 2024. 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 data transformation and filtering.
Hello World! In 20 Different Programming LanguagesDec 23, 2024. 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 syntax differences, language history, and usage, serving as a beginner-friendly guide for developers starting their coding journey.
How to Launch Your First EC2 InstanceDec 20, 2024. 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 Tier to start exploring virtual servers, storage options, and networking in the cloud.
Next.js Vs ReactJsDec 20, 2024. 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 like server-side rendering, static site generation, and routing.
Create FTP Task in SQL Server Integration Services Dec 19, 2024. 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.
Sensitivity Labels in Teams 365 Groups and SharePoint SitesDec 18, 2024. Extending sensitivity labels to Microsoft Teams, Microsoft 365 groups and SharePoint sites enhances data protection and compliance across collaboration platforms. It ensures that sensitive information is properly managed, classified, and secured according to organizational policies.
How to Install Nginx on EC2 AWSDec 18, 2024. 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 installation, configuration, and status verification.
Unlocking Faster INSERT Operations in SQL Server with TABLOCKDec 17, 2024. 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.
Azure AD B2C as an Identity Provider for Blazor Applications Dec 16, 2024. 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, covering setup, authentication, API permissions, and appsettings configuration for seamless SSO implementation.
Target Content to a Specific Audience on SharePoint SiteDec 10, 2024. Target Audience is a SharePoint feature that enables personalized content visibility for specific user groups. This is particularly useful for large organizations managing diverse teams, as it allows showing relevant files and folders to the right users.
Automating Table Creation using SSISDec 10, 2024. 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 instructions for automation.
Understanding Triggers in SQL ServerDec 09, 2024. 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 Server databases.
Using SignalR for Real-Time Communication in Blazor ApplicationsDec 09, 2024. 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 setup and practical use cases.
Token Caching in .NET 8 with Microsoft Entra IDDec 07, 2024. 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 in authentication processes.
Deploying a Web Application Using NGINX on Alibaba CloudDec 06, 2024. Learn how to deploy a web application using NGINX on Alibaba Cloud with updated console steps, covering ECS setup, NGINX configuration, security, and optimization.
INSERT INTO and SELECT INTO: Which is Better?Dec 06, 2024. 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 from the AdventureWorks2022 database, we’ll make the concepts clear and actionable.
ASP.NET Core CRUD using Dapper, .NET 8 using SQL ServerDec 05, 2024. 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 SQL Server integration.
Integration of an LDAP server in servicenowDec 01, 2024. 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?Nov 29, 2024. 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 manageable parts.
C# Foundation - Nullable TypesNov 28, 2024. This article covers the basics, syntax, and practical use cases of nullable types, enabling you to write safer, more reliable code by avoiding null reference errors effectively.
How to Configure Azure Cloud Backup Service to Windows 11Nov 28, 2024. 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 ServerNov 28, 2024. 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 flexibility in generating unique numbers.
C# Foundation - Implicitly Typed VariablesNov 28, 2024. Implicitly typed variables in C#, declared using the var keyword, let the compiler infer the data type from the initialization expression. This improves code readability and reduces verbosity, especially with complex types.
Renaming a Database in SQL ServerNov 27, 2024. 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, using the ALTER DATABASE command, and managing dependencies.
Explaining CTE in SQL ServerNov 27, 2024. 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 hierarchical data, aggregation, and filtering.
Rank Functions in SQL serverNov 26, 2024. 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 ServerNov 26, 2024. 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 ArchitectureNov 25, 2024. 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 EngineersNov 24, 2024. 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 expressions in T-SQL, and change streaming.
Data Cleansing in SQL ServerNov 24, 2024. 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 transforming data using SQL queries.
Comparison Between SQL and MongoDB DatabaseNov 22, 2024. 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 their suitability for various application needs.
Exploring SQL Databases in Microsoft FabricNov 22, 2024. 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 formats.
User-Defined Functions in SQL ServerNov 21, 2024. 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 value.
Setup .NET Core on Windows Server with IIS MigrationNov 21, 2024. 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 ExplainedNov 19, 2024. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Save List Data to Another List as an Attachment Using Power AutomateNov 19, 2024. This step-by-step guide covers creating workflows to transfer and attach data from one SharePoint list to another, automating data management, and improving efficiency in your SharePoint environment.
Create SharePoint Security Group using Power AutomateNov 19, 2024. This article explains how to create a custom SharePoint security group and assign permissions. Learn how to create custom SharePoint security groups with 'Contribute' permissions using Power Automate. Follow step-by-step instructions to automate group creation and permission assignment and manage SharePoint site roles efficiently.
Retrieve API Data and Store in SharePoint with Power AutomateNov 18, 2024. In this article, we will learn how to use Power Automate to retrieve data from an external API and automatically store it in a SharePoint list, streamlining your workflow and data management.
How to Install Ubuntu Server on VMware ESXi Using VMware Client BrowserNov 18, 2024. 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 settings, and installing Ubuntu.
Unlocking the Power of the SELECT Feature in SQL ServerNov 18, 2024. 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 performance, and understand best practices for using SELECT effectively, with a sample Employees table for clarity.
Deploying ASP.NET Core 9 Application on IISNov 14, 2024. 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 the app_offline.htm file for maintenance mode.
Beginner's Guide to CRUD Operations in .NET Core 8 Web APINov 12, 2024. 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 endpoints, and perform migrations.
Explaning AWS Lambda FunctionNov 12, 2024. 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 in AWS services, such as adding/removing files in the run/stop ec2 instances S3 bucket and updating Amazon DynamoDB tables.
How to Create a ListView Command Set ExtensionNov 12, 2024. A ListView Command Set extension in SharePoint customizes the command bar or context menu of lists/libraries. It allows adding buttons that trigger custom actions, such as displaying alerts, showing selected items, or integrating with external systems.
Creating Views for Lists or Libraries in SharePoint OnlineNov 12, 2024. Creating custom views in SharePoint Online allows users to tailor how lists and libraries display data. With options for filtering, sorting, grouping, and different layouts like calendar and gallery views, users can set up views to meet specific needs.
How to Create Field Customizer ExtensionNov 11, 2024. Extensions are client-side components that run inside the context of a SharePoint page. Extensions can be deployed to SharePoint Online, and you can use modern JavaScript tools and libraries to build them.
Creating Interactive Charts with Chart.js and TypeScriptNov 10, 2024. 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 for bundling.
How to perform CRUD Operations in Power AppsNov 10, 2024. Create a student management app in Power Apps with CRUD functionality—Create, Read, Update, and Delete—for efficient data handling. This app connects to a SharePoint list, allowing users to add, view, edit, and delete student records.
Library Component Type in SharePoint Framework (SPFx)Nov 09, 2024. SPFx Library Components enable the creation of reusable, modular code in SharePoint. By centralizing utility functions, services, and UI elements, developers can enhance maintainability and consistency across projects.
Fetch Document Versions in SharePoint using PowerShellNov 08, 2024. This PowerShell script connects to a SharePoint site to retrieve document versions from a specified library. It gathers metadata, including version numbers, last modified dates, and user details, then exports this information to a CSV file.
Overview of SharePoint Search API for SharePoint User ProfilesNov 07, 2024. The SharePoint Search API allows you to query user profile data, such as name, email, job title, and department. Using the POST /search/postquery method, you can easily retrieve user information with OAuth authentication.
Converting HTML to PDF or Image in C# Using wkhtmltopdfNov 05, 2024. 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-quality PDFs or images.
Managing Exchange Online with Exchange 2019Nov 02, 2024. 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.
Paging Microsoft Graph data in SPFxOct 31, 2024. Microsoft Graph return multiple pages of data either due to server-side paging or client-side paging. Paging data helps improve the performance of your app and the response time of Microsoft Graph.
Exploring the New T-SQL Enhancements in SQL Server 2022Oct 31, 2024. 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 optimize performance for modern data needs.
How to Set Permissions in Microsoft SharePoint Oct 30, 2024. Learn how to set permissions in Microsoft SharePoint effectively to ensure secure collaboration. This guide covers essential concepts, including permission levels, user access control, and managing site and document library permissions.
BIT Functions New T-SQL Enhancements in SQL ServerOct 30, 2024. 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.
Windowing Enhancements New T-SQL Enhancement in SQL ServerOct 29, 2024. 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, reduce code duplication, and improve readability.
Data Loss Prevention in Microsoft Fabric InternalsOct 28, 2024. Microsoft Fabric’s Data Loss Prevention (DLP) feature protects sensitive data across services like SharePoint, Teams, and Exchange by enabling policy creation, scanning, and enforcement through Microsoft Purview.
Create a Model with Database Table in .NET 8 using EF CoreOct 28, 2024. 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 string, and use migrations to manage your database schema.
Automate SharePoint Site Creation with Azure Functions and AD AuthOct 28, 2024. This guide demonstrates how to automate SharePoint site creation using Azure Function Apps with custom Azure Active Directory (AD) authentication. It covers prerequisites, creating an Azure Function App, configuring authentication, setting up permissions, and testing the function.
Rename Folder in SharePoint Online Document Library with Power AutomateOct 28, 2024. In SharePoint Online, renaming a folder in a Document Library with Power Automate can be done using an HTTP request to interact with the SharePoint REST API, as Power Automate lacks a direct rename action.
Efficient Data Handling in SQL Server with Table-Valued ParametersOct 27, 2024. 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.
User Profile Photos are Missing in the PnP People Webpart Oct 27, 2024. In this article, we will learn troubleshooting steps and best practices to ensure profile pictures display correctly, enhancing user experience in your SharePoint environment.
Add Multiple Users to SharePoint Group together in one API callOct 26, 2024. This article outlines how to streamline adding multiple users to a SharePoint Group using Power Automate. By leveraging a single HTTP request, users can efficiently batch add members to a group.
Understanding the Role of Servers in Modern NetworkingOct 25, 2024. 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 seamless connectivity.
TRIM Function New T-SQL Enhancements in SQL ServerOct 25, 2024. 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 from specific positions.
SharePoint Online - Add/Update Taxonomy Field Using Graph API Oct 25, 2024. This guide covers step-by-step instructions for integrating taxonomy fields, managing metadata, and customizing fields in SharePoint lists and document libraries. Enhance your SharePoint solutions with precise metadata control.
GENERATE_SERIES Function New T-SQL Enhancements in SQL ServerOct 25, 2024. 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 gaps, and generating test data.
Delete Comment from SharePoint List ItemOct 24, 2024. This article explains how to delete comments from a SharePoint list item using the SharePoint REST API and Power Automate. It covers creating a flow with a manual trigger, fetching comment details via HTTP requests, and deleting specific comments by ID, providing enhanced control over list items.
Create a Data Visualization Adaptive Card ExtensionOct 24, 2024. 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 charts or other visual elements.
Caching HTML Tags Using WebForms Core TechnologyOct 22, 2024. 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.
Troubleshooting 404 or 500 Error After Deploying Vue 3 App to IISOct 21, 2024. 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's history mode.
Activate Server-Side Encryption for Azure Disks with Customer KeysOct 21, 2024. 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 enhance security.
New Feature: Drag and Drop in Microsoft ListsOct 21, 2024. Microsoft Lists has introduced a new drag-and-drop feature, allowing users to seamlessly rearrange items in both new and existing lists. Custom ordering is saved across the list, and users can switch to custom order mode easily.
How to Create SharePoint Team or Communication SiteOct 20, 2024. Discover key differences between the two, step-by-step instructions for setting up each site type, and best practices to optimize your SharePoint environment for seamless teamwork.
Document Library in SharePoint Oct 19, 2024. SharePoint libraries are used to store, organize, and share files, enabling team collaboration and document management. The most common type, the Document Library, supports features like version control, permissions, and real-time co-authoring.
Getting Started with Databrick DatasetOct 19, 2024. This article dives into how to use databricks preloaded datasets. Databricks Datasets provide ready-to-use, real-world data built into the Databricks platform, enabling users to easily access, analyze, and refine machine learning, big data, and data science projects seamlessly.
Gitea - an Open Source, Self Hosted GitHub AlternativeOct 16, 2024. 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 protection, low resource requirements, and full control over their repositories.
SharePoint : Optimize SharePoint Storage with Version History Limits Oct 16, 2024. Discover how Microsoft's new version history limits (currently in preview) can help streamline document management and optimize SharePoint and OneDrive storage. Learn how to configure organizational-level version limits, automatically delete excess versions, and free up space for active content.

Tags

About sharepoint-foundation-server

OUR TRAINING