Languages and coding

An overview of the sp_WhoIsActive stored procedure

March 23, 2020 by Rajendra Gupta

This article gives a comprehensive overview of custom stored procedure sp_whoisactive.

Learn SQL: SQL Triggers

March 20, 2020 by Emil Drkusic

SQL Triggers are another powerful database object we have at our disposal. In previous articles, we’ve covered user-defined functions, user-defined procedures, and SQL Views. Today we’ll talk about SQL triggers and how to use them to achieve the desired behavior.

SQL Server MAX() aggregate function

March 19, 2020 by Ahmad Yaseen

SQL Server provides us with several aggregate functions that can be used to perform different types of calculations on a set of values, and return a single value that summarized the input data set. These SQL Server aggregate functions include AVG(), COUNT(), SUM(), MIN() and MAX().

SQL Server TOP clause overview and examples

March 19, 2020 by Rajendra Gupta

This article explores the SQL Server TOP clause using various examples, along the way, we will also run through performance optimization while using the TOP clause in SQL Server.

Monitoring activities using sp_WhoIsActive in SQL Server

March 16, 2020 by Hadi Fadlallah

In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.

CREATE VIEW SQL: Inserting data through views in SQL Server

March 16, 2020 by Bojan Petrovic

This is the third article in a series of learning the CREATE VIEW SQL statement. So far, I’d say that we’re comfortable and familiar with the syntax, and we’ve learned how to create and modify views. In this part, we’ll continue to work on views using the sample database and data that we created so far.

Python scripts for pivot tables in SQL Server

March 13, 2020 by Rajendra Gupta

This article talks about Python scripts for creating pivot tables in multiple ways.

Learn SQL: SQL Views

March 11, 2020 by Emil Drkusic

SQL views are another powerful database object we have at our disposal. In the previous two articles of this series, we’ve talked about user-defined functions and user-defined procedures and showed simple examples of how to use them. Today, we’ll do the same for the SQL views.

A comprehensive guide to the SQL Format function

March 11, 2020 by Rajendra Gupta

This article explains the usage of SQL Format function and performance comparison with SQL CONVERT.

Monitor Transaction Log shipping using T-SQL and SSMS

March 10, 2020 by Jignesh Raiyani

Database Administrators are vigilant on the backup and restore processes and use the Monitor Transaction log for the same. SQL Server Transaction Log shipping’s prime steps are Transaction Log backup, copy and restore. The answer to solving Disaster Recovery (DR) at the database level can be achieved by SQL Server Transaction Log shipping.

SQL Server SESSION_CONTEXT() function with examples

March 9, 2020 by Rajendra Gupta

This article explores the SQL Server session context function, SESSION_CONTEXT() and performs its comparison with the function, CONTEXT_INFO().

Python scripts to format data in Microsoft Excel

March 9, 2020 by Rajendra Gupta

In this article, we will use Python scripts for data formatting in Microsoft Excel sheet with various examples.

Learn SQL: User-Defined Stored Procedures

March 5, 2020 by Emil Drkusic

Stored procedures (SPs) are one more powerful database object we have at our disposal. They can help us handle many tasks and improve performance and security. Today, we’ll take a look at simple SPs and show, on examples, how to use them.

CREATE VIEW SQL: Modifying views in SQL Server

March 5, 2020 by Bojan Petrovic

In my previous article, we looked at how to use the CREATE VIEW SQL statement to create views. In this one, we are moving on and focusing on how to modify views. We will continue using examples on a sample database and data created in the first write-up so in order to follow along, head over and read the Creating views in SQL Server part before starting with this one.

How to use database backups to recover data after SQL Delete and SQL Truncate statements

March 4, 2020 by Rajendra Gupta

This article explores the recovery of data removed by SQL Delete and SQL Truncate statements using SQL database backups.

Overview of the T-SQL If Exists statement in a SQL Server database

March 3, 2020 by Rajendra Gupta

This article walks through different versions of the T-SQL IF EXISTS statement for the SQL database using various examples.

SQL AVG() function introduction and examples

March 2, 2020 by Esat Erkec

In this article, we will learn the SQL Average function which is known as AVG() function in T-SQL. AVG() function is an aggregate function that calculates the average value of a numerical dataset that returns from the SELECT statement.

Learn SQL: User-Defined Functions

February 25, 2020 by Emil Drkusic

You can create several user-defined objects in a database. One of these is definitely user-defined functions. When used as intended, they are a very powerful tool in databases. In today’s article, we’ll see how to create, change and remove them from the database, as well as how to use them. So, let’s dive into the matter.

Learn Jupyter Notebooks for SQL Server

February 25, 2020 by Rajendra Gupta

Introduction

The Jupyter notebook is a powerful and interactive tool that supports various programming languages such as Python, R, Julia. This open-source utility is popular among data scientists and engineers. This notebook integrates both code and text in a document that allows you to execute code, view visualization, solve mathematical equations.

SQL CROSS JOIN with examples

February 24, 2020 by Esat Erkec

In this article, we will learn the SQL CROSS JOIN concept and support our learnings with straightforward examples, which are explained with illustrations.

Learn SQL: Set Theory

February 21, 2020 by Emil Drkusic

The set theory is very important in order to understand data and databases. While you could live without it and still be a good SQL developer, understanding it will surely help a lot. So, let’s dive into the matter.

The PARSEONLY SQL command overview and examples

February 21, 2020 by Rajendra Gupta

This article explores the uses of the SET PARSEONLY SQL command for SQL Server queries.

The internals of SQL Truncate and SQL Delete statements

February 21, 2020 by Rajendra Gupta

This article gives you an insight into the SQL Truncate and SQL Delete commands behavior.

Learn SQL: SQL Data Types

February 14, 2020 by Emil Drkusic

What are SQL data types, why do we need them, and how to use them? Today, we’ll try to answer these questions by giving an overview of some most common data types used in SQL Server.

What is a foreign key in SQL Server

February 13, 2020 by Esat Erkec

In this article, we will seek an answer to an important question – “What is a foreign key in SQL Server?”. At the same time, we will give some seconder answers to this question. In this way, we can understand the foreign key concept more clearly.