sql command

Using SQLite ODBC with .NET on Simple Examples

If you want to know everything about SQLite ODBC and how to use it with .NET, you are on the right way. In this article, we will consider the SQLite ODBC driver, SQL ODBC connection string, SQLite database manager with GUI, and code examples in .Net.

(more…)

Introduction to SQL Server Temporary Tables

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…)

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox