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

Analysis Services : OLEDB Error while processing in SSAS

Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]

5 (3)

You rated this post out of 5. Change rating

2020-02-03

8,127 reads

SQLServerCentral Article

Month-over-Month calculation using DAX in Power BI

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]

3.67 (3)

You rated this post out of 5. Change rating

2020-01-27

76,039 reads

SQLServerCentral Article

Browsing SSAS Instance over the internet

Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]

5 (3)

You rated this post out of 5. Change rating

2019-12-31

8,084 reads

SQLServerCentral Article

Modular ETL Architecture Design in SSIS

Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]

4 (2)

You rated this post out of 5. Change rating

2019-10-21

13,694 reads

SQLServerCentral Article

A User-Defined Function returns more rows

The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]

4 (5)

You rated this post out of 5. Change rating

2019-10-14

4,862 reads

Blogs

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Copilot in Microsoft Fabric

By

Microsoft Copilot is an app that uses AI to help you find information, create content,...

Read the latest Blogs

Forums

Pase keywords in text string

By Bruin

I've been trying to find an example to parse a record that looks for...

Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation

By Rohit Alladi

Comments posted to this topic are about the item Exploring Generative Adversarial Networks (GANs)...

A Valid Type?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Valid Type?

Visit the forum

Question of the Day

A Valid Type?

What happens when I run this code in SQL Server 2019?

DECLARE @variable CURSOR;

See possible answers