If you are working on SQL programming or learning SQL or how to write queries and looking to test your knowledge or prepare for any SQL interview, the below article can help you.
Read more »
Randheer Parmar
I am a Database Architect Having 16 years of Experience in Database Programming. I have expertise in SOL Server Database. I have Expertise in MSBI Stack and various other BI tool like QlikView, Micro Strategy, Tableau etc.
Skill summary:
1. SQL Server DB Administration
2. SQL Server DB Model Development
3. SQL Server TSQL or complex query writing
4. MSBI SSIS, SSRS, and SSAS expertise
5. Various other BI tool Expertise
Skill summary:
1. SQL Server DB Administration
2. SQL Server DB Model Development
3. SQL Server TSQL or complex query writing
4. MSBI SSIS, SSRS, and SSAS expertise
5. Various other BI tool Expertise
Latest posts by Randheer Parmar (see all)
- Common SQL Interview Questions and Answers - January 6, 2023
- The difference between WHERE and HAVING clause in SQL - December 16, 2022
- Implementing Row-Level Security in Azure Synapse Serverless SQL pools using TSQL - December 5, 2022
The difference between WHERE and HAVING clause in SQL
December 16, 2022This article aims to explain the WHERE, GROUP By, and HAVING clauses in detail. Also, we will see the difference between WHERE and HAVING with examples.
Read more »
Implementing Row-Level Security in Azure Synapse Serverless SQL pools using TSQL
December 5, 2022Row Level Security is a very key requirement for most database or data lake applications. Most of the databases are having natively build row-level security but Synapse serverless SQL pool doesn’t support this inbuilt functionality. In this article, we will see how to implement it.
Read more »