In this article I describe the Transact-SQL security functions SUSER_ID , SUSER_NAME , SUSER_SID , SUSER_SNAME and SYSTEM_USER.

In this article, I describe the Transact-SQL security functions IS_MEMBER , IS_SRVROLEMEMBER , LOGINPROPERTY, ORGINAL_LOGIN, and PERMISSION.

In this article, I describe the Transact-SQL security functions CURRENT_USER, HAS_DBACCESS, HAS_PERMS_BY_NAME, and HASHBYTES.

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is language-independent, easy to understand, and self-describing. It is used as an alternative to XML. JSON is a very ...

SQL Server 2022, the latest version of Microsoft's popular relational database management system, comes with significant improvements to the performance of Tempdb.

This article explains how to create a SSRS report using a SQL parameterized Stored Procedure object.

This article demonstrates how to copy a table with data from one database to another in a SQL Server database.

This article helps you understand how inner queries work in relation to outer queries and what problems they can create if not used in a proper manner.

In this article, we will learn how to create an SSRS report, how to configure the SQL server reporting server, and how to deploy the SSRS report.

In this article, you will see the Complete Reference - Set Operations in MS SQL: UNION [ALL], INTERSECT, EXCEPT.

Merge Statement is a very popular clause in SQL. It handles Insert, Update and Delete in a single query no need to write different logics for each.

This article describes the most common uses of square brackets in SQL Server with examples.

To capture and store the SQL Server database integrity history using DBCC CHECKDB.

Hello Learners. Hope you all are doing great. I am writing this article to get an understanding of parameter sniffing. What it is all about and how it is related to performance sometimes.

This article is an attempt to explain what Parameter Sniffing is all about and how it affects the performance of a Stored Procedure.

SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server. It’s a powerful replacement for the legacy DTS (Data Tr...

In this article, you will learn about the most important SQL Commands.

This article presents an overview on how to create a simple SSRS report.

This article is about creating and providing database access role to a new user in SQL Server.

In this article, you will learn how to deploy an Analysis Services Project (SSAS).