This article explains the xp_cmdshell and sp_xp_cmdshell_proxy_account system stored procedures in SQL Server and how developers can use them to execute Windows commands.
Read more »
SQL commands
Lever the TSQL MAX/MIN/IIF functions for Pinpoint Row Pivots
May 16, 2022Introduction
For a recent Tsql development project involving text document records, the customer wanted a product that would show the latest and most recent earlier version of specific document text stored in a SQL Server 2014 database. One result set row had to hold all relevant information for each document: both document versions as described above, and relevant metadata. This essentially required fine-grained row pivots. This article will describe the engineering behind the solution, and compare that solution with the SQL Server PIVOT operator.
Read more »
An overview of DIFFERENCE and SOUNDEX SQL functions
January 18, 2022This article gives an overview of DIFFERENCE and SOUNDEX SQL Server built-in system functions. It explains how to use those functions and how do they work.
Read more »
Getting started with SQL Server CLR functions
January 11, 2022This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then, we will use the C# library to create user-defined CLR functions in SQL Server.
Read more »
Understanding the SQL MIN statement and its use cases
December 3, 2021Today, I will explain an overview of the SQL MIN () function along with its several use cases in this article. This function is categorized under aggregate functions in SQL Server. Aggregate functions perform a calculation on a set of values from a specified expression and return a single value in their output. Aggregate functions return the same value every time you execute them unless your source data is changed.
Read more »
SQL commands in SQL Server
November 22, 2021Introduction
If you are here, it means that you want to learn the SQL commands. This article applies to SQL Server especially, but most of the theory is similar to Oracle, MySQL, MariaDB, PostgreSQL, and other databases. The SQL commands are instructions that we send to the database to get information, manipulate the information or create objects, modify them, and handle the access to the information.
Read more »
INDEXPROPERTY() function in SQL Database
November 22, 2021This article will give an insight into the INDEXPROPERTY() function in SQL Databases.
Read more »
SQL Syntax Checker Tools
October 27, 2021In this article, we will look at the 2 different SQL syntax checker tools that help to find the syntax errors of the queries without executing them.
Read more »
SQL LEFT function in queries
October 22, 2021In this article, we will learn how to use SQL LEFT function with straightforward examples.
Read more »
An overview of SQL Comments
October 19, 2021In a typical database, we have multi lines or page SQL statements in a view, SQL statement or the stored procedure. Also, multiple developers change the T-SQL, and it becomes difficult to track who altered the code and for what reason.
Read more »
How to write SQL queries with spaces in column names
September 29, 2021In this article, we are going to learn how we can write a SQL query with space in the column name. Blanks spaces are restricted in the naming convention of the database object’s name and column name of the table. If you want to include the blanks space in the object name or column name, the query and application code must be written differently. You must be careful and precise while writing dynamic SQL queries. This article explains how we can handle object names and columns with blank space in SQL Server and MySQL.
Read more »
Popular free SQL online compilers
August 9, 2021This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.
Read more »
Using Stored Procedures with Return Values
August 6, 2021In this article, we will learn how we can use a Stored Procedure with return values with all details.
Read more »
How to write subqueries in SQL
August 3, 2021This article briefly explains how to write a subquery in SQL by providing examples.
Read more »
Understanding SQL Server DBCC DBREINDEX command and its usage
August 2, 2021In this article, I am going to explain the DBCC DBREINDEX statement, its syntax, and its usage. Additionally, I am also going to cover the differences between the DBCC REINDEX and ALTER INDEX statements.
Read more »
How to calculate Subtotals in SQL Queries
July 30, 2021In this article, we will learn how to calculate and add a subtotal in SQL queries.
Read more »
A deep dive into SQL Table Variables
July 28, 2021In this article, we will explore some secrets about SQL Table Variables.
Read more »
File Validation in SQL Server with xp_fileexist
July 6, 2021In this article, we will explore the xp_fileexist extended stored procedure usage and other details. At the same time, we will take a look at alternative methods to this procedure.
Read more »
An overview of the SQL Server ISNUMERIC function
July 2, 2021This article gives an overview of the SQL Server ISNUMERIC built-in system function. It explains how to use this function, illustrates its limitations, and provides some alternatives.
Read more »
An overview of the sp_helptext statement
June 28, 2021In this article, we are learning about the sp_helptext statement. I am going to show the various examples of the usage of it. I will also explain the two alternatives of the sp_helptext statement.
Read more »
SQL GO command in SQL Server
May 18, 2021Introduction
If you are using SQL Server and saw a GO command in a T-SQL script and you do not know what that GO is used for, this article is for you. In this article, we will explain what the SQL GO command is when to use it, and some tips about using it.
Read more »
Learn SQL: How to prevent SQL Injection attacks
May 17, 2021In the previous articles we’ve talked about SQL injection and dynamic SQL but we lacked an answer on how to prevent SQL injection attacks. Today we’ll do exactly that and show you one possible approach to how to do it. We’ll also mention other possible threats and approaches you could take.
Read more »
Impact of SQL Variables on Performance
May 10, 2021In this article, we are going to learn how SQL variables negatively affect query performance and also examine the causes of this issue.
Read more »
Dynamic Data Masking in Azure Synapse Analytics
April 23, 2021This article will take you through the process to apply Dynamic Data Masking on the dedicated SQL pool of Azure Synapse Analytics.
Read more »
Working with parameters in the sp_executesql stored procedure
April 16, 2021This article explains how to use the sp_executesql system stored procedure to run static and dynamic SQL queries and how to pass input and output parameters while using it.
Read more »