In 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 »
Languages and coding
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 »
SQL queries to change the column type
September 22, 2021This article covers the different SQL queries to change the column type. We are going to learn how we can change the data type of the columns of the following databases:
Read more »
Getting started with the Azure Queue Storage using Python
September 14, 2021In this article, we are going to talk about the Azure Queue Storage service using python as a programming language. As it goes by the name, Azure Queue Storage is a simple queue and messaging service in Azure that can be used to build queues and process messages in an asynchronous fashion. Queues help to decouple multiple systems and provide the middle layer in a distributed architecture. The Queue Storage service in Azure allows users to connect to and store messages up to 64 KB in size from anywhere in the world. It is exposed by using HTTP or HTTPS endpoints and can contain millions of messages that need to be processed.
Read more »
Working with Python in Power BI
August 26, 2021In this article, we are going to learn about working with Python in Power BI. Power BI has been adding a lot of features to it recently and one of the most essential was adding Python functionality to it. Users are now able to run Python scripts directly from within Power BI. Python is a great programming language, especially when it comes to the field of data analysis. Most of the machine learning frameworks and data science libraries are written in Python and there is a huge community of open-source programmers that maintain and promote the use of Python along with these libraries.
Read more »
How to gain advanced T-SQL programming skills
August 11, 2021This article aims to provide various tricks that help to gain advanced T-SQL programming skills.
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 »
DDL triggers in Azure SQL Database
July 28, 2021This article explores database DDL triggers for auditing Data Definition Language (DDL) on Azure SQL Database.
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 »
Common Table Expressions for Database Developers
June 24, 2021Introduction
Though the Common Table Expressions (CTE) were introduced to SQL Server more than a decade ago with the SQL Server 2005 version, still this is not much utilized by database developers due to the unawareness. This article provides what and how you can utilize the CTE effectively and efficiently.
Read more »
GROUP BY ROLLUP for Data Analysis
June 23, 2021Introduction
In this article, we are looking at T-SQL commands of GROUP BY ROLLUP to aggregate data and improve the data analytical capabilities in SQL Server.
Read more »
Querying JSON documents in Azure Cosmos DB using the SQL API
May 21, 2021In this article, we will look briefly at the Azure Cosmos DB service and how you can query JSON documents to store, retrieve and process data using the SQL Application Programming Interface (API).
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 »
Different approaches to execute Python in SQL Server
May 10, 2021This article briefly explains how to execute scripts written in Python in SQL Server and how Machine Learning services facilitate this process.
Read more »