A binary value or type in SQL Server is a series of bytes (known as a byte array in some programming languages). Just like char/varchar, there are fixed-length types, binary(1-8000), and variable-length ones, varbinary(1-8000) and varbinary(max). Sometimes we store this type of data in SQL Tables and lose the source files. This type of data is stored in a binary…
Author: Pablo Francesco
Introduction to Triggers in SQL Server
Tiggers are commonly used to automate data updates in SQL Server. This article describes the fundamentals of triggers in SQL, the different categories of triggers, and how to implement triggers in SQL Server. What is the SQL Server Trigger? A SQL trigger is a database object that executes when a database event occurs. When a…
People Web Part in SharePoint Online
The “People” web part in SharePoint Online allows you to display information about people within your organization. This web part displays the user’s profile picture, contact information, job role, and additional details. Adding People web part to SharePoint online page To add a People web part to a SharePoint Online page, enter the Edit mode…
Package Managers in JavaScript
As a JavaScript developer, choosing the right package manager is crucial to your productivity and sanity. The three contenders in the battle are npm, Yarn, and pnpm. In this post, we’ll compare these package managers to see which reigns supreme. npm The Node Package Manager (npm) is the default option that comes included with Node.js….
Simple Steps To Safeguard Websites In WordPress
In this article, I will explain how to safeguard WordPress websites in simple steps, Nowadays, we secure our homes with advanced padlocking systems. We keep our valuable possessions away in bank lockers. We know that our assets mean a lot to us, and over the years, we have learned the best ways to fortify their…