A SQL injection attack is one of the most commonly used hacking techniques. It allows hacks to access information from a database that is otherwise not publically accessible.
Read more »
T-SQL
An overview of SQL String Functions
December 25, 2019In this article, we will try to give a brief overview of the SQL string functions used in SQL Server and we will provide some examples.
Read more »
Learn SQL: Primary Key
December 20, 2019If you’ve already worked with databases, then you could hardly miss the term – Primary Key (PK). And if you’re reading this series and use it to learn about databases, well, this article should give you a good overview of what the PK really is. Still, if you’re a database expert, maybe you’ll find something new or just refresh your knowledge. So, sit back, relax, and let’s dive into PKs.
Read more »
How to create a view in SQL Server
December 16, 2019In this article, we will learn the basics of the view concept in SQL Server and then explore methods to create a view in SQL using T-SQL and SQL Server Management Studio.
Read more »
Learn SQL: INSERT INTO TABLE
December 12, 2019In the previous article, we’ve created two tables, and now we’re ready to use the SQL INSERT INTO TABLE command and populate these tables with data. In order to do so, we’ll prepare statements in Excel and then paste these statements into SQL Server and execute them. We’ll also check the contents of both tables before and after these commands using the SELECT statement. So, let’s start.
Read more »
An overview of SQL Server data types
December 9, 2019In this article, we will give an overview of various SQL Server data types.
Read more »
An overview of the SQL Server Update Join
December 5, 2019This article explores the SQL Server Update Join statement in T-SQL for SQL Server.
Read more »
Learn SQL: CREATE DATABASE & CREATE TABLE Operations
December 5, 2019Welcome to the first article in the Learn SQL series. In this part, we’ll start with two essential commands in SQL: Create Database and Create Table. While both are pretty simple, they should be used first before you start working on anything with data (unless you use some template database).
Read more »
The Table Variable in SQL Server
December 3, 2019In this article, we will explore the table variable in SQL Server with various examples and we will also discuss some useful tips about the table variables.
Read more »
SQL Variables: Basics and usage
November 18, 2019In this article, we will learn the notions and usage details of the SQL variable. In SQL Server, local variables are used to store data during the batch execution period. The local variables can be created for different data types and can also be assigned values. Additionally, variable assigned values can be changed during the execution period. The life cycle of the variable starts from the point where it is declared and has to end at the end of the batch. On the other hand, If a variable is being used in a stored procedure, the scope of the variable is limited to the current stored procedure. In the next sections, we will reinforce this theoretical information with various examples
Read more »
Read SQL Server error logs using the xp_readerrorlog command
November 14, 2019This article explores the xp_readerrorlog command for reading SQL Server error logs using T-SQL.
Read more »
SQL OFFSET FETCH Feature: Loading Large Volumes of Data Using Limited Resources with SSIS
November 14, 2019In this article, we illustrate how to use the OFFSET FETCH feature as a solution for loading large volumes of data from a relational database using a machine with limited memory and preventing an out of memory exception. We describe how to load data in batches to avoid placing a large amount of data into memory.
Read more »
Manage Unicode Characters in Data Using T-SQL
November 7, 2019In this article, I’ll provide some useful information to help you understand how to use Unicode in SQL Server and address various compilation problems that arise from the Unicode characters’ text with the help of T-SQL.
Read more »
Overview of DBCC INPUTBUFFER and sys.dm_exec_input_buffer DMF
November 7, 2019This article gives an overview of the DBCC INPUTBUFFER and its replacement sys.dm_exec_input_buffer system dynamic management function .
Read more »
SQL While loop: Understanding While loops in SQL Server
November 6, 2019The SQL While loop is used to repeatedly execute a certain piece of SQL script.
Read more »
SQL Carriage Returns or Tabs in SQL Server strings
November 4, 2019This article explores inserting SQL carriage return AKA line break and tab in a string along with SSMS behavior while copying data to excel, notepad.
Read more »
SQL WHILE loop with simple examples
October 25, 2019SQL WHILE loop provides us with the advantage to execute the SQL statement(s) repeatedly until the specified condition result turn out to be false.
Read more »
Implementing SQL data types
October 23, 2019This article is about many different SQL data types that we use when working with SQL Server. We will start with a quick overview and go through some stuff like categories of data types, what objects we can work with, and how to create our own custom data types.
Read more »
Overview of the Collate SQL command
October 22, 2019In this article, we will review the Collate SQL command. First, let us see what collation in the SQL Server is.
Read more »
Prepare ZIP or RAR files in SQL Server Using xp_cmdshell (T-SQL)
October 21, 2019Microsoft SQL Server offers the ability to export data into CSV, Excel, PDF and other formats with the help of xp_cmdshell in T-SQL.
Read more »
Methods to avoid the SQL divide by zero error
October 21, 2019This article explores the SQL divide by zero error and various methods for eliminating this.
Read more »
SET QUOTED_IDENTIFIER settings in SQL Server
October 17, 2019In 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.
Read more »
SQL multiple joins for beginners with examples
October 16, 2019In 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:
Read more »
An overview of the SQL table variable
October 16, 2019This article explores the SQL Table variables and their usage using different examples.
Read more »
SQL Lag function overview and examples
October 15, 2019In 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.
Read more »