Your Technical Consultant
Storing and retrieving data as requested by other software applications, either on the same computer or a remote machine, utilizing the client-server model.
Searching data efficiently is one of the most common challenges developers face—especially when users want to search using multiple keywords across multiple columns. Whether you’re building a web app, an admin dashboard, or a reporting system, implementing a flexible search […]
Continue reading How to Search Across All Columns with Multiple Keywords (Complete Guide)
On this publish, We’ll discover ways to create a read-only SQL Server User Account. You already know that ‘sa’ account has particular privileges required to manage the SQL Server database. The ‘sa’ account is a well-known SQL Server account and […]
Continue reading SQL Server Security: How to Set Up a Read-Only User Account
This put up goes via the steps and processes to Call Web API from SQL Server Stored Procedure. These steps are relevant to Microsoft SQL Server 2014. Pre-Requisites Initially, to make an HTTP request name Web API from SQL Server […]
Continue reading Call Web API from SQL Server Stored Procedure
In this post, we want to discuss benefits, uses, levels of Normalization, and Denormalization. Before we get started, if you want to know about SQL rowversion, please go through the following article: What is rowversion in SQL Server? Introduction Normalization is […]
Sometimes, we are requested to provide certain information from a database via e-mail. If the request is repeated frequently, it is difficult to repeat this annoying similar process. For this reason, you should regularly send emails with predefined content. Database […]
Continue reading Configure database mail and send email from MS SQL Server
Hello Reader! In this post, we want to discuss a nice function to reduce transaction log size in SQL Server. Before we get started, if you want to know about split with any delimited string, please go through the following […]
Continue reading Query to Reduce Transaction Log File Size to Just 1MB
In this article, we want to discuss the efficient way to Optimize SQL Queries in SQL Server. Before we start, if you want to know how to use a cursor in SQL, please go through the following article: Using Cursor […]
In this post, we want to discuss a nice function to use multiple columns for NOT IN in SQL Server. Before we get started, if you want to know about random number generators, please go through the following article: Random […]
Continue reading SQL: Can you use multiple columns for NOT IN
Hello Everyone! In this article, we want to discuss a nice function of adding the value of every row to the next in SQL Server. Before we get started, if you want to know about using multiple columns with “Not […]
Continue reading Counting sql rows, adding value of every row to the next
Hello Everyone. In this post, we want to discuss about a nice function to search string in whole table (all row/column) in SQL Server. Before we get started, if you want to know about using of Cursor, please go through […]
Continue reading Search string in whole table (all row/column) in SQL Server
