sql command

Introduction to SQL Server Temporary Tables

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

We all need to refer to temporary tables quite often. They are necessary to deal with interim aggregations or outputting intermediate results. However, it is also essential to delete temporary tables after using them. 

In this article, we’ll examine the basics of temporary tables and define how they differ from table variables. Then, we’ll learn how to delete temporary tables correctly, and we’ll create a stored procedure for deleting temporary tables in a current session.

(more…)

ADD SENSITIVITY CLASSIFICATION Command in SQL Server 2019

For a database administrator, the common everyday practice involves running multiple operations targeted at ensuring database security and integrity. Thus, we shouldn’t overlook the importance of sensitive data stored in the database under any circumstances. In light of this, we are excited to demonstrate the new ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019, which allows adding the sensitivity classification metadata to database columns.

(more…)