How to generate the alter table SQL script in using SSMS.

You can optimize your queries to obtain simple and elegant solutions to a variety of problems by using Window Functions in T-SQL. In this video tutorial, let us learn how.

T-SQL (Transact-SQL) is a Microsoft extension to the SQL (Structured Query Language). T-SQL is central to using Microsoft SQL Server. In this course, you will learn the basics of this language in a...

In this video, you will get to know how to resolve the error - 'Microsoft SQL Management Studio Package' failed to load.

Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.

In this video tutorial, we will learn how we can create a Foreign Key in a child table referencing its parent table. And, we will try to understand the concept of foreign keys through GUI.

In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.

In this video session, we will quickly walk through the steps of creating a simple Database in SQL Server 2017 Express Edition.

Learn how to create a Unique Key Constraint in SQL Server through GUI without writing any T-SQL query.

In this video, we will learn to make custom functions or User-Defined Functions in SQL Server Deterministic by using the "SCHEMABINDING" keyword.

In this video, we are going to learn about adding a computed column by using a user-defined function, also known as Custom Function. --Create a function (NON DETERMINISTIC) CREATE FUNCTION [dbo].[M...

Learn to create a Computed Column in SQL Server through Management Studio GUI without writing T-SQL.

In this training video, we will learn how to generate SELECT (INNER JOIN) Query through Criteria pane, SQL Pane, and Diagram Pane. We will not write query ourselves; instead, we will use SSMS GUI t...

In this video , we will learn how to create dynamic pivot table in SQL server in just 10 minutes

In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.

In this video, we will look into the encryption of SQL Server Database using TDE.

In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.

In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.

This video shows enabling SQLCLR through, Surface area configuration tool.

This video shows creating a C# function and then deploying it in the SQL Server. After deployment, the function can be used as SQL Server built-in function.