Your Technical Consultant
In this tutorial, we discuss how to easily calculate a running total in SQL Server 2012 or above. Our goal is to calculate the running total that resets whenever the Transaction Date changes. We’ll total the transaction amount. For each […]
In this post, you will learn how to disable editor of WordPress (Theme and Plugin Editor). Before we get started, if you want to add custom CSS to your WordPress, please go through the following article: Easily Add Custom CSS […]
Continue reading WordPress Security : How to Disable the Theme and Plugin Editors
In this post, we want to discuss four examples of PIVOT and UNPIVOT in SQL Server. Before we get started, if you face a large-sized SQL Log file and want to reduce it as soon as possible, please go through […]
Continue reading Master PIVOT and UNPIVOT in SQL Server : Transform Your Data Like a Pro
In this tutorial, you will learn how to get all table names with row counts in SQL Server Database. Before we start, if you need to download the Crystal Report developer for VS 2019, please go through the following link: […]
Continue reading Get All Table Names with Row Counts in SQL Server : One Query to Rule Them All
I’m using the below T-SQL query to determine the last backup date of SQL Server Database. Before we get started, you also learn how to get all table names and their row counts in SQL Database. SELECT sdb.Name AS DatabaseName,COALESCE(CONVERT(VARCHAR(12), […]
Continue reading SQL Server DBA Tip : Check Your Last Backup Date with One Query
কৃত্রিম বুদ্ধিমত্তা (Artificial Intelligence – AI) বর্তমান বিশ্বের সবচেয়ে আলোচিত এবং দ্রুত বর্ধনশীল প্রযুক্তিগুলোর মধ্যে অন্যতম। এটি এমন একটি প্রযুক্তি যা যন্ত্রকে মানুষের মতো চিন্তা করতে, শিখতে এবং সিদ্ধান্ত নিতে সাহায্য করে। সহজ কথায়, এআই হলো মেশিনের বুদ্ধিমত্তা। কৃত্রিম […]
In this guide, we’ll show you how to install an RDP Server on CentOS 7 computer and how to connect to it through a remote desktop connection. We will install and configure an RDP server, set up different desktop environments […]
Continue reading Complete Guide : Install and Configure RDP Server on CentOS for Remote Access
FluentValidation is a popular .NET library for building strongly-typed validation rules for models in a clean and maintainable way. Unlike traditional validation methods, FluentValidation provides a fluent API, making validation rules more readable, maintainable, and reusable. It integrates well with […]
Continue reading FluentValidation vs DataAnnotations : Why FluentValidation is the Better Choice
In the ever-evolving world of web development, introducing your .NET Core Web API Security is not just an option—it’s a necessity. Effective API security goes beyond preventing unauthorized access; it involves protecting sensitive data, ensuring application reliability, and maintaining user […]
Continue reading Securing Your .NET Core Web API – Best Practices for Ultimate Protection
In this tutorial of Python Functions, we’ve got talked about Built-In Functions in Python. Now we have 67 of these in Python 3.6 with their Python Syntax and examples. So, let’s begin with Python Built-In Functions. 1. abs() The abs() […]
Continue reading Unlock Python’s Power – Built-In Functions with Syntax and Real-World Examples
