Getting Started with the SQL Not Equal To Operator and Its Use Cases
This article will give an overview of the SQL Not Equal To operator and demonstrate how to use it...
31 Must-Know SQL Server DBA Interview Questions – Are You Prepared?
This article will help you to prepare for SQL Server interviews. I have explained various popular SQL Server interview questions and...
An Overview of SQL LIKE Statement and Its Use Cases
SQL LIKE statement is used to search a similar phrase or pattern in a column. It supports ASCII and Unicode pattern matching. This...
SQL IN operator
The SQL IN statement matches a specified value from a list or subquery. It reduces our efforts to...
How to Download, Install and Restore AdventureWorks Database in SQL Server
Sometimes, we need a sample database that has all the required objects along with a large set of data inside the database for our various...
Getting Started with the SQL Server T-SQL CASE Expression Statement
SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple...
Restoring SQL Server Data Warehouse Sample Database AdventureWorksDW2019 Using Azure Data Studio
I explained a step-by-step process to restore the data warehouse sample database AdventureWorks DW...
How to Use SQL Server T-SQL Function SUM: 5 Use Cases
The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column –...
Azure SQL Elastic Pool – Understanding and Creating
Microsoft Azure offers many PAAS services for addressing the database requirements based on the nature of data and transaction workload....
Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases
There are multiple instances when we want to check the permission on a securable for a principal....
