DBblogger | Rajendra Gupta

Mastering SQL Server's Power: Unleashing the Potential of Common Table Expressions (CTEs)

Discover the hidden gem of SQL Server: Common Table Expressions (CTEs). In this comprehensive guide, we dive deep into the world of CTEs.

How to Use a Cross Join in SQL Server: A Beginner's Guide

Learn how to use a cross-join in SQL Server.

WAIT_AT_LOW_PRIORITY Feature for DBCC SHRINKFILE in SQL Server 2022

Troubleshoot SQL agent on Linux not starting

Troubleshooting SQL Server Agent on Linux

SQL Server - Where do my SQL Database files reside?

Steps to add Add Identity Column to Table in SQL Server

1,014 views0 comments

SQL Server 2022 - Greatest and Least functions

This video tutorial guides you to learn SQL Server 2022 Greatest and Least functions with examples. #sqlserver #sqlserver2022

Learn SQL Server 2022 – DATE_BUCKET function

This video article explains SQL Server 2022 DATE_BUCKET() function with examples.

SQL Server 2022 - IS [NOT] DISTINCT FROM Predicate

Do you know about the new SQL Server 2022 predicate - IS [NOT] DISTINCT FROM? Explore more in the video.

New Fixed Server Roles in SQL Server 2022

SQL Server 2022 introduces several new fixed server roles to help you manage your database more effectively. Check out the new roles here.