View charts

Notebook Views for SQL Notebooks in Azure Data Studio

June 15, 2022 by

We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics: What are Notebook Views? Where can you find Notebook Views? How do you create a new view? How do you modify an existing view? Where can you […]

Implicit conversion warning in an execution plan

7 Common T-SQL Query mistakes

June 1, 2022 by

SQL (Structured Query Language) is an ANSI/ISO standard programming language that is designed to program relational databases and T-SQL (Transact-SQL) is an extended implementation of the SQL for Microsoft SQL Server databases. T-SQL is highly used by database persons when they want to program or manage the SQL Server databases. However, the beginners may do […]

Drop temp table: run stored procedure

Drop temp tables in PostgreSQL

March 22, 2022 by

In this article, we are going to learn how we can drop the temp table in PostgreSQL. The temp table is used to store data temporarily. Suppose you want to format or manipulate the data using aggregate and string functions. So instead of processing and formatting the data in the base table, it is preferred […]

security testing for SQL Server environments

Understanding security testing for SQL Server environments

March 3, 2022 by

This article will explain various aspects of security testing for the SQL Server environment. Security is a very critical area for any database environment. We must properly plan, deploy, and audit database security measures to protect and prevent any unauthorized access of the data. We should also perform regular security testing to ensure we have […]