aveek22

Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
https://twitter.com/avikoleum
https://www.linkedin.com/in/aveekd22/

SQLServerCentral Article

How to filter non-existing records in SQL

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4.22 (9)

You rated this post out of 5. Change rating

2021-11-26 (first published: )

15,121 reads

SQLServerCentral Article

Installing Docker Desktop on Mac

Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you remember a few years ago, the only way of deploying application code […]

1 (1)

You rated this post out of 5. Change rating

2021-04-20

1,506 reads

SQLServerCentral Article

Getting started with the SQL MERGE statement

This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]

4 (1)

You rated this post out of 5. Change rating

2021-01-26

4,809 reads

SQLServerCentral Article

Using the RANKX function in Power BI

Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]

5 (1)

You rated this post out of 5. Change rating

2020-03-12

19,844 reads

Blogs

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

By

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...

Read the latest Blogs

Forums

Connect tabular model to excel via Power BI semantic model

By Bhagat

I have a tabular cube, with myself included in one of the roles. I...

New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome

By uratol

  Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...

Helpful Management Studio Settings and Features

By Tony Savoie

Comments posted to this topic are about the item Helpful Management Studio Settings and...

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers