SQL Server’s COALESCE function is a powerful tool for dealing with NULL values in your database queries. It allows you to return the first non-NULL value from a list of expressions. Ho… Read More

Vector databases are gaining quite a lot of interest lately due to the fact that using text embeddings and vector operations it is extremely easy to find similar "things". Things can be arti… Read More

Question: How can I find and report on SQL Server tables with LOB columns but where the table has no PRIMARY KEY?    I'm classing an LOB column as 'TEXT', 'NTEXT','IMAGE' ,'XML', '… Read More

If you are receiving a WSUS error saying Error: Connection Error when trying to connect to the WSUS (Windows Server Update Services) server, there are several potential causes and solutions… Read More

Definition of SQL to Number Format Have you ever come across a situation where you need to convert a string of numbers in SQL to a specific number format? If so, then you are familiar with S… Read More

When talking about open-source database management systems, most people prefer MySQL. It mostly helps in web applications for the speed factor. It is fast and safe. MySQL connector java… Read More

Any string variable that is annotated with @Nationalized annotation will be mapped using NVARCHAR.   @Nationalized annotation specifies that the annotated character data should be store… Read More

Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator positio… Read More

Merhaba, Bu yazımda SQL Sunucu üzerinde oluşan Deadlock’ların nasıl oluştuğu ve nasıl izleyebileceğimiz konusunda çok basit bir y… Read More

Introduction to Azure Functions C# The following article provides an outline for Azure Functions C#. Microsoft’s primary compute service is Azure function C#. We gain agility in develo… Read More

Introduction to T-SQL CASE The T-SQL CASE is defined as the CASE that can be utilized with a statement or clause that can accept logical expressions; we can able to use the CASE in statemen… Read More

Introduction to T-SQL Loop T-SQL loop is defined as the loops that have been utilized to recurrent the implementation of more than one statement within a particular period, which can also b… Read More

SQL Server में अलग-अलग type के Data Type होते है जैसे - Numeric… Read More

In this post, I'm sharing with you an SQL script that allows us to search for a particular text or keyword in all the SQL tables. The script will loop through all tables, all rows… Read More

 SQL Server Audit, Prevention and Detection Of Attacks - It's Much Easier Than You Think! SQL Server Audit, Prevention and Detection Of Attacks - It's Much Easier Than You Think!Preface… Read More

When talking about open-source database management systems, most people prefer MySQL. It is mostly used in web applications for the speed factor. It is fast, reliable, and flexible. MyS… Read More

Introduction to SQL Search String String Search in SQL can be done using the functions available in SQL: PATINDEX, CHARINDEX and LIKE. Full-text is the searching facility that allows the us… Read More

If you want to troubleshoot a slow SQL Server Restore or just find out more about all the restore steps , use these techniques to give you an insight  Code to create the Event Session… Read More

 How To see parameter value on xml_deadlock_report? This article will help us to retrieve the SQL Server deadlock information using the default system-health extended event session.You… Read More

declare @now datetimeselect @now=getdate()select convert(nvarchar(MAX), @now, 1)  ----->    04/28/14                   sel… Read More

DATATYPES IN SQL Data type can be defined as “Type of the value that is stored in a column of a table”. For instance, you want to create a table and have a column that will s… Read More