Development

SQL While loop: Understanding While loops in SQL Server

November 6, 2019 by Ben Richardson

The SQL While loop is used to repeatedly execute a certain piece of SQL script.

SQL JOIN TABLES: Working with Queries in SQL Server

November 6, 2019 by Ben Richardson

In this article, you will see how to use different types of SQL JOIN tables queries to select data from two or more related tables.

SQL Carriage Returns or Tabs in SQL Server strings

November 4, 2019 by Rajendra Gupta

This article explores inserting SQL carriage return AKA line break and tab in a string along with SSMS behavior while copying data to excel, notepad.

SQL WHILE loop with simple examples

October 25, 2019 by Esat Erkec

SQL WHILE loop provides us with the advantage to execute the SQL statement(s) repeatedly until the specified condition result turn out to be false.

Overview of the Collate SQL command

October 22, 2019 by Ranga Babu

In this article, we will review the Collate SQL command. First, let us see what collation in the SQL Server is.

Methods to avoid the SQL divide by zero error

October 21, 2019 by Rajendra Gupta

This article explores the SQL divide by zero error and various methods for eliminating this.

SET QUOTED_IDENTIFIER settings in SQL Server

October 17, 2019 by Rajendra Gupta

In this article, we will explore QUOTED_IDENTIFIER behavior, default value, and comparison with a different value. Set options at connection level control query behavior in SQL Server. The query might behave differently with different set options and their values.

SQL multiple joins for beginners with examples

October 16, 2019 by Esat Erkec

In this article, we will learn the SQL multiple joins concept and reinforce our learnings with pretty simple examples, which are explained with illustrations. In relational databases, data is stored in tables. Without a doubt, and most of the time, we need a result set that is formed combining data from several tables. The joins allow us to combine data from two or more tables so that we are able to join data of the tables so that we can easily retrieve data from multiple tables. You might ask yourself how many different types of join exist in SQL Server. The answer is there are four main types of joins that exist in SQL Server. First of all, we will briefly describe them using Venn diagram illustrations:

An overview of the SQL table variable

October 16, 2019 by Rajendra Gupta

This article explores the SQL Table variables and their usage using different examples.

Dynamic Data Masking In SQL Server

October 15, 2019 by Ben Richardson

Security has been one of the prime concerns of database developers since the inception of database management systems. Various data protection schemes have been introduced to provide secure access to sensitive data.

SQL Lag function overview and examples

October 15, 2019 by Rajendra Gupta

In the article SQL Server Lead function overview and examples, we explored Lead function for performing computational operations on data. This article gives an overview of the SQL Lag function and its comparison with the SQL Lead function.

A Walkthrough of SQL Schema

October 9, 2019 by Rajendra Gupta

This article gives an overview of SQL Schema and its usage in SQL Server.

SQL Server PRINT and SQL Server RAISERROR statements

October 2, 2019 by Rajendra Gupta

This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.

Truncate Table Operations in SQL Server

September 25, 2019 by Dinesh Asanka

Truncating a table is removing all the records in an entire table or a table partition. TRUNCATE table is functionally similar to DELETE table with no WHERE clause. However, TRUNCATE table is much faster than DELETE with respect to the time and the resource consumptions which we will look at in this article. TRUNCATE statement removes the data by de-allocating the data pages in the table data. This means that TRUNCATE is similar to drop and re-create the table. Also, it records only the page de-allocations in the transaction log, not the row-wise as in DELETE statement.

Alternate Row Colors in SSRS

September 20, 2019 by Dinesh Asanka

Setting alternate row colors in SSRS (SQL Server Reporting Services) is an important visualization configuration for end-users so that they can easily view their reports. However, setting alternate colors in SSRS is not a click of a button configuration like in the Microsoft Excel.

T-SQL RegEx commands in SQL Server

September 17, 2019 by Rajendra Gupta

This article explores T-SQL RegEx commands in SQL Server for performing data search using various conditions.

SQL Server multi-statement table-valued functions

September 11, 2019 by Esat Erkec

In this article, we will learn multi-statement table-valued functions (MSTVFs) basics and then we will reinforce our learnings with case scenarios.

Overview of SQL LOWER and SQL UPPER functions

September 10, 2019 by Rajendra Gupta

This article gives an overview of SQL UPPER function and SQL LOWER function to convert the character case as uppercase and lowercase respectively.

Overview of the SQL DELETE Column from an existing table operation

September 6, 2019 by Rajendra Gupta

In this article, we will explore the process of SQL Delete column from an existing table. We will also understand the impact of removing a column with defined constraints and objects on it.

SSIS Conditional Split overview

September 4, 2019 by Dinesh Asanka

SQL Server Integration Services or SSIS is used as an ETL tool to extract-transform-load data from heterogeneous data sources to different databases. After extracting data from the different sources, most often there are a lot of transformations needed. One of the frequent transformations is SSIS Conditional Split.

Different ways to SQL delete duplicate rows from a SQL Table

August 30, 2019 by Rajendra Gupta

This article explains the process of performing SQL delete activity for duplicate rows from a SQL table.

SQL Injection: Detection and prevention

August 30, 2019 by Ed Pollack

Summary

With an understanding of what SQL injection is and why it is important to an organization, we can shift into a discussion of how to prevent it. We ultimately want systems where SQL injection is impossible or very difficult to pull off. We then want systems where exploiting bugs is slow, laborious, and likely to raise monitoring alarms within an organization when attempted. The trio of layered security, prevention, and alerting can provide an immense advantage against not only SQL injection, but other data security threats.

SQL Injection: What is it? Causes and exploits

August 30, 2019 by Ed Pollack

Summary

Many security vulnerabilities are discovered, patched, and go away forever. Some linger and continue to plague software development and will continue to do so for years to come. Setting aside social engineering and non-technical attacks, SQL injection remains one of the top security threats to our data, as well as one of the most misunderstood.

SQL Server inline table-valued functions

August 29, 2019 by Esat Erkec

In this article series, we will find basics and common usage scenarios about the inline table-valued functions and we will also be consolidating your learnings with practical examples.

SQL Server ALTER TABLE ADD Column overview

August 27, 2019 by Dinesh Asanka

In this article, we will explore SQL Server ALTER TABLE ADD Column statements to add column(s) to an existing table. We will also understand the impact of adding a column with a default value and adding and updating the column with a value later on larger tables.