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 »
Development
Understanding the SQL EXCEPT statement with examples
December 23, 2019The SQL EXCEPT statement is one of the most commonly used statements to filter records when two SELECT statements are being used to select records.
The SQL EXCEPT statement returns those records from the left SELECT query, that are not present in the results returned by the SELECT query on the right side of the EXCEPT statement.
Read more »
Send an alert when the database state changes to SQL Server single-user mode
December 18, 2019This article explains the SQL Server single-user mode and how to configure an automated email alert when the state of the user database changes to the single-user mode. To send an alert, we will create a DDL trigger that executes when the user runs the ALTER DATABASE query. It collects the pieces of information using EVENTDATA() function, saves it in a temporary table, and sends an HTML formatted email.
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 »
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 »
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 »
Using multi-value parameters in SSRS
November 27, 2019This article covers the usage and detailed features of the multi-value parameter in SSRS.
Read more »
SQL Table Variable Deferred Compilation in SQL Server 2019
November 25, 2019In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Let’s have a quick recap of the table variable:
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 »
SQL DDL: Getting started with SQL DDL commands in SQL Server
November 8, 2019This article explains SQL DDL commands in Microsoft SQL Server using a few simple examples.
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 JOIN TABLES: Working with Queries in SQL Server
November 6, 2019In this article, you will see how to use different types of SQL JOIN tables queries to select data from two or more related tables.
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 »
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 »
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 »
Dynamic Data Masking In SQL Server
October 15, 2019Security 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.
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 »
A Walkthrough of SQL Schema
October 9, 2019This article gives an overview of SQL Schema and its usage in SQL Server.
Read more »
SQL Server PRINT and SQL Server RAISERROR statements
October 2, 2019This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.
Read more »
Truncate Table Operations in SQL Server
September 25, 2019Truncating 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.
Read more »